SELECT `site_catalog`.`link`, `site_catalog`.`name_en` as name, `site_catalog`.`image`, `site_catalog`.`id`, `site_catalog`.`categoryid`, `site_catalog`.`in_stock`, `site_catalog`.`kod`, `site_category`.`name_en` as cat_name, `site_catalog`.`price`
FROM (`site_catalog`)
JOIN `site_category` ON `site_category`.`id` = `site_catalog`.`categoryid`
WHERE `site_catalog`.`id` != 96
AND `site_catalog`.`visible` = 1
AND `site_catalog`.`categoryId` = '54'
ORDER BY RAND()
LIMIT 4
Turntable trailer to headers CLAAS Sunspeed 1270
