StarTechPC.com

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 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='0' 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' GROUP BY xcart_products.productid

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/startech/public_html/shop/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 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 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> '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 5
StarTechPC.com


	Home


	Shopping Cart


	Business Partners


	On-site & PC Repair


	About Us


	Contact Us

Search:

Advanced search

Welcome to StarTechPC.com

	Dell, Compaq, Toshiba, HP Starting at $99 PII 233-400 Mhz 64-128 MB RAM 4-10 GB HDD CDROM Modem or NIC Windows ME Office suite and antivirus software available	Dell Latitude CPX/CPT Starting at $199 PIII 450-750 MHZ 128-256 MB RAM 10-20 GIG HDD CDROM (upgradeable) Modem or NIC Windows ME or 2000 Pro Office suite and antivirus software available
	Dell Latitude C600/C610 Starting at $399 PIII 800MHZ-1.2 GHZ 256 MB RAM 20-40 GB HDD CDROM (upgradeable) Modem and NIC Windows 2000 or XP Office suite and antivirus software available	Dell Latitude C640 Starting at $499 P4 1.6-2.4 GHZ 256-512 MB RAM 20-40 GB HDD CDROM (upgradeable) Modem and NIC Windows 2000 or XP Office suite and antivirus software available

SUBSCRIBE TO OUR EMAIL NEWSLETTER FOR
SPECIAL OFFERS ON PRODUCTS AND SERVICES

AMD 64 Power PC

$299

Athlon 64 3200+ CPU

512 MB DDR RAM

80 GB HDD

Onboard Video/Sound/LAN

CDRW or DVDROM

6 USB 2.0 Ports

Keyboard/Mouse included
CUSTOMIZE IT!

AMD Gamer PC

NEW LOW PRICE! $699

Athlon 64 X2 5000+ Dual Core

1 GB DDR2 RAM

250 GB HDD

256 MB GeForce Video

DVDRW

6 USB 2.0 Ports

Keyboard/Mouse included
CUSTOMIZE IT!

AMD 64 X2 Power PC

$399

Athlon 64 X2 4200+

512 MB DDR2 RAM

80 GB HDD

Onboard Video/Sound/LAN

CDRW or DVDROM

6 USB 2.0 Ports

Keyboard/Mouse included
CUSTOMIZE IT!

Microsoft Windows
Windows Vista
Home Premium $134 (OEM)
Add to cart

Windows XP Home $99 (OEM)
Add to cart

Windows XP Pro $169 (OEM)
Add to cart

Ask about our UPGRADE SPECIAL! ONLY $199!

Upgrade your motherboard and processor for only $199
Includes an ECS motherboard and the Athlon 64 3200+ processor
You might need a compatible RAM (memory) upgrade too! Ask about our RAM upgrade prices.

Refurbished Desktops

StarTechPC.com has a wide variety of refurbished desktops. Whether you need a machine for basic internet, email and word processing, or for higher end gaming or business applications, we'll help you find the perfect system for your needs, and for a fraction of the price. Come check 'em out!

Sell or Trade

We pay CASH for your used desktops, laptops, and LCD monitors. If your system is too old or does not carry much value, you may recieve credit towards another in-store purchase!

Featured products

There are no available featured products...

Your cart

	Cart is empty

View cart
Checkout

Authentication

Username

Password

Recover password

If Javascript is disabled in your browser click here