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 = '67' 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  >  Zimmer Sequin Front Top
Zimmer Sequin Front Top
Zimmer Sequin Front Top
£29.99

Top by Rock and Religion

  • Navy
  • Raw edge hemline
  • Sheer with sequins

 

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 helps you rock this 'designer brand' for less

Rock and Religion is devoted to the pursuit of individual style - Reawakening the Religion of Rock.
Size:   

ABOUT ME

100% Polyester

CARE INFO

Hand wash in warm water, Hang to dry, Do not dry clean, Do not tumble dry.

SIZE MEASUREMENTS

Model Wears: UK 8 - 10 Models Height: 5ft 6"

Additional Info: Jeans and shoes are models own.

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