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 = '70' 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  >  Double Zip PU Mini Skirt
Double Zip PU Mini Skirt
Double Zip PU Mini Skirt
£14.99

Skirt By Neon Rose

  • Black with White Panel
  • Double Zip
  • PU Material

 

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:   

Additional Info:

Accessories are models own, Shoes available Click Here

ABOUT ME

Main 100% Polyester Detail 100% Polyester

CARE INFO 

Wash dark colours seperatley. Cool iron on reverse. Do not iron trim.

SIZE AND MEASUREMENTS

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

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