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 = '68' 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  >  Skirts & Shorts  >  Angle Hem Black Skirt
Angle Hem Black Skirt
Angle Hem Black Skirt
£14.99

Skirt By Neon Rose

  • Black
  • Anglel Hem
  • Leather Look 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: 

For Jacket Click Here  and for shoes Click Here

ABOUT ME

100% Polyester

CARE INFO 

Hand wash only, Do not iron, Do not bleach, Do not tumble dry

SIZE AND MEASUREMENTS

Model Wears: UK 8 - 10 Model 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