Log In  |  My Account  |  View Cart  |  Checkout    
necklaces
earrings
bracelets
rings
brooches
hair pins
belts
watches
handbags
eyeglasses
hatgloves
scarves
apparel
gifts
special

    Categories

Minimum Order : Login


ABOUT SSL CERTIFICATES

Enter Tracking#:


  Top » Catalog » EARRINGS » TRENDY STYLE » ELSE1913C2
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '&) ) order by p.products_id desc limit 7' at line 1

select p.products_id, p.products_image, pd.products_name from products_description pd, products p, products_to_categories p2c where p2c.categories_id > 0 and p2c.products_id = pd.products_id and pd.products_id != '94102' and pd.products_id = p.products_id and p.products_status = '1' and ( pd.products_name like '%EARRINGS%' && pd.products_name not like '%earring%' && pd.products_name like '%RING' &) ) order by p.products_id desc limit 7

[TEP STOP]

 Previous   Product 6240 of 6293 of category TRENDY STYLE   Next  
AZTEC ETCHED OVAL RING EARRINGS
AZTEC ETCHED OVAL RING EARRINGS

NameAZTEC ETCHED OVAL RING EARRINGS
Style No.ELSE1913C2
PriceLogin

  • Lead/Nickel compliant
  • Drop Approx.  2.25"
  • Post back

Option Price Qty.
Antique Gold $
Antique Silver $
Total Price  $ Total Qty.

Reviews



Antique Gold

Antique Silver

Customers who bought this product also purchased
ACRYLIC STONE SET CRESCENT ORNATE DROP EARRINGS
ACRYLIC STONE SET CRESCENT ORNATE DROP EARRINGS
CRESCENT TRIBAL PATTERN CUT OUT EARRINGS
CRESCENT TRIBAL PATTERN CUT OUT EARRINGS
DOUBLE HOOP OPEN TIP EARRINGS
DOUBLE HOOP OPEN TIP EARRINGS
FILIGREE SWIRL OPEN TIP HOOP EARRINGS
FILIGREE SWIRL OPEN TIP HOOP EARRINGS
PATINA CROSS DISK DROP EARRINGS
PATINA CROSS DISK DROP EARRINGS
THIN LONG CROSS EARRINGS
THIN LONG CROSS EARRINGS
ANTIQUE MULTI TRIANGLE EARRINGS
ANTIQUE MULTI TRIANGLE EARRINGS