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 = '61' 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  >  Rock and Religion  >  Juliette Studded Marl Midi Dress
Juliette Studded Marl Midi Dress
Juliette Studded Marl Midi Dress
£28.99

Dress by Rock and Religion

  • Grey Marl
  • Midi Length
  • Studded detail
  • High neck design
  • sleeveless

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:

Shoes available Click Here

ABOUT ME

95% Polyester 5% Elastane

CARE INFO

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

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