Hoop Earrings

Our gold hoop earrings collection is handpicked to ensure each pair is beautiful, affordable and high quality. With free delivery on all orders you can't go wrong! Our range include 9ct yellow gold hoops and white gold hoops alongside a selection of silver hoop earrings. If there is a style you want but can't see let us know we have lots of experience and can help you to find the hoop earrings you are looking for.

Displaying 1 to 49 of 71 products
 1  2  » 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 49' at line 7

select distinct p.products_image, m.manufacturers_id, m.manufacturers_name, p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, products_rrp FROM (products p) LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN products_description pd ON p.products_id = pd.products_id and pd.language_id = '1' LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories c ON p2c.categories_id = c.categories_id LEFT JOIN categories_description cd ON cd.categories_id = c.categories_id WHERE p.products_status <10 AND (p2c.categories_id = '249' OR c.parent_id = '249')AND ((SELECT COUNT(*) FROM products_attributes pas WHERE pas.products_id = p.products_id AND pas.options_values_id IN (126))>0) order by limit 0, 49