Packaging and Shipping Solutions
Phone714-666-2800
Fax 714-666-2802
1310 N Kraemer Blvd Anaheim, CA 92806


SiteLock
Online Payments
Site secured by:
SELECT Top 1 products.idProduct AS idProd, Max(discountsPerQuantity.num) AS maxBracketCount FROM (products INNER JOIN (categories INNER JOIN categories_products ON categories.idCategory = categories_products.idCategory) ON products.idProduct = categories_products.idProduct) LEFT JOIN discountsPerQuantity ON products.idProduct = discountsPerQuantity.idproduct GROUP BY categories.idCategory, products.idProduct HAVING categories.idCategory=1427 ORDER BY Max(discountsPerQuantity.num) DESC; ...3021error in DB read rsMaxBrackets