- Home
- Catalogue
Catalogue
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`, `mg_url_rewrite`.`request_path` FROM `mg_catalog_category_entity` AS `e` INNER JOIN `mg_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` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 1) INNER JOIN `mg_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` = '69') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `mg_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` = '69') AND (`at_include_in_menu`.`store_id` = 1) LEFT JOIN `mg_url_rewrite` ON (mg_url_rewrite.entity_id =e.entity_id) AND (mg_url_rewrite.is_autogenerated = 1 AND mg_url_rewrite.store_id = 1 AND mg_url_rewrite.entity_type = 'category') WHERE (`e`.`entity_id` IN('128', '133', '19', '50', '51', '52', '53', '93', '134', '4', '7', '23', '24', '25', '102', '26', '108', '121', '8', '12', '14', '122', '17', '44', '45', '46', '43', '89', '98', '16', '34', '42', '61', '35', '36', '37', '79', '80', '38', '39', '40', '41', '85', '87', '86', '88', '20', '81', '115', '116', '117', '118', '119', '54', '55', '56', '57', '58', '113', '22', '62', '63', '64', '70', '82', '84', '65', '72', '78', '90', '95', '66', '71', '91', '83', '73', '92', '101', '112', '109', '18', '47', '48', '49', '21', '59', '60', '69', '100', '103', '104', '105', '106', '107', '110', '111', '123', '124', '126', '127', '74', '96', '97', '114', '99', '94', '132', '77', '76', '11', '27', '28', '29', '30', '9', '13', '15', '31', '75', '32', '33', '125')) AND (`e`.`entity_id` NOT IN('19', '50', '51', '52', '53', '93', '134', '14', '17', '44', '45', '46', '43', '89', '98', '35', '37', '79', '58', '62', '63', '82', '65', '72', '72', '78', '78', '90', '95', '66', '71', '71', '91', '73', '92', '109', '18', '47', '47', '48', '48', '49', '49', '21', '59', '60', '74', '96', '97', '27', '28', '29', '31', '125')) 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') ORDER BY `entity_id` ASC SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, `mg_url_rewrite`.`request_path` FROM `mg_catalog_category_entity` AS `e` INNER JOIN `mg_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` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `mg_catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 1) LEFT JOIN `mg_url_rewrite` ON (mg_url_rewrite.entity_id =e.entity_id) AND (mg_url_rewrite.is_autogenerated = 1 AND mg_url_rewrite.store_id = 1 AND mg_url_rewrite.entity_type = 'category') WHERE (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (`e`.`entity_id` IN('86', '87', '88')) ORDER BY `entity_id` ASC, `e`.`position` ASC
Categories: Catalogue
Shop By
Now Shopping by
Shopping Options- Category Schools Remove This Item