| 1 | SELECT `Aetc`.`id`, `Aetc`.`name_short`, `Aetc`.`url`, `Aetc`.`code` FROM `cakedb_2022`.`aetcs` AS `Aetc` WHERE 1 = 1 | | 4 | 4 | 1 |
| 2 | SELECT `Aetc`.`id`, `Aetc`.`name`, `Aetc`.`name_short`, `Aetc`.`code`, `Aetc`.`url`, `Aetc`.`color_1`, `Aetc`.`color_2`, `Aetc`.`color_3`, `Aetc`.`top_bar_color`, `Aetc`.`ribbon_image`, `Aetc`.`header_image`, `Aetc`.`admin_name`, `Aetc`.`admin_email`, `Aetc`.`admin_phone`, `Aetc`.`web_name`, `Aetc`.`web_email`, `Aetc`.`web_phone`, `Aetc`.`removable`, `Aetc`.`created`, `Aetc`.`created_by`, `Aetc`.`updated`, `Aetc`.`updated_by`, `Aetc`.`timezone_id`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Aetc`.`public_flag`, `Aetc`.`associated_states`, `Aetc`.`ga_account`, `Aetc`.`footer_grant`, `Aetc`.`google_tag_manager`, `Aetc`.`grant_number`, `Aetc`.`institution`, `Aetc`.`certificate_text`, `Aetc`.`color_4`, `Aetc`.`color_5`, `HeaderImage`.`id`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`name`, `HeaderImage`.`attachment`, `HeaderImage`.`dir`, `HeaderImage`.`type`, `HeaderImage`.`size`, `HeaderImage`.`url`, `HeaderImage`.`visibility`, `HeaderImage`.`active`, `HeaderImage`.`category_id`, `HeaderImage`.`created`, `HeaderImage`.`aetc_id`, `HomepageMapImage`.`id`, `HomepageMapImage`.`model`, `HomepageMapImage`.`foreign_key`, `HomepageMapImage`.`name`, `HomepageMapImage`.`attachment`, `HomepageMapImage`.`dir`, `HomepageMapImage`.`type`, `HomepageMapImage`.`size`, `HomepageMapImage`.`url`, `HomepageMapImage`.`visibility`, `HomepageMapImage`.`active`, `HomepageMapImage`.`category_id`, `HomepageMapImage`.`created`, `HomepageMapImage`.`aetc_id`, `RibbonImage`.`id`, `RibbonImage`.`model`, `RibbonImage`.`foreign_key`, `RibbonImage`.`name`, `RibbonImage`.`attachment`, `RibbonImage`.`dir`, `RibbonImage`.`type`, `RibbonImage`.`size`, `RibbonImage`.`url`, `RibbonImage`.`visibility`, `RibbonImage`.`active`, `RibbonImage`.`category_id`, `RibbonImage`.`created`, `RibbonImage`.`aetc_id`, `Timezone`.`id`, `Timezone`.`name`, `Timezone`.`abbreviation` FROM `cakedb_2022`.`aetcs` AS `Aetc` LEFT JOIN `cakedb_2022`.`attachments` AS `HeaderImage` ON (`Aetc`.`header_image` = `HeaderImage`.`id`) LEFT JOIN `cakedb_2022`.`attachments` AS `HomepageMapImage` ON (`Aetc`.`homepage_map_image` = `HomepageMapImage`.`id`) LEFT JOIN `cakedb_2022`.`attachments` AS `RibbonImage` ON (`Aetc`.`ribbon_image` = `RibbonImage`.`id`) LEFT JOIN `cakedb_2022`.`timezones` AS `Timezone` ON (`Aetc`.`timezone_id` = `Timezone`.`id`) WHERE `Aetc`.`id` = 4 LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `top_bar_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC | | 0 | 0 | 1 |
| 4 | SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `quick_links_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC | | 0 | 0 | 0 |
| 5 | SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `national_resources_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC | | 0 | 0 | 0 |
| 6 | SELECT `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `regional_resources_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC | | 0 | 0 | 0 |
| 7 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id`, `Link`.`id`, `Link`.`title`, `Link`.`description`, `Link`.`url`, `Link`.`national_resources_flag`, `Link`.`quick_links_flag`, `Link`.`slider_flag`, `Link`.`sort`, `Link`.`updated`, `Link`.`created`, `Link`.`top_bar_flag`, `Link`.`aetc_id`, `Link`.`title_tag`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`menu_links` AS `MenuLink` LEFT JOIN `cakedb_2022`.`links` AS `Link` ON (`MenuLink`.`link_id` = `Link`.`id`) WHERE `MenuLink`.`aetc_id` = 4 ORDER BY `lft` ASC | | 0 | 0 | 1 |
| 8 | SELECT `Site`.`id`, `Site`.`title` FROM `cakedb_2022`.`sites` AS `Site` WHERE `Site`.`aetc_id` = 4 | | 0 | 0 | 1 |
| 9 | SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`subtitle`, `News`.`body`, `News`.`slug`, `News`.`keywords`, `News`.`sidebar_flag`, `News`.`sidebar`, `News`.`content_status_id`, `News`.`published`, `News`.`created`, `News`.`updated`, `News`.`group_id`, `News`.`public`, `News`.`featured`, `News`.`content_type_id`, `News`.`news_id`, `News`.`site_id`, `News`.`aetc_id`, `News`.`page_options`, `News`.`section1`, `News`.`repeater`, `News`.`repeater_title`, `News`.`body_title`, `News`.`body_image_url`, `News`.`section2_title`, `News`.`section2`, `News`.`sidebar_view_all_link`, `News`.`is_announcement` FROM `cakedb_2022`.`content_pages` AS `News` WHERE `News`.`content_type_id` = 2 AND `News`.`public` = '1' AND `News`.`aetc_id` = 4 AND NOT (`News`.`published` IS NULL) AND ((`News`.`is_announcement` = 0) OR (`News`.`is_announcement` Is NULL)) ORDER BY `News`.`published` DESC LIMIT 5 | | 0 | 0 | 1 |
| 10 | SELECT `Site`.`id`, `Site`.`title` FROM `cakedb_2022`.`sites` AS `Site` WHERE `Site`.`aetc_id` = 4 | | 0 | 0 | 0 |
