SELECT DISTINCT p.*, `pd`.`name`,`pd`.`description` FROM `hd_product_to_store` `p2s` LEFT JOIN `hd_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 `hd_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '2' AND `p`.`manufacturer_id` = '2019' AND p.status>0