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
Сегмент John Deere MS Z93077
В наличии
Оставьте свой номер телефона и мы Вам перезвоним