3065 - Expression #2 of ORDER BY clause is not in SELECT list, references column 'harpercl_creloaded.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 = '71' 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 STOP]

Home  >  Women  >  Tops  >  Waterfall Jacket Leather Look Sleeves
Waterfall Jacket Leather Look Sleeves
Waterfall Jacket Leather Look Sleeves
£43.00

Jacket By Neon Rose

  • Grey and Black
  • PU Leather look sleeves

 

ABOUT NEON ROSE
Neon Rose launched its first collection in SS13. Girly and on-trend with a grungy edge, the brand offers a mix of eclectic embellishment detail fused with inspiring fabric mixes, must have shapes and prints and patterns which are designed exclusively in-house, making each one unique. These elements are collectively inspired by catwalk trends and global street style from LA, Europe and the Far East, and brought together to create this fashion anthology.

 
Size:   

ABOUT ME 

Main Body 100% Polyester, Sleeve 100% Viscos

CARE INFO 

Cool wash seperately, reshape whilst damp, Do not iron

SIZE AND MEASUREMENTS

Model wears: UK 8 - 10 Models Height: 5ft 6"

Additional Info: Jeans and Shoes are models own.

Please see our Delivery Info Page for full information on deliveries.

 

1 - 3 Working Day Delivery UK (Orders over £50)FREE
1 - 3 Working Day Delivery UK (Orders under £50) £3.99
Next Day Delivery UK £5.99
Saturday Delivery  £7.99

 

We hope you are happy with all of your purchases but if you ever need to return an item, you can do so within 14 days from the date your parcel was shipped.
Click here to view our full Returns policy