INVALID SQL: 1052 : Column 'price' in order clause is ambiguous SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_pricing, xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid INNER JOIN xcart_price_classification ON xcart_price_classification.pricecode = xcart_products.price_classification_code LEFT JOIN xcart_customer_price_classification ON xcart_price_classification.pricecode=xcart_customer_price_classification.pricecode and xcart_customer_price_classification.login='' WHERE xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND xcart_products_categories.categoryid='639' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND (xcart_products.forsale = 'Y' OR xcart_products.forsale = '') GROUP BY xcart_products.productid ORDER BY price ASC, xcart_products.product ASC Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/loadukc/public_html/include/func/func.db.php on line 151 Real Punting
1,064 dvds available
Sign up for our new release newsletter and be the first to know!