SELECT pro.cmarca, count(pro.cmarca) as total FROM tbl_producto pro, tbl_sub_categoria sub, tbl_dominio c, tbl_categoria cat WHERE sub.domain_id = c.domain_id AND c.id_categoria = cat.id AND pro.category_id = sub.category_id AND cat.id = 5 AND sub.domain_id = 'MLM-PHOTOGRAPHY_ACCESSORIES_AND_REPLACEMENTS' GROUP BY pro.cmarca ORDER BY pro.cmarca
