Hourprice.com - memory card, electronics, sexual enhancement, vitamins and much more

INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_products.*, xcart_products.avail-0 AS avail, min(xcart_pricing.price) AS price , IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant FROM xcart_products, xcart_pricing LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE xcart_products.productid='25440' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND (xcart_pricing.membership = '' OR xcart_pricing.membership = '') GROUP BY xcart_products.productid
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND (xcart_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_products.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 10
Hourprice.com - memory card, electronics, sexual enhancement, vitamins and much more - Your Shopping Cart

TEL: 1-626-593-5300
FAX: 1-626-602-8700

HOME

MEMORY CARD

NOTEBOOK

CELL PHONES

DIGITAL CAMERA

TOP BRANDS

advanced search

Hour Price

Your shopping cart

The items below are currently in your shopping cart. To remove any item click "Delete item". To checkout, please click "Checkout". Please note that Delivery method is ignored if you are ordering Gift Certificates or Electronically distributed products.

Items

Your shopping cart is empty

Special

Oct 3, 2007
We have added a new electronics session! Please let us know what you would like to see and we will post it online for you.

Previous news

Your email:

Subscribe

top brands


	CANON
	KINGSTON
	SANDISK

SSL