0 items
BBQs-R-Us Building Better Barbies
3065 - Expression #2 of ORDER BY clause is not in SELECT list, references column 'bbqcentre_store.xp.products_id' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image , xp.xsell_id products_price from (products p left join specials s on p.products_id = s.products_id), products_xsell xp, products_description pd where xp.products_id = '104' and p.products_id = xp.xsell_id and pd.products_id = xp.xsell_id and pd.language_id = '1' and p.products_status = '1' order by rand(), xp.products_id asc limit 4

TEP_DB_ERRORR

Premium 4S Stainless Steel BBQ [P4S]  $1,149.00 

Premium 4S

The Premium 4S is a fantastic quality BBQ made from a 430-grade stainless steel. It features:

  • Stainless steel roast hood
  • Stainless steel cabinet trolley
  • Stainless steel body
  • 400mm cast iron, enamel coated hotplate and 400mm cast iron enamel coated grill
  • Side burner
  • Enamel coated diffusers
  • Electronic ignition system (battery operated)
  • Internal gas bottle storage
  • Stainless steel burners
  • Slide out drip tray, removes from the front
  • 4 x castors for easy movement

This BBQ is suitable for being outdoors in full weather conditions, we always recommend a cover to keep it clean however the BBQ will not rust. The hotplate and grill are enamel coated cast iron, so they are highly rust resistant.

Premium 4S Stainless Steel BBQ Premium 4S Stainless Steel BBQ Premium 4S Stainless Steel BBQ
     
Shipping Type:  Truck
This product was added to our catalog on Wednesday 06 July, 2011.
Reviews Add to Wish List
Quantity: