DIY Plumbing Supply

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() expects parameter 1 to be resource, boolean given in /home/diyplumb/public_html/include/func.php on line 102
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, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, 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.forsale <> '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
DIY Plumbing Supply


	Home


	Cart


	Contact Us

Toll Free:: 1-877-478-7448

Search:

Advanced search

DIY Categories

Manufacturers

Quick Fitting Inc.

Special

Gift certificates

Help

Contact us
Privacy statement
Terms & Conditions
Quick Connection Plumbing
The New Way to Connect Pipe
Quick Connect Applications
Why Use COPRO? Fittings?
Technical Resources (Specifications)
Quick Connect FAQ
Become a Distributor

DIY Plumbing Supply

Welcome to DIY Plumbing Supply

The DIY Plumbing Supply network is your source for Do It Yourself Plumbing products and tips. In addition to the latest technology in plumbing products, DIY Plumbing Supply provides the complete line of COPRO™ Quick connection plumbing fittings.

What can you do with a COPRO™ quick connection fitting? COPRO™ quick connection plumbing fittings provide anyone with the ability to simply slide and connect Copper, CPVC, Stainless Steel and PEX plumbing pipe with NO sweating or soldering. COPRO™ is a permanent plumbing connection that may even be used in a system without draining the existing water. Best of all, COPRO™ quick connection fittings may be separated and reused using the patented COPRO™ separation tool.

In addition to providing you with a fast, easy and permanent plumbing project, the COPRO™ Quick Kit is your homes insurance policy against the costly damage and repairs created by water leaks and breaks in your home's plumbing system.

Featured products

There are no available featured products...

Your cart

	Cart is empty

View cart
Checkout

Authentication

Username

Password

Recover password

If Javascript is disabled in your browser click here