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 = '72' 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  >  Neon Rose  >  Gold Sequin Mini Dress
Gold Sequin Mini Dress
Gold Sequin Mini Dress
£32.99

Dress By Neon Rose

  • Black and Gold
  • Sequin Details
  • Mesh Panels

 

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, 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:   

Additional Info: Shoes available Click Here

ABOUT ME

100% Polyester Body 95% Polyester Mesh Trim 5% Elastane

CARE INFO

Wash dark colours separately. Hand wash only. Do not iron.

SIZE AND MEASUREMENTS

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

 

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

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

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.