IMPERFECT BOX D039-6210 RICOH AFICIO MP C2030 SEPARATION ROLLER ASSEMBLY

SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, `at_proxy_set_id`.`value` AS `proxy_set_id` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 13) 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) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (at_proxy_set_id.value = '39093')