SELECT p.modelid, pb.model_name, pb.seo_url, pb.image, count( productid ) AS total FROM `product` p LEFT JOIN `product_models` pb ON ( p.modelid = pb.modelid ) WHERE p.brandid <> '' AND p.modelid <> '' AND p.producttype = 'car' AND p.categoryid <> 'aussie' GROUP BY p.modelid, pb.model_name, pb.seo_url, pb.image HAVING total > 0 ORDER BY pb.model_nameTuff Tonneaus|The best soft tonneau covers, hard tonneau covers and tonneau cover accessories