C13T05414010 EPSON T0541 INK CARTRIDGE PHOTO BLACK

SELECT `e`.*, `at_proxy_set_id`.`value` AS `proxy_set_id`, `at_box_condition`.`value` AS `box_condition`, `at_clr`.`value` AS `clr`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_varchar` AS `at_proxy_set_id` ON (`at_proxy_set_id`.`entity_id` = `e`.`entity_id`) AND (`at_proxy_set_id`.`attribute_id` = '253') AND (`at_proxy_set_id`.`store_id` = 0) INNER JOIN `catalog_product_entity_varchar` AS `at_box_condition` ON (`at_box_condition`.`entity_id` = `e`.`entity_id`) AND (`at_box_condition`.`attribute_id` = '161') AND (`at_box_condition`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `at_clr` ON (`at_clr`.`entity_id` = `e`.`entity_id`) AND (`at_clr`.`attribute_id` = '217') AND (`at_clr`.`store_id` = 0) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (at_proxy_set_id.value = '3447') AND (at_box_condition.value = 'AB') AND (at_clr.value != '60481') ORDER BY `e`.`entity_id` DESC
product_Id : 100133
current_color : Matte Black
proUrl : https://upgrade.dev.promotoner.com/eu/c13t05484010-epson-t0548-ink-cartridge-matte-black-39246-new.html
current_Qty : 0
default_partno : C13T05484010
current_product_color_swatch1 : 60448
small image : /2/7/27863.jpg
product_name : C13T05484010 EPSON T0548 INK CARTRIDGE MATTE BLACK
product_type : Genuine Original

product_Id : 98213
current_color : Magenta
proUrl : https://upgrade.dev.promotoner.com/eu/c13t05434010-epson-t0543-ink-cartridge-magenta-12754-new.html
current_Qty : 0
default_partno : C13T05434010
current_product_color_swatch1 : 60438
small image : /4/0/40364.png
product_name : C13T05434010 EPSON T0543 INK CARTRIDGE MAGENTA
product_type : Genuine Original

product_Id : 98159
current_color : Cyan
proUrl : https://upgrade.dev.promotoner.com/eu/c13t05424010-epson-t0542-ink-cartridge-cyan-12357-new.html
current_Qty : 0
default_partno : C13T05424010
current_product_color_swatch1 : 60366
small image : /4/0/40365.png
product_name : C13T05424010 EPSON T0542 INK CARTRIDGE CYAN
product_type : Genuine Original

product_Id : 98157
current_color : Yellow
proUrl : https://upgrade.dev.promotoner.com/eu/c13t05444010-epson-t0544-ink-cartridge-yellow-12352-new.html
current_Qty : 0
default_partno : C13T05444010
current_product_color_swatch1 : 60562
small image : /4/0/40363.png
product_name : C13T05444010 EPSON T0544 INK CARTRIDGE YELLOW
product_type : Genuine Original

product_Id : 98155
current_color : Red
proUrl : https://upgrade.dev.promotoner.com/eu/c13t05474010-epson-t0547-ink-cartridge-red-12351-new.html
current_Qty : 0
default_partno : C13T05474010
current_product_color_swatch1 : 60497
small image : /4/0/40362.png
product_name : C13T05474010 EPSON T0547 INK CARTRIDGE RED
product_type : Genuine Original

product_Id : 98153
current_color : Blue
proUrl : https://upgrade.dev.promotoner.com/eu/c13t05494010-epson-t0549-ink-cartridge-blue-12350-new.html
current_Qty : 0
default_partno : C13T05494010
current_product_color_swatch1 : 60330
small image : /4/0/40361.png
product_name : C13T05494010 EPSON T0549 INK CARTRIDGE BLUE
product_type : Genuine Original