SELECT DISTINCT p.*, `pd`.`name`,`pd`.`description` FROM `cm_product_to_store` `p2s` LEFT JOIN `cm_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p2s`.`store_id` = '0' AND `p`.`date_available` <= NOW()) LEFT JOIN `cm_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '2' AND `p`.`makes` LIKE '%"ford"%' AND p.status>0