Our Top Sellers

Error 3709: The connection cannot be used to perform this operation. It is either closed or invalid in this context.

SQL SELECT Top 10 sfProducts.prodID, sfProducts.prodImageSmallPath, Sum(sfOrderDetails.odrdtQuantity) AS OrderQty FROM (sfOrders RIGHT JOIN sfOrderDetails ON sfOrders.orderID = sfOrderDetails.odrdtOrderId) LEFT JOIN sfProducts ON sfOrderDetails.odrdtProductID = sfProducts.prodID WHERE (sfProducts.prodEnabledIsActive=1) And (IncludeInRandomProduct=-1) AND sfOrders.orderDate >=#9/6/2009# GROUP BY sfProducts.prodID, sfProducts.prodImageSmallPath, sfOrders.orderIsComplete, sfProducts.prodEnabledIsActive, IncludeInRandomProduct HAVING ((sfOrders.orderIsComplete=1)) ORDER BY Sum(sfOrderDetails.odrdtQuantity) DESC