SELECT p.products_id, p.products_price_sorter, p.master_categories_id, p.manufacturers_id FROM zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id) LEFT JOIN zen_products_description pd on p.products_id = pd.products_id JOIN zen_products_to_categories p2c on p.products_id = p2c.products_id JOIN zen_categories c on p2c.categories_id = c.categories_id LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 2 WHERE (p.products_status = 1 AND pd.language_id = 2 AND ((pd.products_name LIKE '%forestiere%' OR p.products_model LIKE '%forestiere%' OR m.manufacturers_name LIKE '%forestiere%' OR (mtpd.metatags_keywords LIKE '%forestiere%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%forestiere%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%forestiere%') )) GROUP BY p.products_id order by p.products_sort_order, pd.products_name

SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(3886,2098,4172,3997,3874,3759,2100,3933,3932,2105,3926,3927,3922,3916,2101,3242,3729,3727,3851,3820,2803,3834,4173,2104,4161,3836,2102,2103,3665,3739,3968,3908,3909,3907,3692,3901,4171,3895,3724,3694,3903,3899,3964,4166,3900), 1, 0)) as flag FROM zen_products_attributes p2a  JOIN zen_products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN zen_products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 WHERE p2a.products_id IN (2098,2100,2101,2102,2103,2104,2105,2803,3242,3665,3692,3694,3724,3727,3729,3739,3759,3895,3820,3834,3836,3851,3874,3886,3899,3900,3901,3903,3907,3908,3909,3916,3922,3926,3927,3932,3933,3964,3968,3997,4161,4166,4171,4172,4173) AND p2a.options_id IN (8,10) AND p2a.options_id NOT IN (4,5,6,7,2,3,1) GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_sort_order, pov.products_options_values_sort_order