SELECT DISTINCT mos_pshop_product.product_id as num_rows FROM mos_pshop_product, mos_pshop_category, mos_pshop_product_category_xref,mos_pshop_shopper_group LEFT JOIN mos_pshop_product_price ON mos_pshop_product.product_id = mos_pshop_product_price.product_id WHERE mos_pshop_product_category_xref.category_id=mos_pshop_category.category_id AND mos_pshop_product_category_xref.category_id='ddab26651385be355147fd012f6a0db6' AND mos_pshop_product.product_id=mos_pshop_product_category_xref.product_id AND mos_pshop_product.product_parent_id='0' AND mos_pshop_product.product_publish='Y' AND ((mos_pshop_shopper_group.shopper_group_id=mos_pshop_product_price.shopper_group_id ) OR (mos_pshop_product_price.product_id IS NULL)) GROUP BY mos_pshop_product.product_sku ORDER BY mos_pshop_product.product_name ASC