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?
Anchor Hocking Corp 3532U Zombie Glass, 12 Oz, Sure Guard Shell
Anchor Hocking Corp 3532U Zombie Glass, 12 Oz, Sure Guard Shell
$1.39
Cutlery Cutlery
All Purpose Knives
All Purpose Knives
Asian Cutlery
Asian Cutlery
Boning / Fillet Knives
Boning / Fillet Knives
Bread / Sandwich Knives
Bread / Sandwich Knives
Breaking Knives
Breaking Knives
Butchers Knives
Butchers Knives
Carving Forks
Carving Forks
Carving Knives
Carving Knives
Cheese Knives
Cheese Knives
Chef Gloves
Chef Gloves
Chefs Knives
Chefs Knives
Cimeter Knife
Cimeter Knife
Clam and Oyster Knives
Clam and Oyster Knives
Cleavers
Cleavers
Cooks Forks
Cooks Forks
Cooks Knives
Cooks Knives
Dough Scrapers and Cutters
Dough Scrapers and Cutters
Garnishing Kits
Garnishing Kits
Garnishing Tools
Garnishing Tools
Kitchen Shears
Kitchen Shears
Knife Covers
Knife Covers
Knife Racks
Knife Racks
Knife Roll
Knife Roll
Knife Sets
Knife Sets
Knife Sharpeners
Knife Sharpeners
Misc. Cutlery
Misc. Cutlery
Paring Knives
Paring Knives
Peelers
Peelers
Pizza Cutters
Pizza Cutters
Sandwich Spreaders
Sandwich Spreaders
Serrator
Serrator
Skinning Knives
Skinning Knives
Slicing Knives
Slicing Knives
Specialty Knives
Specialty Knives
Steak Knives
Steak Knives
Utility Knives
Utility Knives
Hot Products For September
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 = '28197' 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]