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 = '109' 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  >  Footwear & Accessories  >  Statement Aztec Bracelet
Statement Aztec Bracelet
Statement Aztec Bracelet
£16.00

Bracelet By Belle & Flo

  • Large Bracelet with acrylic stone detail
  • Made in New York
  • 3 Colour choices

ABOUT BELLE AND FLO
Belle & Flo is a wholesale fashion jewellery company. We have been trading since April 2012. Our products are designed in New York and have a high fashion edge to them.We add to our collections often - so we have air of excitement surrounding the company. Belle & Flo is named after our gorgeous nieces Annabelle & Florence.

Size:   
Colour:

ABOUT ME 

Base metal, Nickel and Lead with acrylic stones

CARE INFO

TBC

SIZE AND MEASUREMENTS

Adjustable so will fit most wrists

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