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

400mm x 485mm hotplate - cast iron, to suit 4B BBQ [400P]  $39.00 

Cast Iron Hotplate, W400mm x D485mm to suit most standard 4 Burner BBQs.

Standard painted coating, solid plate on one side, griddle lines on the other side.

   
     
This product was added to our catalog on Thursday 19 May, 2011.
Reviews Add to Wish List
Quantity: