Resultado Búsqueda

1064 -

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 products_options_parent_id in (52) and products_options_values_parent_id in () and p.is_rentable = 0 and p.products_price > 0 and ((p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) > 0 or p.products_ignore_stock = 1) 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]