SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '263531' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

Description :

Title : Kiko Wireless Quilted Wallet Case For Iphone 6/6s Full Protection - Pink
Model : None
Brand : Kiko
Color : Pink
UPC : 724933261207
Package Dimension : 7x5x1 Inch
Weight : 0.25 Lbs

Conditions :

- Grade A - Brand New Item Without Original Box Or With Open/repackaged Box

Unused Item With Or Without Slight Marks, As Described In The Listing.
May Not Come With The Retail Box Or The Original Packaging, And May Be Repackaged, Retaped, Or Resealed.
Meets The Manufacturer's Specifications.

Conditions:
- No original packaging