CLOTHINGS     PLUS SIZE     JEWELRY     ACCESSORIES     BAGS     ETC     
SEASONAL / HOLIDAY
      CHRISTMAS
      HALLOWEEN
      ETC
CELLPHONE CASES
KEYCHAINS
COSMETICS

Minimum Order : Login


Payment Processing


Enter Tracking#:



Enter Tracking#:



  Top » HOME » ETC WHOLESALE » CELLPHONE CASES » 166088
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 '&) ) 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 != '541964' and pd.products_id = p.products_id and p.products_status = '1' and ( pd.products_name like '%HOOK%' && pd.products_name not like '%earring%' && pd.products_name like '%RING' &) ) order by p.products_id desc limit 7

[TEP STOP]

 Previous   Product 1 of 1 of category CELLPHONE CASES   Next  
STAR SMARTPHONE RING HOOK

STAR SMARTPHONE RING HOOK
166088

Login
  • STAR SMARTPHONE RING HOOK
  • 360 Rotate Freely 
  • Reusable 
  • Adult Only 

Pack Only(2PC PREPACK)
Pack Qty.
WHITE
PINK
BLACK
ROSE GOLD
GOLD
SILVER
GRAY
AQUA
Total Price  $ Total Qty.





WHITE

PINK

BLACK

ROSE GOLD

GOLD

SILVER

GRAY

AQUA