SELECT DISTINCT p.*, `pd`.`name`,`pd`.`description` FROM `cm_category_to_store` `c2s` LEFT JOIN `cm_product_to_category` `p2c` ON (`p2c`.`category_id` = `c2s`.`category_id` AND `c2s`.`store_id` = '0') LEFT JOIN `cm_product_to_store` `p2s` ON (`p2s`.`product_id` = `p2c`.`product_id` AND `p2s`.`store_id` = '0') LEFT JOIN `cm_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p`.`date_available` <= NOW()) LEFT JOIN `cm_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '1' AND `p2c`.`category_id` = '22822' AND p.status>0