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 = '176' 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


Australian made 320mm x 435mm Flame Diffuser. Suits Jackeroo. [320SSFT]  $45.00 


Stainless Steel Flame Tamer: W320mm x D435mm, made from high quality 304-grade stainless steel, very non-corrosive, Australian made. This is a very good flame tamer that will last for many years. Will suit many Jackeroo, Focus and Gasmate BBQs

This product was added to our catalog on Sunday 11 November, 2012.
Reviews Add to Wish List