Top » Catalog » Packaging Machinery 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 '5' 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
  Air Pillow & Paper Void Machines
  Case Sealers-Uniform,Random,Erec
  Counting Scales
  Foam In-Place
  Glue Application
  L-Sealers/Impulse & Drop Sealers
  Labelers/ Thermal/ Print- n- App
  Shrink Guns
  Shrink Tunnels
  Skin Packaging/Blister Packaging
  Staplers
  Steel & PET Strap Chopper
  Stitching Machinery
  Strapping Machines-Auto,Semi,Tab
  Stretch Wrappers
  Twist-Tie & String-Tie
Packaging Materials
Packing Aids
Poly Bags/Sheeting
Safety Supplies & Equipment
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
DESICCANT CARGO DRY
DESICCANT CARGO DRY
Call for Price
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Printable Catalog
Gift Voucher FAQ
Site Map