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. F21315 Zip Lock Bag, 13" X 15" 2 Gal/2
Elkay Plastics Co., Inc. F21315 Zip Lock Bag, 13" X 15" 2 Gal/2
$79.25
Bar Supplies Bar Supplies
Ashtray
Ashtray
Bar Liners
Bar Liners
Bar Mats
Bar Mats
Bar Shakers
Bar Shakers
Bar Spoon
Bar Spoon
Bottle Openers
Bottle Openers
Caddies
Caddies
Check Holder
Check Holder
Condiment Dispensers
Condiment Dispensers
Corkscrews
Corkscrews
Drink Mix
Drink Mix
Funnels
Funnels
Glass Holder
Glass Holder
Glass Rimer
Glass Rimer
Glass Washers
Glass Washers
Ice Scoops
Ice Scoops
Ice Utensils
Ice Utensils
Jiggers Metal
Jiggers Metal
Liquor Station Equipment
Liquor Station Equipment
Malt Cups
Malt Cups
Misc.
Misc.
Muddlers
Muddlers
Order Racks
Order Racks
Pourers
Pourers
Store N Pour Sets
Store N Pour Sets
Table Crumblers
Table Crumblers
Tip Trays
Tip Trays
Wine Buckets
Wine Buckets
Hot Products For October
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 = '28199' 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]