InnerVision PC, Inc.

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, 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_pricing.variantid = 0 OR (xcart_variants.variantid = xcart_pricing.variantid)) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') 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/innervis/public_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, 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.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
InnerVision PC, Inc.

Call 24/7 : 732-721-8904


	Home


	Repair


	Laptops


	Desktops


	Web Hosting


	Web Design

Cart is empty

View cart | Checkout

InnerVision PC, Inc.

Welcome to InnerVision PC, Inc.

InnerVision PC, Inc. is a privately owned business, we originally started our business building computers after seeing the major manufactures (assemblers) taking advantage of customers due to technology always changing and the way a system should be properly setup. These manufactures (assemblers) sell non tested, low quality equipment that is not set up right from the time you open the box, and if you have to call for support (most likely you will) be prepared to wait and get aggravated. Also just a tip, you might want to have a translator with you at the time of the call!

Every system and product we sell is current technology, and is updated and setup with everything you need to have the best computing experience right out of the box, no worries! We concentrate on Quality not Volume! Give us a call anytime if you have any questions or concerns, you can also use the contact us form and enter your info and a good time to call you and we will contact you.

Featured products

There are no available featured products...

Your cart

	Cart is empty

View cart
Checkout

Authentication

Username

Password

Recover password

If Javascript is enabled in your browser click here