For the best advice and choice in DCC Safebuy accredited We encrypt Your payment information. (Check for the padlock at checkout.) ICRA verified FSB Member Credit cards accepted, SSL & 3D secure assured Tax free for non-EEC residents
  Catalog » Printable Catalog    Your Account  |  Basket  |   |  RSS New Items Feed
DCC Supplies
DCC Supplies Ltd.
Unit 17A, Top Barn Business Centre
Worcester Road
Holt Heath
Worcestershire
WR6 6NH
0845 224 1601
+44 1905 621 999
Email: shopping@dccsupplies.com
Note: All prices are subject to change without notice. All products will be billed in our shop Currency only.
          Please phone of check site for options pricing. This catalog is current on the day of printing. Postage prices as per checkout table
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and cd.language_id = '1' order by cd.categories_name DESC, pd.products_name

[TEP STOP]

 
  		Image
 
  		Options
Sort Asending
Sort Desending		 Manufacturer
Sort Asending
Sort Desending		 Name
Sort Asending
Sort Desending		 Description
Sort Asending
Sort Desending		 Category
Sort Asending
Sort Desending		 Model
Sort Asending
Sort Desending		 Price