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 = '92' 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  >  Amira Sparkle Party Dress
Amira Sparkle Party Dress
Amira Sparkle Party Dress
£38.00

Dress By Lovestruck

  • Metallic Bodice
  • Elasticated Waistband
  • Chiffon Skirt

ABOUT LOVESTRUCK
Lovestruck is a flirty feminine clothing brand. It offers vintage style with a playful twist. From simple sophisticated dresses to flirty florals, the brand offers an eclectic mix of designs. Lovestruck was formed in 2009 with the aim to offer affordable boutique style clothing. Working in season Lovestruck is able to offer a fashion focused clothing range and is continually producing new designs throughout the season.

Size:   

ADDITIONAL INFO

Shoes available Click Here

ABOUT ME 

100% Polyester 

CARE INFO

Machine Wash at 30 Degrees

SIZE AND MEASUREMENTS

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