Aiwa

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, (p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) as without_quantity_future_stock 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 left join (select * from mods_file_deqs where class = "Product") mfdp on p.products_id = mfdp.parent_id left join products_images pri on p.products_id = pri.products_id where (mfdp.filename is not null OR pri.image is not null) and m.manufacturers_id in (3) and p.is_rentable = 0 and p.products_price > 0 and ((p.products_quantity + IF((p.products_quantity_future) IS NULL, 0, p.products_quantity_future) - 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]