1021 -
SELECT DISTINCT p.product_grouper_id, p.products_id FROM products p INNER JOIN products_description pd on p.products_id = pd.products_id and pd.language_id = 0 INNER JOIN categories c on c.categories_id = main_category_id LEFT JOIN mods_product_groupers mpg on p.product_grouper_id = mpg.id AND mpg.is_rentable = 0 LEFT JOIN (select products_id, concat('_', group_concat(options_values_id SEPARATOR '_'), '_') as options_values_ids from products_attributes group by products_id having options_values_ids like '%\_374\_%') pa0 on p.products_id = pa0.products_id where p.products_status = 1 and c.categories_status = 1 and p.is_rentable = 0 and (p.products_price > 0 or p.show_priceless = 1) and p.configurable_products_only = 0 and pa0.products_id is not null and p.product_grouper_id is not null GROUP BY p.products_id ORDER BY product_grouper_id
[TEP STOP]
