"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 = '337') 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 = '337') 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 = '337') 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 = '337') 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 = '337') 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
10607 4 71 0 337 chair
10608 4 82 0 337 chair
10609 4 84 0 337 HORSE STATUE - - AF00001648
10610 4 85 0 337 /A/F/AF00001648_1.jpg
10611 4 86 0 337 /A/F/AF00001648_1.jpg
10612 4 87 0 337 /A/F/AF00001648_1.jpg
10613 4 97 0 337 chair
10614 4 98 0 337 chair.html
15384 4 103 0 337
10615 4 107 0 337
10616 4 109 0 337 container1
10617 4 112 0 337 chair
10618 4 113 0 337 chair
10619 4 114 0 337 chair
15383 4 117 0 337
10620 4 118 0 337 2
10621 4 119 0 337 4
10622 4 122 0 337 1
21196 4 144 0 337 INDEX,FOLLOW
3494 4 75 0 337 6500.0000
3495 4 76 0 337
3496 4 80 0 337
3497 4 120 0 337
2449 4 96 0 337 1
2450 4 100 0 337 0
2451 4 102 0 337 4
3766 4 121 0 337
2452 4 137 0 337 0
3765 4 141 0 337 0
2657 4 72 0 337
2658 4 73 0 337 60X60X80 cm
2659 4 83 0 337
2660 4 106 0 337
5380 4 77 0 337
5381 4 78 0 337
5382 4 93 0 337
5383 4 94 0 337
5384 4 104 0 337
5385 4 105 0 337