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 = '41' 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  >  Scandalous Floral Skirt
Scandalous Floral Skirt
Scandalous Floral Skirt
£65.99

LIMITED STOCK AVAILABLE

Skirt by Abyss by Abby

  • Multi colour & Patterned
  • High Waisted
  • Tulip design
  • Pleated
  • Back zip fastening

 

ABOUT ABYSS BY ABBY

In the Summer of 2009, Abby used her fashion forward thinking and influences, to design and launch the Abyss by Abby range, a Sexy & Sassy Label for the cheeky girl who admittedly wants to be the centre of attention. The Abyss Collection highlights the beauty of the female silhouette through flattering fits whilst portraying empowerment and an edgy take on fashion. Abby knows that the modern woman loves sophistication and sexy in the same look."Pretty pieces with audacious attitude"
Size:   

Additional Info:

Shoes available Click Here  

ABOUT ME

45% Cotton

CARE INFO

Machine wash according to instructions

SIZE AND MEASUREMENTS

Model wears: UK 8 Model Height: 5ft 9"

Please see our Delivery Info Page for full information on deliveries.

 

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

 

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