SELECT COUNT(DISTINCT #__{vm}_product.product_sku) as num_rows FROM (#__{vm}_product, #__{vm}_category, #__{vm}_product_category_xref,#__{vm}_shopper_group) LEFT JOIN #__{vm}_product_price ON #__{vm}_product.product_id = #__{vm}_product_price.product_id WHERE #__{vm}_product_category_xref.category_id=#__{vm}_category.category_id AND #__{vm}_product_category_xref.category_id='52' AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id AND #__{vm}_product.product_parent_id='0'  AND product_publish='Y'AND ((#__{vm}_shopper_group.shopper_group_id=#__{vm}_product_price.shopper_group_id ) OR (#__{vm}_product_price.product_id IS NULL))