0 -

select count(p.products_id) as total from products p left join specials s on p.products_id = s.products_id left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id left join products_attributes pa on p.products_id = pa.products_id left join products_to_categories p2c on p2c.products_id = p.products_id left join categories c on p2c.categories_id = c.categories_id left join products_options po on pa.options_id = po.products_options_id left join products_options_values pov on pov.products_options_values_id = pa.options_values_id where pov.products_options_values_id = and po.products_options_id = and pa.products_attributes_status = 1 and p.products_status = 1 and pov.language_id = '2' and pd.language_id = '2' and po.language_id = '2' and c.categories_status = 1 and c.categories_id in (0) and c.store_id = 1

[TEP STOP]