INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_quick_prices, xcart_customers as ACHECK, xcart_products_categories, xcart_categories LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = 0 AND xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products.product_type <> 'C' AND xcart_products.product_type <> 'B' AND xcart_products.provider=ACHECK.login AND ACHECK.activity='Y' AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/b0905wil/public_html/edatabase/include/func/func.db.php on line 89
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/b0905wil/public_html/edatabase/include/func/func.db.php on line 121
Wilshire Laboratories Pvt. Ltd.
Categories
Users online
News
