1054 -
select count(1) as cantidad from (select distinct p.products_id, p.mg_rubro, IF(p.product_grouper_id, CONCAT("g_", p.product_grouper_id), p.products_id) as p_group_id, (p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) as products_quantity, p.products_quantity_future, CONCAT (c.categories_id) AS categories_id, false as is_grouped, p.products_model , pd.products_name, p.products_date_added as pdate_added, tr.tax_priority from products p inner join products_description pd on p.products_id = pd.products_id and pd.language_id inner join categories c on c.categories_id = main_category_id left join specials s on p.products_id = s.products_id and s.status = 1 and (s.expires_date is null or DATE(CURDATE()) <= DATE(s.expires_date) ) and ( s.start_date is null or DATE(CURDATE()) >= DATE(s.start_date) ) left join mods_configurable_products_prices mcpp on p.products_id = mcpp.products_id left join manufacturers m on p.manufacturers_id = m.manufacturers_id inner join (SELECT * FROM dummy_categories ORDER BY categories_order) as categories_ordered on main_category_id = categories_ordered.categories_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on tr.tax_zone_id = gz.geo_zone_id where c.categories_status = 1 and p.products_status = 1 and p.is_rentable = 0 and (p.products_price > 0 or p.show_priceless = 1) and p.configurable_products_only = 0 and ( gz.zone_country_id is null or gz.zone_country_id = 0 or gz.zone_country_id = 0) and ( gz.zone_id is null or gz.zone_id = 0 or gz.zone_id = 0) and m.manufacturers_id in (27aamp) group by p.products_id, tr.tax_priority order by categories_ordered.categories_order asc, p.orden asc, products_name asc, p.products_model asc) as tabla
[TEP STOP]
