Select `attr`.`attribute_title`, `attr`.`attribute_value` from  `jos_vm_product_category_xref` as `pc_pcx`,  `jos_vm_product_attributes` as `attr` where  1  and  `pc_pcx`.`product_id` = `attr`.`product_id` and  `pc_pcx`.`category_id` = 1720 order by `attribute_title` ASC, `attribute_value` ASC
Ucase: Artist Design iPhone 7 Case | Designer Phone Case | DSstyles
  • $ USD
    • $ USD
    • € EUR
    • £ GBP
    • $ CAD
    • $ AUD
    • ฿ THB
    • ₱ PHP



  • |
  • |
  • My Account

Animal House Cover photo
Yaniyang
USD $19.99
Blue Sky Cover photo
Christine Lam
USD $36.99
City of The Night Light Cover photo
Yaniyang
USD $19.99
Coffee Cover photo
Christine Lam
USD $36.99
Falling in Love - Lion Cover photo
Toto Workshop
USD $19.99
Falling in Love - Sheep Cover photo
Toto Workshop
USD $19.99
Falling in Love - Yak Cover photo
Toto Workshop
USD $19.99
Flower in Rainbow Cover photo
Christine Lam
USD $36.99
Green Sky Cover photo
Christine Lam
USD $36.99
Happy Panda - Emerald Cover photo
Toto Workshop
USD $19.99
Happy Panda - Marble Cover photo
Toto Workshop
USD $19.99
Happy Panda - Ruby Cover photo
Toto Workshop
USD $19.99
Happy Panda - Sapphire Cover photo
Toto Workshop
USD $19.99
Happy Panda - Wooden Cover photo
Toto Workshop
USD $19.99
Houndstooth Tie Cover photo
Christine Lam
USD $36.99
Lines Tie Cover photo
Christine Lam
USD $36.99
Love Hearts Planet Cover photo
Toto Workshop
USD $19.99
Mutual Affinity Cover photo
CocoLiu
USD $19.99