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 : Blackweb Wallet Case For Iphone 6+/7+/8+ Plus - Rose Gold
Model : 30335773
Brand : Blackweb
Color : Rose Gold
UPC : 844702089419
Package Dimension : 9x5x1 Inch
Weight : 0.375 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:
- Wristlet is not included