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_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' 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.product_type <> 'B' 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
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 5
Force 9 Marketing
Home  Search  product catalogue  Express List  FAQ  Strain Guide  Contact Us  Forums  Auctions  Gallery  Chat room  Article Library 
   
   


     Categories



     Recent Products
Super Crystal Cup Winner
Blue Haze Cup Winner
First Lady (White Widow) Cup Winner
The Hog Cup Winner
Sage n Sour Cup Winner


     Special
Gift certificates


     Help
Contact us
Privacy statement
Terms & Conditions

     Rest of Site


      Force 9 Marketing

Welcome to Force 9 Marketing

This site contains items of an adult nature. If you are under 18yrs, please leave now.

Still here? then welcome. You can find a vaste array of information, services and goods on this site, and more is being added all the time.

I am always offering free goods, prize competitions and very special offers here. To ensure you are kept informed of these deals, subscribe to my newletter 'The High Life'. It's FREE and will also contain hints and tips and odd items of interest.

Check out the Forum if you have any questions you would like answered -or just browse and pass some time and share stories with other tokers.

You can always spend some money here, I operate a 'best prices' policy. If you can find your item being retailed elsewhere, cheaper, I will pay you twice the difference!

Greybeard

  Featured products
There are no available featured products...  
 

 
     Your cart
Cart is empty
View cart
Checkout


     Currency Selector
Euro
US Dollar
Australian Dollar
Canadian Dollar
New Zealand Dollar
Japanese Yen



     Select Language



     Log in here
Username

Password

Log in
Register
Recover password

If Javascript is disabled in your browser click here


     Testimonials


     Users online
28  unregistered customer(s)




 
Copyright © 2002-2012 Force 9 Marketing