0 items

3065 - Expression #2 of ORDER BY clause is not in SELECT list, references column 'jangoz_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 = '106' 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


Roo Stick Single [RSTICKS]  $2.00 


High in essential vitamins and minerals.

 Air dried and are free from Artificial colours, flavours and preservatives that are commonly found in many other local and imported products.

Roo Stick Single
Reviews Add to Wish List