select count(distinct p.products_id) as total from products_description pd join products p on p.products_id = pd.products_id left join manufacturers mfg on p.manufacturers_id = mfg.manufacturers_id left join specials s on p.products_id = s.products_id join products_to_categories p2c on p.products_id = p2c.products_id join categories c on p2c.categories_id = c.categories_id left join products_to_model p2m on p.products_id = p2m.products_id left join products_model m on p2m.model_id = m.model_id join categories_description cd on p2c.categories_id = cd.categories_id where p.products_status = '1' and pd.language_id = '1' and (() OR (m.model_name = 'Bemine 150cc')) AND cd.categories_name = 'All Parts'
