"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1) LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='1' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163')) AND (`e`.`entity_id` NOT IN('58', '59', '61', '62', '112', '175', '199', '255')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')
entity_id entity_type_id attribute_set_id parent_id created_at updated_at path position level children_count is_active include_in_menu request_path
3 3 3 2 2015-05-26 01:52:45 2018-06-14 04:33:22 1/2/3 3 2 9 1 1 wallpaper.html
15 3 3 2 2015-06-01 09:12:47 2017-11-13 02:19:41 1/2/15 2 2 10 1 1 cloisonne-tiles.html
29 3 3 2 2015-06-17 10:16:42 2017-11-13 02:11:40 1/2/29 4 2 16 1 1 furniture.html
30 3 3 29 2015-06-17 10:17:44 2016-09-26 17:51:04 1/2/29/30 1 3 4 1 1 furniture/by-room.html
34 3 3 30 2015-06-17 10:19:23 2015-10-14 05:39:50 1/2/29/30/34 3 4 0 1 1 furniture/by-room/bedroom.html
37 3 3 30 2015-06-17 10:20:20 2015-10-14 05:44:51 1/2/29/30/37 2 4 0 1 1 furniture/by-room/dining-room.html
38 3 3 30 2015-06-17 10:20:40 2015-10-14 05:39:21 1/2/29/30/38 1 4 0 1 1 furniture/by-room/salon.html
39 3 3 30 2015-06-17 10:40:28 2015-10-14 05:40:00 1/2/29/30/39 4 4 0 1 1 furniture/by-room/library.html
57 3 3 3 2015-07-31 02:41:55 2016-09-26 17:51:24 1/2/3/57 1 3 8 1 1 wallpaper/wallpaper-by-collection.html
60 3 3 57 2015-07-31 02:44:29 2017-11-13 02:21:42 1/2/3/57/60 1 4 0 1 1 wallpaper/wallpaper-by-collection/chinoiserie.html
66 3 3 2 2015-10-14 02:43:21 2015-12-01 03:10:48 1/2/66 1 2 54 1 1 about-us.html
67 3 3 66 2015-10-14 02:50:30 2015-11-28 16:22:23 1/2/66/67 1 3 53 1 1 about-us/discover.html
69 3 3 67 2015-10-14 02:52:11 2015-11-30 17:07:51 1/2/66/67/69 2 4 5 1 1 about-us/discover/curious-minds.html
70 3 3 67 2015-10-14 02:52:37 2017-11-13 02:10:19 1/2/66/67/70 3 4 0 1 1 about-us/discover/craftsmanship.html
71 3 3 67 2015-10-14 02:53:57 2015-11-28 16:22:47 1/2/66/67/71 4 4 43 1 1 about-us/discover/press.html
73 3 3 15 2015-10-14 03:33:40 2016-09-26 17:51:41 1/2/15/73 1 3 4 1 1 cloisonne-tiles/by-category.html
74 3 3 73 2015-10-14 03:34:06 2017-11-13 02:20:07 1/2/15/73/74 1 4 0 1 1 cloisonne-tiles/by-category/tiles.html
75 3 3 73 2015-10-14 03:35:58 2015-10-14 03:35:58 1/2/15/73/75 2 4 0 1 1 cloisonne-tiles/by-category/boxes.html
76 3 3 73 2015-10-14 03:37:20 2015-10-14 03:37:20 1/2/15/73/76 3 4 0 1 1 cloisonne-tiles/by-category/trays.html
77 3 3 73 2015-10-14 03:37:30 2015-10-14 03:37:30 1/2/15/73/77 4 4 0 1 1 cloisonne-tiles/by-category/furnishings.html
78 3 3 15 2015-10-14 03:38:03 2016-09-26 17:51:50 1/2/15/78 2 3 4 1 1 cloisonne-tiles/by-collection.html
79 3 3 78 2015-10-14 03:38:15 2016-09-26 17:54:03 1/2/15/78/79 1 4 0 1 1 cloisonne-tiles/by-collection/the-oriental-collection.html
80 3 3 78 2015-10-14 05:30:54 2016-09-26 17:54:10 1/2/15/78/80 2 4 0 1 1 cloisonne-tiles/by-collection/cabinet-of-curiosities-collection.html
81 3 3 78 2015-10-14 05:31:12 2016-09-26 17:54:18 1/2/15/78/81 3 4 0 1 1 cloisonne-tiles/by-collection/birds-of-paradise-collection.html
82 3 3 78 2015-10-14 05:31:26 2016-09-26 17:54:29 1/2/15/78/82 4 4 0 1 1 cloisonne-tiles/by-collection/the-reda-amalou-collection.html
83 3 3 29 2015-10-14 05:40:29 2016-09-26 17:51:14 1/2/29/83 2 3 10 1 1 furniture/furniture-by-category.html
84 3 3 83 2015-10-14 05:41:04 2016-09-26 17:53:43 1/2/29/83/84 1 4 0 1 1 furniture/furniture-by-category/sofas.html
85 3 3 83 2015-10-14 05:41:11 2017-11-13 02:20:59 1/2/29/83/85 2 4 0 1 1 furniture/furniture-by-category/chairs.html
86 3 3 83 2015-10-14 05:41:21 2016-09-26 17:53:27 1/2/29/83/86 3 4 0 1 1 furniture/furniture-by-category/benches.html
87 3 3 83 2015-10-14 05:41:33 2016-09-26 17:53:19 1/2/29/83/87 4 4 0 1 1 furniture/furniture-by-category/ottomans.html
88 3 3 83 2015-10-14 05:41:44 2016-09-26 17:53:10 1/2/29/83/88 5 4 0 1 1 furniture/furniture-by-category/tables.html
89 3 3 83 2015-10-14 05:42:00 2016-09-26 17:53:01 1/2/29/83/89 6 4 0 1 1 furniture/furniture-by-category/casegoods.html
90 3 3 83 2015-10-14 05:42:11 2016-09-26 17:52:19 1/2/29/83/90 7 4 0 1 1 furniture/furniture-by-category/bedside-tables.html
91 3 3 83 2015-10-14 05:42:21 2016-09-26 17:52:26 1/2/29/83/91 8 4 0 1 1 furniture/furniture-by-category/headboards.html
92 3 3 83 2015-10-14 05:42:30 2016-09-26 17:52:35 1/2/29/83/92 9 4 0 1 1 furniture/furniture-by-category/screens.html
93 3 3 83 2015-10-14 05:42:42 2016-09-26 17:52:45 1/2/29/83/93 10 4 0 1 1 furniture/furniture-by-category/wardrobe.html
111 3 3 117 2015-10-14 06:07:48 2016-09-26 17:48:56 1/2/117/111 4 3 5 1 1 home-decor/lighting.html
113 3 3 111 2015-10-14 06:08:19 2016-09-26 17:49:09 1/2/117/111/113 1 4 0 1 1 home-decor/lighting/chandeliers.html
114 3 3 111 2015-10-14 06:08:34 2016-09-26 17:49:19 1/2/117/111/114 2 4 0 1 1 home-decor/lighting/table-lamps.html
115 3 3 111 2015-10-14 06:08:44 2016-09-26 17:49:37 1/2/117/111/115 4 4 0 1 1 home-decor/lighting/floor-lamps.html
116 3 3 111 2015-10-14 06:08:54 2016-09-26 17:49:27 1/2/117/111/116 3 4 0 1 1 home-decor/lighting/wall-sconces.html
117 3 3 2 2015-10-14 06:13:13 2019-01-04 03:38:15 1/2/117 5 2 23 1 1 home-decor.html
118 3 3 117 2015-10-14 06:13:39 2016-09-26 17:43:57 1/2/117/118 1 3 8 1 1 home-decor/objects.html
119 3 3 117 2015-10-14 06:13:50 2016-09-26 17:50:06 1/2/117/119 2 3 3 1 1 home-decor/wall-decor.html
120 3 3 117 2015-10-14 06:13:58 2016-09-26 17:47:50 1/2/117/120 3 3 3 1 1 home-decor/softgoods.html
121 3 3 118 2015-10-14 06:14:08 2016-09-26 17:46:31 1/2/117/118/121 1 4 0 1 1 home-decor/objects/boxes.html
122 3 3 118 2015-10-14 06:14:17 2016-09-26 17:46:39 1/2/117/118/122 2 4 0 1 1 home-decor/objects/decorative-objects.html
123 3 3 118 2015-10-14 06:14:26 2016-09-26 17:46:47 1/2/117/118/123 3 4 0 1 1 home-decor/objects/candle-holders.html
124 3 3 118 2015-10-14 06:15:50 2016-09-26 17:46:57 1/2/117/118/124 4 4 0 1 1 home-decor/objects/trays.html
125 3 3 118 2015-10-14 06:16:01 2016-09-26 17:50:38 1/2/117/118/125 5 4 0 1 1 home-decor/objects/tabletop.html
126 3 3 118 2015-10-14 06:16:11 2016-09-26 17:50:29 1/2/117/118/126 6 4 0 1 1 home-decor/objects/picture-frames.html
127 3 3 118 2015-10-14 06:16:23 2016-09-26 17:47:06 1/2/117/118/127 7 4 0 1 1 home-decor/objects/vanity.html
128 3 3 118 2015-10-14 06:16:34 2017-11-13 02:21:19 1/2/117/118/128 8 4 0 1 1 home-decor/objects/vases.html
129 3 3 119 2015-10-14 06:16:48 2016-09-26 17:49:57 1/2/117/119/129 1 4 0 1 1 home-decor/wall-decor/mirrors.html
130 3 3 119 2015-10-14 06:16:57 2016-09-26 17:47:17 1/2/117/119/130 2 4 0 1 1 home-decor/wall-decor/wall-decor.html
131 3 3 119 2015-10-14 06:17:05 2016-09-26 17:47:40 1/2/117/119/131 3 4 0 1 1 home-decor/wall-decor/wallpaper.html
132 3 3 120 2015-10-14 06:17:13 2016-09-26 17:48:02 1/2/117/120/132 1 4 0 1 1 home-decor/softgoods/beddings.html
133 3 3 120 2015-10-14 06:17:21 2017-11-13 02:20:38 1/2/117/120/133 2 4 0 1 1 home-decor/softgoods/pillows.html
134 3 3 120 2015-10-14 06:17:32 2016-09-26 17:48:13 1/2/117/120/134 3 4 0 1 1 home-decor/softgoods/throws.html
135 3 3 2 2015-10-14 06:18:38 2015-11-23 16:41:57 1/2/135 6 2 10 1 1 accessories-gifts.html
136 3 3 135 2015-10-14 06:18:48 2016-09-26 17:34:59 1/2/135/136 1 3 2 1 1 accessories-gifts/accessories.html
137 3 3 135 2015-10-14 06:18:57 2016-09-26 17:35:43 1/2/135/137 2 3 6 1 1 accessories-gifts/gifts.html
138 3 3 136 2015-10-14 06:19:09 2016-09-26 17:35:06 1/2/135/136/138 1 4 0 1 1 accessories-gifts/accessories/jewelry.html
139 3 3 136 2015-10-14 06:19:17 2016-09-26 17:35:14 1/2/135/136/139 2 4 0 1 1 accessories-gifts/accessories/clutches.html
140 3 3 137 2015-10-14 06:19:28 2016-09-26 17:35:53 1/2/135/137/140 1 4 0 1 1 accessories-gifts/gifts/gifts-for-her.html
141 3 3 137 2015-10-14 06:19:40 2016-09-26 17:36:00 1/2/135/137/141 2 4 0 1 1 accessories-gifts/gifts/gifts-for-him.html
142 3 3 137 2015-10-14 06:19:52 2016-09-26 17:36:09 1/2/135/137/142 3 4 0 1 1 accessories-gifts/gifts/housewarming.html
143 3 3 137 2015-10-14 06:20:16 2016-09-26 17:36:19 1/2/135/137/143 4 4 0 1 1 accessories-gifts/gifts/wedding.html
144 3 3 137 2015-10-14 06:20:27 2016-09-26 17:36:27 1/2/135/137/144 5 4 0 1 1 accessories-gifts/gifts/graduation.html
145 3 3 137 2015-10-14 06:20:33 2016-09-26 17:36:35 1/2/135/137/145 6 4 0 1 1 accessories-gifts/gifts/seasonal.html
146 3 3 2 2015-10-14 06:22:35 2016-09-26 17:28:51 1/2/146 12 2 22 1 1 portfolio.html
147 3 3 146 2015-10-14 06:22:48 2016-09-26 17:32:19 1/2/146/147 1 3 14 1 1 portfolio/design-service.html
148 3 3 146 2015-10-14 06:23:01 2016-09-26 17:33:48 1/2/146/148 2 3 6 1 1 portfolio/collaborations.html
150 3 3 147 2015-10-14 06:23:46 2016-09-26 17:32:41 1/2/146/147/150 1 4 5 1 1 portfolio/design-service/residential-projects.html
151 3 3 147 2015-10-14 06:23:58 2015-11-30 17:05:45 1/2/146/147/151 2 4 7 1 1 portfolio/design-service/commercial-projects.html
152 3 3 148 2015-10-14 06:24:05 2016-09-26 17:33:58 1/2/146/148/152 2 4 0 1 1 portfolio/collaborations/events.html
153 3 3 148 2015-10-14 06:24:14 2016-09-26 17:34:13 1/2/146/148/153 3 4 3 1 1 portfolio/collaborations/products.html
154 3 3 2 2015-10-14 06:25:14 2016-09-26 17:29:01 1/2/154 13 2 8 1 1 locate.html
155 3 3 154 2015-10-14 06:26:36 2016-09-26 17:29:32 1/2/154/155 1 3 5 1 1 locate/shop.html
156 3 3 155 2015-10-14 06:26:51 2016-09-26 17:30:59 1/2/154/155/156 2 4 1 1 1 locate/shop/partners.html
157 3 3 155 2015-10-14 06:27:15 2016-09-26 17:31:06 1/2/154/155/157 1 4 2 1 1 locate/shop/boutiques.html
158 3 3 154 2015-10-14 06:28:53 2016-09-26 17:31:33 1/2/154/158 2 3 1 1 1 locate/contact.html
161 3 3 67 2015-10-19 03:44:27 2017-11-13 02:14:15 1/2/66/67/161 1 4 0 1 1 about-us/discover/the-tale.html
162 3 3 148 2015-10-23 03:22:59 2016-09-26 17:58:53 1/2/146/148/162 4 4 0 1 1 portfolio/collaborations/wholesale.html
163 3 3 158 2015-10-27 09:10:38 2017-11-13 02:22:15 1/2/154/158/163 1 4 0 1 1 locate/contact/enquiry.html
211 3 3 67 2016-02-11 10:11:11 2016-09-13 13:22:05 1/2/66/67/211 5 4 0 1 1 about-us/discover/get-inspired-12.html
213 3 3 57 2016-05-11 06:48:11 2016-05-11 06:48:11 1/2/3/57/213 3 4 0 1 1 wallpaper/wallpaper-by-collection/embellishments.html
214 3 3 57 2016-05-11 06:48:27 2016-05-11 06:48:27 1/2/3/57/214 2 4 0 1 1 wallpaper/wallpaper-by-collection/flora-and-fauna.html
215 3 3 57 2016-05-11 06:49:55 2016-05-11 06:49:55 1/2/3/57/215 4 4 0 1 1 wallpaper/wallpaper-by-collection/wonder-pearls.html
244 3 3 2 2018-08-16 02:56:29 2018-10-08 08:51:48 1/2/244 7 2 13 1 1 blog.html
245 3 3 244 2018-08-16 06:43:14 2018-08-17 10:22:58 1/2/244/245 2 3 3 1 1 blog/seasonal.html
246 3 3 244 2018-08-16 06:44:08 2018-08-17 10:12:43 1/2/244/246 3 3 2 1 1 blog/lala-curio-events.html
247 3 3 244 2018-08-16 06:45:25 2018-11-21 03:51:32 1/2/244/247 4 3 5 1 1 blog/lala-curio-products.html
248 3 3 245 2018-08-16 06:46:58 2018-08-17 10:27:54 1/2/244/245/248 1 4 0 1 1 blog/seasonal/dinner-for-two.html
249 3 3 245 2018-08-16 06:47:24 2018-08-17 03:20:49 1/2/244/245/249 2 4 0 1 1 blog/seasonal/chinese-new-year.html
250 3 3 245 2018-08-16 06:47:57 2018-08-17 03:39:38 1/2/244/245/250 3 4 0 1 1 blog/seasonal/valentine-day-special-gifts.html
251 3 3 246 2018-08-16 06:48:30 2018-08-17 03:21:26 1/2/244/246/251 1 4 0 1 1 blog/lala-curio-events/lala-brunch.html
252 3 3 246 2018-08-16 06:48:49 2018-08-17 03:21:39 1/2/244/246/252 2 4 0 1 1 blog/lala-curio-events/paris-blog.html
253 3 3 247 2018-08-16 06:49:32 2018-11-21 03:49:40 1/2/244/247/253 1 4 0 1 1 blog/lala-curio-products/wallpaper-guide.html
254 3 3 247 2018-08-16 06:50:05 2018-08-17 03:22:22 1/2/244/247/254 2 4 0 1 1 blog/lala-curio-products/african-tribal-blog.html
257 3 3 247 2018-08-16 06:51:17 2018-09-07 09:38:32 1/2/244/247/257 4 4 0 1 1 blog/lala-curio-products/chinoiserie-chez-blog.html
258 3 3 247 2018-08-16 06:51:40 2018-08-17 03:24:18 1/2/244/247/258 5 4 0 1 1 blog/lala-curio-products/reinventing-cloisonne.html