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 = '80' 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  >  Side Zip Knit Jumper
Side Zip Knit Jumper
Side Zip Knit Jumper
£28.99

Jumper By Neon Rose

  • Statement Zips to side
  • Chunky Knit Style
  • Rounded Neckline

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. 

Colour:
Size:   

ADDITIONAL INFO

Trousers and shoes are models own.

ABOUT ME

55% Acrylic 45% Cotton 

CARE INFO

Hand Wash Only, Cool Iron on reverse

SIZE AND MEASUREMENTS

Model Wears: Size 8  Models Height: 5ft 9"

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