"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 = '380') 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 = '380') 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 = '380') 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 = '380') 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 = '380') 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
12194 4 71 0 380 MALCOLM ROUGE • DESK
12195 4 82 0 380 MALCOLM ROUGE • DESK
12196 4 84 0 380 - - EL-12-F155R
12197 4 85 0 380 /E/L/EL-12-F155R.jpg
12198 4 86 0 380 /E/L/EL-12-F155R.jpg
12199 4 87 0 380 /E/L/EL-12-F155R.jpg
12200 4 97 0 380 malcolm-rouge-desk
12201 4 98 0 380 malcolm-rouge-desk.html
15639 4 103 0 380
12202 4 107 0 380
12203 4 109 0 380 container1
12204 4 112 0 380 MALCOLM ROUGE • DESK
12205 4 113 0 380 MALCOLM ROUGE • DESK
12206 4 114 0 380 MALCOLM ROUGE • DESK
15638 4 117 0 380
12207 4 118 0 380 2
12208 4 119 0 380 4
12209 4 122 0 380 0
21325 4 144 0 380 INDEX,FOLLOW
4142 4 75 0 380 21500.0000
4143 4 76 0 380
4144 4 80 0 380
4145 4 120 0 380
2892 4 96 0 380 1
2893 4 100 0 380 0
2894 4 102 0 380 4
3919 4 121 0 380
2895 4 137 0 380 0
3918 4 141 0 380 0
3193 4 72 0 380 Malcolm Rouge is a French inspired elm wood desk table with intricately painted gold accents.
3194 4 73 0 380 122x62x76 cm
3195 4 83 0 380
3196 4 106 0 380
6301 4 77 0 380
6302 4 78 0 380
6303 4 93 0 380
6304 4 94 0 380
6305 4 104 0 380
6306 4 105 0 380