"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '141') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '141') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '141') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '141') AND (attr_table.store_id IN (0, 1)) UNION ALL SELECT `attr_table`.* FROM `catalog_category_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 = '3' WHERE (attr_table.entity_id = '141') 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
2291 3 41 0 141 Gifts for Him
2292 3 43 0 141 gifts-for-him
2293 3 46 0 141 Gifts for Him
2294 3 49 0 141 PRODUCTS
2295 3 58 0 141
2296 3 61 0 141
2297 3 133 0 141
2298 3 134 0 141
2300 3 57 0 141 accessories-gifts/gifts/gifts-for-him.html
4605 3 145 0 141 INDEX,FOLLOW
1076 3 42 0 141 1
1077 3 67 0 141 1
1078 3 50 0 141
1079 3 51 0 141 0
1080 3 68 0 141 0
1081 3 69 0 141 0
1082 3 132 0 141 1
1133 3 44 0 141 Gifts for Him
1134 3 47 0 141 Gifts for Him
1135 3 48 0 141 Gifts for Him
1136 3 62 0 141
1137 3 65 0 141
455 3 59 0 141
456 3 60 0 141
140 3 70 0 141
2299 3 57 1 141 accessories-gifts/gifts/gifts-for-him.html