Kitchen Restaurant Store
Phone (888) 987-7897
Mon-Fri 8AM-5PM MST
Payment Processing
Live Chat by Live Chat Works
Powered By LiveChatWorks.com
    Home  |  Blog Clearance Corner  |  My Account  |  Cart Contents  |  Checkout     
Product Search
 
Categories
What's New?
Elkay Plastics Co., Inc. F20608 Zip Lock Freezer Bag, 6" X 8"/2
Elkay Plastics Co., Inc. F20608 Zip Lock Freezer Bag, 6" X 8"/2
$27.63
Waste and Recycling Containers Waste and Recycling Containers
Ash Tray Receptacle
Ash Tray Receptacle
Can Liners
Can Liners
Flatware Retrieval Chute
Flatware Retrieval Chute
Recycling Containers
Recycling Containers
Space Saving Trash Cans
Space Saving Trash Cans
Square Trash Cans
Square Trash Cans
Standard Round Trash Cans
Standard Round Trash Cans
Tilt Trucks and Wheels Trash Cans
Tilt Trucks and Wheels Trash Cans
Wall Hugger, Trimline and Slim Jim Trash Cans
Wall Hugger, Trimline and Slim Jim Trash Cans
Waste Baskets
Waste Baskets
Hot Products For December
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'derik_shopcar.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '25909' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9

[TEP STOP]