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 = '62' 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  >  Frida Ruched Grey Skirt
Frida Ruched Grey Skirt
Frida Ruched Grey Skirt
£22.99

Skirt by Rock and Religion

  • Charcoal Marl
  • Asymmetric hemline
  • Black waist band
  • Jersey Material

 

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

95% Viscose 5% Elastane

CARE INFO

Machine wash on gentle cycle, Do not bleach, Low iron on reverse, Do not iron trim

SIZE AND MEASUREMENTS

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