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 = '56' 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  >  Dresses  >  If You Stand For Nothing Dress
If You Stand For Nothing Dress
If You Stand For Nothing Dress
£350.00

LIMITED STOCK AVAILABLE

Dress by Kelly Shaw London

  • Midi Length
  • Black
  • White printed text to front

ABOUT KELLY SHAW LONDON

"My work is all about questioning the status quo and pushing the boundaries of today's increasingly bored, conservative culture.
Working with influences including Grayson Perry, the Occupy movement, The London Riots, the fashion of the interwar years and George Orwell, I am fascinated by ruins, extinction and obsolescence; sassiness and mischief; sweetness and subversion.
My clothes are about the layering of history, connecting the past to the future in radical, transgressive ways and fighting for what you believe to be right."
Size:   

Additional Info:

Shoes available Click Here

ABOUT ME

100% Linen

CARE INFO

Specialist Dry Clean Only, Do not bleach, Do not tumble dry. Made In London.

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