INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: select DISTINCT xcart_products.*, xcart_categories.category, xcart_pricing.price, IF (xcart_products_lng.product IS NOT NULL,xcart_products_lng.product, xcart_products.product) AS product from xcart_products, xcart_pricing, xcart_categories, xcart_product_links LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code='US' where (xcart_pricing.membership='') and (xcart_pricing.productid=xcart_products.productid) and (xcart_pricing.quantity=1) and (xcart_products.categoryid=xcart_categories.categoryid) and xcart_products.forsale='Y' and (xcart_products.productid=xcart_product_links.productid2) and (xcart_product_links.productid1='14495') ORDER BY xcart_product_links.orderby, product
INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT DISTINCT sp2.productid, xcart_products.*, IF (xcart_products_lng.product IS NOT NULL,xcart_products_lng.product, xcart_products.product) AS product, IF (xcart_products_lng.descr IS NOT NULL,xcart_products_lng.descr, xcart_products.descr) AS descr, IF (xcart_products_lng.full_descr IS NOT NULL,xcart_products_lng.full_descr, xcart_products.fulldescr) AS fulldescr FROM xcart_stats_customers_products as sp1, xcart_stats_customers_products AS sp2, xcart_products, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products.productid=xcart_products_lng.productid AND xcart_products_lng.code='US' WHERE sp1.productid='14495' AND sp1.login=sp2.login AND sp2.productid!='14495' AND xcart_products.productid=sp2.productid AND xcart_products.forsale='Y' AND xcart_categories.categoryid = xcart_products.categoryid AND xcart_categories.membership IN ('','') ORDER BY xcart_products.product LIMIT 10
Vivioptal capsules vital substances
Sitemap Home Contact Us
  Search:     GO
  Categories
Alternative Cures
Animal Medicines
Aromatherapy
Bath and Shower
Beauty
Books & CDs
Childrens Medicines
Crystal Clear
Dental Care
Deodorants and Antiperspirants
Dermalogica
Disability Aids
Electrical Equipment
Family Doctor Books
Feminine Care
Foot Wear
Goodsphere
Hair Care
Herbal
Homeopathic Remedies
Household
Immune System
Jessica
Ladies Fragrances
Lipotrim
Medicines
Mens Fragrances
Mens Grooming
New Products
No Category
NUK Range
Opticians
Optition
Personal Conditions
Pet Health
Photography
Quit Smoking
Rain Hat
Self Testing
Sexual Wellbeing
Sports Wear
Supports
Travel and Suncare
Unknown
Vichy
Vitamins and Supplements
Weight Loss


  Highlights

 
Copyright © 2001-2004 xcellento