INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_variants.avail > 0 LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='108' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/p/c/c/pccomputers/html/include/func.php on line 102
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_variants.avail > 0 LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products_categories.categoryid='108' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/p/c/c/pccomputers/html/include/func.php on line 102
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, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, 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 AND xcart_variants.avail > 0 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_products.avail>0 AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products_categories.categoryid IN (260,261) AND xcart_products.views_stats>0 AND xcart_products.sales_stats > 0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
home.tpl
 
Home
Monthly Specials
View Your Cart
Contact Us

LOCAL: 704-788-8877
   TOLL FREE: 1-800-875-2828  
  Search:      Advanced search
 
Printable version 
 

    
Notebooks & Laptops
Customize Your PC
Motherboards & Processors
  Motherboards
  Processors
Memory
Hard Drives
Optical Drives
Floppy/ZIP/Card Readers
Accessories
Shop by Manufacturer


     Help
Contact Us
Privacy Statement
Terms & Conditions
About Us
PC Care/Maintenance
Services
How To Find Us
FAQ
Links and Resources
Link Instructions


     Special Stuff
Gift Certificates



Square Trade - Stop overpaying for smartphone insurance.
 

Horizon Computer Systems :: Motherboards & Processors

Select from a variety of Motherboards here. For AMD or Pentium processors.

  Motherboards & Processors
 Motherboards
7 Products
 Processors
8 Products
 

 

Horizon Pricelist
Click Here to Download our Pricelist

Monthly Specials
Click Here to Download Our Specials

 

 

     Your cart
Cart is empty

View cart
Checkout


     Authentication
Username

Password

Log in
Register
Recover password





SSL


 


Click to Download SuperAntiSpyware

FAQ     About Us     Links     Gift Certificates     Contact Us

or Call 1-800-875-2828
Store Hours are
Monday - Friday, 10:00 am - 6:00 pm EST
Open First and Third Saturday of the Month, 9:00 am - 3:00 pm EST
Closed All Other Saturdays and Sunday
1091 Concord Parkway N
Concord, NC 28027
Order online 24/7


Copyright © 1992-2014 Horizon Computer Systems