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 = '51' 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  >  Outfits  >  Empress Black Jumpsuit
Empress Black Jumpsuit
Empress Black Jumpsuit
£62.99

Jumpsuit by Jaide Clothing

  • Black
  • Skinny leg cut
  • Elegant back cutout
  • Belt not included

ABOUT JAIDE CLOTHING

Jaide was founded by Teresa and Christina Le in the fall of 2007. After not having any formal training, the sisters tapped into their creative minds because fashion was always their escape. They began to create designs out of sheer passion, and because of their fortitude, imagination was a word of the past, their first line was realized. Coupling that with their entrepreneurial spirit, Jaide Clothing was born. Jaide clothing is the premiere fashion line for women and their special events. They allow women to capture their true essence and bring out the sexiness and sophistication of style and fashion. Jaide's motto is simple, "You'll think its custom made" because their clothing brings out the sensual and the sleekness of a woman's body. 
Size:   

Additional Info:

Shoes available Click Here, Belt NOT included 

ABOUT ME

Acetate/Lycra

CARE INFO

Machine was 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