Top » Catalog » Privacy Notice 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 where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' 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
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
Labels-Blank
Labels-Blank
Call for Price
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Printable Catalog
Gift Voucher FAQ
Site Map