SELECT   p.product_id,p.vendor_id,p.pin_status,p.pid,p.category_id,p.self_category_id,p.product_name, p.flag_wholesaler,p.parent_id,p.margin,p.margin_amount,p.stock,p.basic_price as price,p.old_price,pr.combo,CASE WHEN pr.combo > 0 THEN count(pr.combo) ELSE 0 END  FROM products p  left JOIN products pr on p.parent_id = pr.product_id   WHERE p.status = 1  AND  ((p.parent_id > 0 AND p.stock = 1) OR (p.parent_id = 0 AND p.stock = 1)) AND `p`.`vendor_id` = 513  AND cast(p.basic_price AS SIGNED) > 0  AND cast(p.old_price AS SIGNED) > 0  AND p.combo=0  AND p.direct_ship = 0   GROUP BY CASE WHEN pr.combo > 0 THEN pr.combo ELSE p.product_id END  ORDER BY p.stock DESC,p.pin_status DESC,p.product_id DESC  limit 24 OFFSET 0