MOTO/AUTO

1021 -

select te.products_options_id, te.products_options_name as nombre, te.display_label as label, m.manufacturers_id as manufacturerId, GROUP_CONCAT(distinct pa.options_values_id SEPARATOR ", ") as options_values_id from products_attributes pa inner join products_options te on pa.options_id = te.products_options_id inner join products_options_values pov on pa.options_values_id = pov.products_options_values_id left join products p on p.products_id = pa.products_id left join products_to_categories p2c on p.products_id = p2c.products_id left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on s.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id left join mods_product_groupers mpg on p.product_grouper_id = mpg.id where p2c.categories_id in (3) and p.is_rentable = 0 and p.products_price > 0 and p.products_status = 1 and te.show_in_filter = 1 and te.products_options_parent_id = 0 group by pa.options_id order by te.products_options_parent_id asc, te.products_options_name asc

[TEP STOP]