Carpet Cleaning Equipment & Carpet Cleaning Machine

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_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.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' 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/powercle/public_html/store/include/func.php on line 102
Carpet Cleaning Equipment & Carpet Cleaning Machine :: Power Clean Industries

Product Search:

+ Advanced

Power Clean Industries > General Info

Watch this space for our rewards program starting mid September

We realize that to have a successful relationship with our clients such as yourself, we need to reward loyalty. We have now implemented a reward system that means that the more you purchase from our website, the more reward points you can earn. These can be utilized in the form of future discounts, or if you wish to accrue them, can even be used to purchase products for FREE! See our General Info Page for more info.

Also to make your purchasing easier, you can log to our site at anytime and order equipment, accessories and chemicals at a time convenient to you, pay for them online via our secure site, and have the requested goods dispatched the very next day in most cases.

After your order is dispatched, you will receive an SMS message on your mobile phone advising that your order has been dispatched, it will also give you your consignment note number and also where and how to track your parcel so you know when you will be receiving your goods. Now that is customer service !"