QUERY = SELECT CubeCart_inventory.productId, CubeCart_inventory.name, CubeCart_inventory.price, CubeCart_inventory.description, CubeCart_inventory.image, CubeCart_inventory.active, CubeCart_inventory.price, CubeCart_inventory.name, CubeCart_inventory.remixer, CubeCart_inventory.label, CubeCart_inventory.bpm, CubeCart_inventory.genre, added, length, SUM(CubeCart_order_inv.quantity) AS total FROM CubeCart_order_inv INNER JOIN CubeCart_inventory ON CubeCart_inventory.productId = CubeCart_order_inv.productId INNER JOIN CubeCart_order_sum ON CubeCart_order_inv.cart_order_id = CubeCart_order_sum.cart_order_id INNER JOIN CubeCart_category ON CubeCart_category.cat_id = CubeCart_inventory.cat_id WHERE CubeCart_inventory.release = '0' && CubeCart_inventory.active = '1' && CubeCart_inventory.showin != 'Pool' && CubeCart_order_sum.status='2' GROUP BY CubeCart_order_inv.productId ORDER BY total DESC