SELECT `site_catalog`.`link`, `site_catalog`.`name_ru` as name, `site_catalog`.`image`, `site_catalog`.`id`, `site_catalog`.`categoryid`, `site_catalog`.`in_stock`, `site_catalog`.`kod`, `site_category`.`name_ru` as cat_name, `site_catalog`.`price`
FROM (`site_catalog`)
JOIN `site_category` ON `site_category`.`id` = `site_catalog`.`categoryid`
WHERE `site_catalog`.`id` != 19
AND `site_catalog`.`visible` = 1
AND `site_catalog`.`categoryId` = '55'
ORDER BY RAND()
LIMIT 4
Сегмент John Deere MS Z93077
