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. F20708 Zip Lock Freezer Bag, 7" X 8" 1
Elkay Plastics Co., Inc. F20708 Zip Lock Freezer Bag, 7" X 8" 1
$27.63
Cooking Equipment Cooking Equipment
Broilers
Broilers
Commercial Rice Cookers
Commercial Rice Cookers
Food Warmers
Food Warmers
Fryers
Fryers
Gas Hose
Gas Hose
Griddles
Griddles
Holding / Proofing Cabinets
Holding / Proofing Cabinets
Hot Plate
Hot Plate
Ovens
Ovens
Panini Sandwich Grills
Panini Sandwich Grills
Portable Stoves
Portable Stoves
Ranges
Ranges
Roasters and Slow Cookers
Roasters and Slow Cookers
Roller Grill
Roller Grill
Steam and Cold Food Table Accessories
Steam and Cold Food Table Accessories
Steam Tables
Steam Tables
Stock Pot Stove
Stock Pot Stove
Toasters
Toasters
Waffle Makers
Waffle Makers
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 = '24950' 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]