Top » Catalog » Safety Supplies & Equipment » Safety Mats » d0dc1deb1e52e39 My Account | Help | Wish List | Order Status    

     0 items in cart
Checkout Cart Contents
    Home | About Us | Location | Our Products | Our Services | Contact Us  -  1-800-922-2376
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'shippers_shop.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '311' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

Categories
Adhesives & Equipment -All Types
Boxes
Cornerboard
Marking/Labeling Equip./Supplies
Material Handling
Moving Supplies
Packaging Machinery
Packaging Materials
Packing Aids
Poly Bags/Sheeting
Safety Supplies & Equipment
  Absorbent Materials
  Cabinets/Cans-SAFETY
  Dust Masks & Respirators
  Ear Protection
  Gloves
  Goggles
  Guards & Safety Lock-Outs
  Safety Clothing
  Safety Glasses & Hard Hats
  Safety Mats
  Safety Signs & Pipe Markers
  Support Belts & Support Lanyards
  Tape(Check Cat.Tapes Too)
Scales-Floor/Bench
Staples/Nails/Equipment
Stitchers
Strapping-Non-Metallic , Seals
Strapping-Steel & Tools, Seals
Stretch Wrap & Portable Film Dis
Tapes & Tape Dispensers
TECHNICAL SERVICE/PARTS
Trucking Equipment
Warehouse Equipment
What's New? more
STYRENE COOLERS
STYRENE COOLERS
Call for Price
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Printable Catalog
Gift Voucher FAQ
Site Map