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 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 5

Home Contact Us Shopping Cart Checkout Email: sales@pfyv.com   |   Phone: 586-468-1766 : 8:30am-6pm   NEW!! Dynamic Product Search:      Advanced Search         Browse by Make/Model/Year         Chevy Cars      Chevy Trucks/SUVs      Pontiac      Cadillac Cars      Cadillac Trucks/SUVs      GMC      Hummer      Ford Cars      Ford Trucks/SUVs      Chrysler      Dodge Cars      Subaru      Mitsubishi       Your Shopping Cart    Cart is empty  View Cart  Checkout       User Login    Username:     Password:      Log in     Register  Why Register?    Recover Password If Javascript is disabled in your browser click here       Help    Contact Us Terms & Conditions Privacy Statement Frequently Asked Questions Why Register? Vehicle Sitemap Previous New Products Related Links

>> Website optimized for 800 x 600 or greater screen resolutions    >> Website compatible with IE 5.0+ | Netscape 4.0+ | Mozilla Firefox 1.0+ | Opera 8.0+ Copyright © 2005-2008 PerformanceForYourVehicle.com