SELECT p.product_id, SUM(op.quantity) AS total_sold FROM grd_order_product op LEFT JOIN grd_`order` o ON (op.order_id = o.order_id) LEFT JOIN grd_product p ON (p.product_id = op.product_id) LEFT JOIN grd_product_to_category p2c ON (p2c.product_id = p.product_id) WHERE o.order_status_id > 0 AND o.date_added >= DATE_SUB(NOW(), INTERVAL 1 MONTH) AND p.status = 1 AND p.quantity > 0 AND p.price > 0 AND p.date_available <= NOW() AND p2c.category_id = 90052 GROUP BY p.product_id ORDER BY total_sold DESC LIMIT 0,6