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 : Epson 273 Black, C/m/y 4pk Combo Ink Cartridges - Black Cyan, Magenta, Yellow
Model : T273520
Brand : Epson
Color : Black, C/M/Y
UPC : 0010343902145
Package Dimension : 7x3x4 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:
- No packaging
- sealed