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 = '60' 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  >  Emmie Floral Pleated Dress
Emmie Floral Pleated Dress
Emmie Floral Pleated Dress
£55.99

Dress by Rock and Religion

  • Floral print
  • Asymmetric hemline
  • Gather at one side
  • Short sleeves
  • Nude slip included

ABOUT ROCK AND RELIGION

Rock and religion fuses the edgy with the eclectic for a unique take on current trends. Focusing on attention to detail, directional style and finish. Our range is crafted with distressed prints and grungy acid washes whilst heavy embellishments add a touch of glamour. We know how important it is to look your best, therefore it is essential that our effortless grunge glamour collections help you rock this 'designer brand' for less. Rock and Religion is devoted to the pursuit of individual style - Reawakening the Religion of Rock.
Size:   

Additional Info

Accessories are models own, Shoes available click here

ABOUT ME

100% Polyester, Under slip 100% Polyester

CARE INFO

Machine wash on gentle cycle, Wash inside out, Do not tumble dry, Low iron on reverse

SIZE AND MEASUREMENTS

Model wears: Size 8 -10 Models Height: 5ft 6"

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