"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
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 = '243') 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 = '243') 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 = '243') 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 = '243') 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 = '243') 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
9103 4 71 0 243 Table decor
9104 4 82 0 243 Table decor
9105 4 84 0 243 Table decor - Natural stones, shells and skulls were part of one's Cabinet of Curiosities. This Wunderkammer inspired bronze skull sitting ontop of a glass canister is delightful for a jewelry box or placed ontop of a vanity. - D42130074
9106 4 85 0 243 /D/4/D42130074_1.jpg
9107 4 86 0 243 /D/4/D42130074_1.jpg
9108 4 87 0 243 /D/4/D42130074_1.jpg
9109 4 97 0 243 table-decor
9110 4 98 0 243 table-decor.html
11689 4 103 0 243
9111 4 107 0 243
9112 4 109 0 243 container1
9113 4 112 0 243 Table decor
9114 4 113 0 243 Table decor
9115 4 114 0 243 Table decor
11688 4 117 0 243
9116 4 118 0 243 2
9117 4 119 0 243 4
9118 4 122 0 243 1
20914 4 144 0 243 INDEX,FOLLOW
3118 4 75 0 243 1200.0000
3119 4 76 0 243
3120 4 80 0 243
3121 4 120 0 243
2073 4 96 0 243 1
2074 4 100 0 243 0
2075 4 102 0 243 4
2758 4 121 0 243
2076 4 137 0 243 0
2281 4 72 0 243 Natural stones, shells and skulls were part of one's Cabinet of Curiosities. This Wunderkammer inspired bronze skull sitting ontop of a glass canister is delightful for a jewelry box or placed ontop of a vanity.
2282 4 73 0 243 14X14X21 cm
2283 4 83 0 243
2284 4 106 0 243
4816 4 77 0 243
4817 4 78 0 243
4818 4 93 0 243
4819 4 94 0 243
4820 4 104 0 243
4821 4 105 0 243
10688 4 98 1 243 table-decor.html