| 1 | SHOW FULL COLUMNS FROM `cat4_sites` | | 20 | 20 | 3 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | | 1 | 1 | 1 |
| 3 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE `Site`.`domain` IS NOT NULL AND `Site`.`domain` <> "" ORDER BY `Site`.`sort` DESC | | 0 | 0 | 1 |
| 4 | SELECT `Site`.`id`, `Site`.`alias`, IF(Site.domain = "www.centralspeech.ca" OR Site.domain = "www.www.centralspeech.ca", 1, 0) AS domain_match FROM `cat4_sites` AS `Site` WHERE `Site`.`alias` IS NOT NULL AND `Site`.`alias` <> "" ORDER BY `Site`.`flag_admin` ASC, `domain_match` DESC, `Site`.`sort` DESC | | 5 | 5 | 3 |
| 5 | SHOW FULL COLUMNS FROM `cat4_pages` | | 22 | 22 | 3 |
| 6 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE (`Site`.`alias` = "main" OR `Site`.`id`="main") AND `Page`.`parent_id`="0" LIMIT 1 | | 1 | 1 | 1 |
| 7 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE (`Site`.`alias` = "main" OR `Site`.`id`="main")
AND `Page`.`parent_id` = "29"
AND (`Page`.`alias` = "therapy" OR `Page`.`id` = "therapy") LIMIT 1 | | 1 | 1 | 2 |
| 8 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE (`Site`.`alias` = "main" OR `Site`.`id`="main")
AND `Page`.`parent_id` = "129"
AND (`Page`.`alias` = "what-is-auditory-verbal" OR `Page`.`id` = "what-is-auditory-verbal") LIMIT 1 | | 1 | 1 | 1 |
| 9 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 157 LIMIT 1 | | 1 | 1 | 2 |
| 10 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "59" AND `Page`.`rght` >= "60" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 3 | 3 | 0 |
| 11 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 12 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE `Site`.`id` = 4 LIMIT 1 | | 1 | 1 | 0 |
| 13 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE `Site`.`id` = 'main' LIMIT 1 | | 0 | 0 | 5 |
| 14 | SHOW FULL COLUMNS FROM `cat4_admins` | | 25 | 25 | 3 |
| 15 | SHOW FULL COLUMNS FROM `cat4_admins_sites` | | 22 | 22 | 2 |
| 16 | SHOW FULL COLUMNS FROM `cat4_updates` | | 12 | 12 | 2 |
| 17 | SHOW FULL COLUMNS FROM `cat4_modules` | | 21 | 21 | 2 |
| 18 | SHOW FULL COLUMNS FROM `cat4_modules_settings` | | 12 | 12 | 2 |
| 19 | SELECT `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_sites` AS `Site` WHERE (`Site`.`alias`="main" OR `Site`.`id`="main") LIMIT 1 | | 1 | 1 | 0 |
| 20 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`site_id`="4" AND (`Page`.`alias`="157" OR `Page`.`id`="157") LIMIT 1 | | 1 | 1 | 0 |
| 21 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`site_id`="0" AND `Module`.`page_id` = "157" AND `Module`.`div` IS NOT NULL AND `Module`.`div` != "" ORDER BY `Module`.`sort` DESC | | 1 | 1 | 0 |
| 22 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 341 LIMIT 1 | | 1 | 1 | 0 |
| 23 | SHOW FULL COLUMNS FROM `cat4_contents` | | 9 | 9 | 3 |
| 24 | SHOW FULL COLUMNS FROM `cat4_contents_revs` | | 11 | 11 | 1 |
| 25 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 340 | | 2 | 2 | 0 |
| 26 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 341 | | 0 | 0 | 0 |
| 27 | SELECT `Content`.`id`, `Content`.`data_id`, `Content`.`title`, `Content`.`body`, `Content`.`columns`, `Content`.`created`, `Content`.`created_by`, `Content`.`modified`, `Content`.`modified_by` FROM `cat4_contents` AS `Content` WHERE `Content`.`data_id` = 340 LIMIT 1 | | 1 | 1 | 1 |
| 28 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`page_id`="0" AND `Module`.`site_id`="4" AND `Module`.`div` IS NOT NULL AND `Module`.`div` != "" AND `Module`.`flag_xsite`="0" AND `Module`.`div` != "main" ORDER BY `Module`.`sort` DESC | | 2 | 2 | 1 |
| 29 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 290 LIMIT 1 | | 1 | 1 | 0 |
| 30 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 289 | | 5 | 5 | 0 |
| 31 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 290 | | 0 | 0 | 0 |
| 32 | SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`alias`, `Page`.`navigation`, `Page`.`lft`, `Page`.`rght`, `Page`.`site_id`, `Page`.`flag_hidden`, `Page`.`link`, `Page`.`type`, `Page`.`modified`, `Site`.`id`, `Site`.`data_id`, `Site`.`alias`, `EditPageModule`.`id`, `AssociatedPage`.`id`, `AssociatedPage`.`data_id`, `AssociatedPage`.`link`, `AssociatedPage`.`flag_hidden`, `AssociatedPage`.`type`, `AssociatedPage`.`lft`, `AssociatedPage`.`rght` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) LEFT JOIN `cat4_modules` AS `EditPageModule` ON (`EditPageModule`.`plugin` = "cat4_page" AND `EditPageModule`.`controller`="admin_pages" AND `EditPageModule`.`page_id` IS NOT NULL AND `EditPageModule`.`page_id` <> 0 AND `EditPageModule`.`page_id` = `Page`.`id` AND `EditPageModule`.`module_id` = 0 AND `EditPageModule`.`page_id` = `Page`.`id`) LEFT JOIN `cat4_pages` AS `AssociatedPage` ON (`AssociatedPage`.`data_id` = `Page`.`id`) WHERE `Page`.`site_id` = "4" AND `Page`.`flag_hidden` = 1 ORDER BY `Page`.`lft` ASC | | 1 | 1 | 1 |
| 33 | SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`alias`, `Page`.`navigation`, `Page`.`lft`, `Page`.`rght`, `Page`.`site_id`, `Page`.`flag_hidden`, `Page`.`link`, `Page`.`type`, `Page`.`modified`, `Site`.`id`, `Site`.`data_id`, `Site`.`alias`, `EditPageModule`.`id`, `AssociatedPage`.`id`, `AssociatedPage`.`data_id`, `AssociatedPage`.`link`, `AssociatedPage`.`flag_hidden`, `AssociatedPage`.`type`, `AssociatedPage`.`lft`, `AssociatedPage`.`rght` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) LEFT JOIN `cat4_modules` AS `EditPageModule` ON (`EditPageModule`.`plugin` = "cat4_page" AND `EditPageModule`.`controller`="admin_pages" AND `EditPageModule`.`page_id` IS NOT NULL AND `EditPageModule`.`page_id` <> 0 AND `EditPageModule`.`page_id` = `Page`.`id` AND `EditPageModule`.`module_id` = 0 AND `EditPageModule`.`page_id` = `Page`.`id`) LEFT JOIN `cat4_pages` AS `AssociatedPage` ON (`AssociatedPage`.`data_id` = `Page`.`id`) WHERE `Page`.`site_id` = "4" AND `Page`.`flag_hidden` <> 1 AND ( `Page`.`lft` <= 46 OR `Page`.`rght` >= 47) ORDER BY `Page`.`lft` ASC | | 45 | 45 | 1 |
| 34 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 31 LIMIT 1 | | 1 | 1 | 1 |
| 35 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "38" AND `Page`.`rght` >= "45" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 36 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 37 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 127 LIMIT 1 | | 1 | 1 | 1 |
| 38 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "48" AND `Page`.`rght` >= "57" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 39 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 40 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 129 LIMIT 1 | | 1 | 1 | 0 |
| 41 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "58" AND `Page`.`rght` >= "69" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 42 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 43 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 131 LIMIT 1 | | 1 | 1 | 1 |
| 44 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "70" AND `Page`.`rght` >= "87" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 1 |
| 45 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 46 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 133 LIMIT 1 | | 1 | 1 | 0 |
| 47 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "88" AND `Page`.`rght` >= "97" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 1 |
| 48 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 49 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 135 LIMIT 1 | | 1 | 1 | 1 |
| 50 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "98" AND `Page`.`rght` >= "109" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 0 |
| 51 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 52 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 137 LIMIT 1 | | 1 | 1 | 0 |
| 53 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "110" AND `Page`.`rght` >= "117" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 2 |
| 54 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 2 |
| 55 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 139 LIMIT 1 | | 1 | 1 | 1 |
| 56 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "118" AND `Page`.`rght` >= "123" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 1 |
| 57 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 0 |
| 58 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 141 LIMIT 1 | | 1 | 1 | 0 |
| 59 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "124" AND `Page`.`rght` >= "127" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 2 | 2 | 1 |
| 60 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 61 | SELECT `Module`.`id`, `Module`.`site_id`, `Module`.`page_id`, `Module`.`module_id`, `Module`.`data_id`, `Module`.`display_page_id`, `Module`.`display_module_id`, `Module`.`flag_xsite`, `Module`.`sort`, `Module`.`plugin`, `Module`.`controller`, `Module`.`action`, `Module`.`div`, `Module`.`alias`, `Module`.`title`, `Module`.`subtitle`, `Module`.`flag_hidden`, `Module`.`created`, `Module`.`created_by`, `Module`.`modified`, `Module`.`modified_by` FROM `cat4_modules` AS `Module` WHERE `Module`.`id` = 454 LIMIT 1 | | 1 | 1 | 0 |
| 62 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 453 | | 5 | 5 | 0 |
| 63 | SELECT `ModulesSettings`.`id`, `ModulesSettings`.`module_id`, `ModulesSettings`.`key`, `ModulesSettings`.`value`, `ModulesSettings`.`description`, `ModulesSettings`.`type`, `ModulesSettings`.`class`, `ModulesSettings`.`options`, `ModulesSettings`.`created`, `ModulesSettings`.`created_by`, `ModulesSettings`.`modified`, `ModulesSettings`.`modified_by` FROM `cat4_modules_settings` AS `ModulesSettings` WHERE `ModulesSettings`.`module_id` = 454 | | 0 | 0 | 0 |
| 64 | SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`alias`, `Page`.`navigation`, `Page`.`lft`, `Page`.`rght`, `Page`.`site_id`, `Page`.`flag_hidden`, `Page`.`link`, `Page`.`type`, `Page`.`modified`, `Site`.`id`, `Site`.`data_id`, `Site`.`alias`, `EditPageModule`.`id`, `AssociatedPage`.`id`, `AssociatedPage`.`data_id`, `AssociatedPage`.`link`, `AssociatedPage`.`flag_hidden`, `AssociatedPage`.`type`, `AssociatedPage`.`lft`, `AssociatedPage`.`rght` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) LEFT JOIN `cat4_modules` AS `EditPageModule` ON (`EditPageModule`.`plugin` = "cat4_page" AND `EditPageModule`.`controller`="admin_pages" AND `EditPageModule`.`page_id` IS NOT NULL AND `EditPageModule`.`page_id` <> 0 AND `EditPageModule`.`page_id` = `Page`.`id` AND `EditPageModule`.`module_id` = 0 AND `EditPageModule`.`page_id` = `Page`.`id`) LEFT JOIN `cat4_pages` AS `AssociatedPage` ON (`AssociatedPage`.`data_id` = `Page`.`id`) WHERE `Page`.`site_id` = "4" AND `Page`.`flag_hidden` = 1 ORDER BY `Page`.`lft` ASC | | 1 | 1 | 0 |
| 65 | SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`alias`, `Page`.`navigation`, `Page`.`lft`, `Page`.`rght`, `Page`.`site_id`, `Page`.`flag_hidden`, `Page`.`link`, `Page`.`type`, `Page`.`modified`, `Site`.`id`, `Site`.`data_id`, `Site`.`alias`, `EditPageModule`.`id`, `AssociatedPage`.`id`, `AssociatedPage`.`data_id`, `AssociatedPage`.`link`, `AssociatedPage`.`flag_hidden`, `AssociatedPage`.`type`, `AssociatedPage`.`lft`, `AssociatedPage`.`rght` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) LEFT JOIN `cat4_modules` AS `EditPageModule` ON (`EditPageModule`.`plugin` = "cat4_page" AND `EditPageModule`.`controller`="admin_pages" AND `EditPageModule`.`page_id` IS NOT NULL AND `EditPageModule`.`page_id` <> 0 AND `EditPageModule`.`page_id` = `Page`.`id` AND `EditPageModule`.`module_id` = 0 AND `EditPageModule`.`page_id` = `Page`.`id`) LEFT JOIN `cat4_pages` AS `AssociatedPage` ON (`AssociatedPage`.`data_id` = `Page`.`id`) WHERE `Page`.`site_id` = "4" AND `Page`.`flag_hidden` <> 1 AND ( `Page`.`lft` <= 46 OR `Page`.`rght` >= 47) ORDER BY `Page`.`lft` ASC | | 45 | 45 | 1 |
| 66 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 159 LIMIT 1 | | 1 | 1 | 1 |
| 67 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "61" AND `Page`.`rght` >= "62" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 3 | 3 | 1 |
| 68 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 69 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 161 LIMIT 1 | | 1 | 1 | 0 |
| 70 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "63" AND `Page`.`rght` >= "64" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 3 | 3 | 0 |
| 71 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 72 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 163 LIMIT 1 | | 1 | 1 | 0 |
| 73 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "65" AND `Page`.`rght` >= "66" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 3 | 3 | 1 |
| 74 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |
| 75 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`id` = 165 LIMIT 1 | | 1 | 1 | 0 |
| 76 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by` FROM `cat4_pages` AS `Page` WHERE `Page`.`lft` <= "67" AND `Page`.`rght` >= "68" AND `Page`.`site_id` = "4" ORDER BY `Page`.`lft` ASC | | 3 | 3 | 1 |
| 77 | SELECT `Page`.`id`, `Page`.`site_id`, `Page`.`parent_id`, `Page`.`data_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`title`, `Page`.`navigation`, `Page`.`flag_hidden`, `Page`.`keywords`, `Page`.`description`, `Page`.`metadata`, `Page`.`layout`, `Page`.`view`, `Page`.`link`, `Page`.`type`, `Page`.`alias`, `Page`.`status`, `Page`.`created`, `Page`.`created_by`, `Page`.`modified`, `Page`.`modified_by`, `Site`.`id`, `Site`.`data_id`, `Site`.`sort`, `Site`.`flag_admin`, `Site`.`title`, `Site`.`keywords`, `Site`.`description`, `Site`.`metadata`, `Site`.`layout`, `Site`.`view`, `Site`.`alias`, `Site`.`flag_long_urls`, `Site`.`flag_main_site`, `Site`.`domain`, `Site`.`flag_subdomain`, `Site`.`flag_root`, `Site`.`created`, `Site`.`created_by`, `Site`.`modified`, `Site`.`modified_by` FROM `cat4_pages` AS `Page` LEFT JOIN `cat4_sites` AS `Site` ON (`Page`.`site_id` = `Site`.`id`) WHERE `Page`.`parent_id` <> 0 AND `Site`.`id` = "4" ORDER BY `Page`.`lft` ASC LIMIT 1 | | 1 | 1 | 1 |