SELECT f.filter_id, fd.name AS filter_name,fg.filter_group_id, fgd.name AS filter_group_name  FROM `ew_product_to_store` `p2s` JOIN `ew_product` `p` ON (`p`.`product_id` = `p2s`.`product_id`)  LEFT JOIN `ew_product_to_category` `p2c` ON (`p`.`product_id` = `p2c`.`product_id`) LEFT JOIN `ew_category_to_store` `c2s` ON (`p2c`.`product_id` = `c2s`.`category_id`) LEFT JOIN `ew_product_filter` `pf` ON (`p`.`product_id` = `pf`.`product_id`) JOIN ew_filter f ON (pf.filter_id = f.filter_id) JOIN ew_filter_group fg ON (f.filter_group_id = fg.filter_group_id)
			LEFT JOIN ew_filter_description fd ON (f.filter_id = fd.filter_id AND fd.language_id = '1')
			LEFT JOIN ew_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id AND fgd.language_id = '1')  LEFT JOIN `ew_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id` AND `pd`.`language_id` = '1') WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW()  AND `p2c`.`category_id` = '20' GROUP BY f.filter_id ORDER BY fg.sort_order,f.sort_order ASC