"Back"

SQL Select

Executed SQL
SELECT `attr_table`.* FROM `catalog_product_entity_varchar` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '476') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_decimal` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '476') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_int` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '476') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_text` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '476') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_product_entity_datetime` AS `attr_table` INNER JOIN `eav_entity_attribute` AS `set_table` ON attr_table.attribute_id = set_table.attribute_id AND set_table.attribute_set_id = '4' WHERE (attr_table.entity_id = '476') AND (attr_table.store_id IN (0, 1)) ORDER BY `store_id` ASC
value_id entity_type_id attribute_id store_id entity_id value
13730 4 71 0 476 TAYLOR • WALLART
13731 4 82 0 476 TAYLOR • WALLART
13732 4 84 0 476 NERO • WARDROBE - The Nero wardrobe matches every home with it's hand carved natural wood and round medalion handle. Solid and rustic, this wardrobe can be used to store sporting equipment, shoes, coats and larger items. - EL-12-W024
13733 4 85 0 476 /E/L/EL-12-W024.jpg
13734 4 86 0 476 /E/L/EL-12-W024.jpg
13735 4 87 0 476 /E/L/EL-12-W024.jpg
13736 4 97 0 476 taylor-wallart
13737 4 98 0 476 taylor-wallart.html
16122 4 103 0 476
13738 4 107 0 476
13739 4 109 0 476 container1
13740 4 112 0 476 TAYLOR • WALLART
13741 4 113 0 476 TAYLOR • WALLART
13742 4 114 0 476 TAYLOR • WALLART
16121 4 117 0 476
13743 4 118 0 476 2
13744 4 119 0 476 4
13745 4 122 0 476 0
21613 4 144 0 476 INDEX,FOLLOW
4526 4 75 0 476 6300.0000
4527 4 76 0 476
4528 4 80 0 476
4529 4 120 0 476
3276 4 96 0 476 1
3277 4 100 0 476 0
3278 4 102 0 476 4
4180 4 121 0 476
3279 4 137 0 476 0
4179 4 141 0 476 0
3577 4 72 0 476 Wall art
3578 4 73 0 476 71x3x107 cm
3579 4 83 0 476
3580 4 106 0 476
6877 4 77 0 476
6878 4 78 0 476
6879 4 93 0 476
6880 4 94 0 476
6881 4 104 0 476
6882 4 105 0 476