| 1 | SELECT `Aetc`.`id`, `Aetc`.`name_short`, `Aetc`.`url` FROM `cakedb`.`aetcs` AS `Aetc` LEFT JOIN `cakedb`.`users` AS `Creator` ON (`Aetc`.`created_by` = `Creator`.`id`) LEFT JOIN `cakedb`.`users` AS `Updater` ON (`Aetc`.`updated_by` = `Updater`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HeaderImage` ON (`Aetc`.`header_image` = `HeaderImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HomepageMapImage` ON (`Aetc`.`homepage_map_image` = `HomepageMapImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `RibbonImage` ON (`Aetc`.`ribbon_image` = `RibbonImage`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Aetc`.`timezone_id` = `Timezone`.`id`) WHERE 1 = 1 | | 3 | 3 | 1 |
| 2 | SELECT `Site`.`id`, `Site`.`title`, `Site`.`code`, `Site`.`description`, `Site`.`image`, `Site`.`imagecaption`, `Site`.`address1`, `Site`.`address2`, `Site`.`city`, `Site`.`state`, `Site`.`zip`, `Site`.`phone`, `Site`.`fax`, `Site`.`email`, `Site`.`active`, `Site`.`sortorder`, `Site`.`aetc_id`, `Site`.`timezone_id` FROM `cakedb`.`sites` AS `Site` WHERE `Site`.`aetc_id` IN (1, 2, 3) | | 27 | 27 | 1 |
| 3 | 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`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Creator`.`id`, `Creator`.`email`, `Creator`.`password`, `Creator`.`first_name`, `Creator`.`last_name`, `Creator`.`credentials`, `Creator`.`organization`, `Creator`.`address1`, `Creator`.`address2`, `Creator`.`city`, `Creator`.`state`, `Creator`.`zip`, `Creator`.`phone`, `Creator`.`dob`, `Creator`.`uniqueidnumber`, `Creator`.`active`, `Creator`.`created`, `Creator`.`role`, `Creator`.`taap_access`, `Creator`.`email_list_bak`, `Creator`.`site`, `Creator`.`last_login`, `Creator`.`attempt_time`, `Creator`.`attempt_try`, `Creator`.`speaker`, `Creator`.`ftcc_id`, `Creator`.`pif_id`, `Creator`.`email_list`, `Creator`.`deleted`, `Creator`.`deleted_flag`, (CONCAT(`Creator`.`first_name`, " ", `Creator`.`last_name`)) AS `Creator__name`, `Updater`.`id`, `Updater`.`email`, `Updater`.`password`, `Updater`.`first_name`, `Updater`.`last_name`, `Updater`.`credentials`, `Updater`.`organization`, `Updater`.`address1`, `Updater`.`address2`, `Updater`.`city`, `Updater`.`state`, `Updater`.`zip`, `Updater`.`phone`, `Updater`.`dob`, `Updater`.`uniqueidnumber`, `Updater`.`active`, `Updater`.`created`, `Updater`.`role`, `Updater`.`taap_access`, `Updater`.`email_list_bak`, `Updater`.`site`, `Updater`.`last_login`, `Updater`.`attempt_time`, `Updater`.`attempt_try`, `Updater`.`speaker`, `Updater`.`ftcc_id`, `Updater`.`pif_id`, `Updater`.`email_list`, `Updater`.`deleted`, `Updater`.`deleted_flag`, (CONCAT(`Updater`.`first_name`, " ", `Updater`.`last_name`)) AS `Updater__name`, `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`.`aetcs` AS `Aetc` LEFT JOIN `cakedb`.`users` AS `Creator` ON (`Aetc`.`created_by` = `Creator`.`id`) LEFT JOIN `cakedb`.`users` AS `Updater` ON (`Aetc`.`updated_by` = `Updater`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HeaderImage` ON (`Aetc`.`header_image` = `HeaderImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `HomepageMapImage` ON (`Aetc`.`homepage_map_image` = `HomepageMapImage`.`id`) LEFT JOIN `cakedb`.`attachments` AS `RibbonImage` ON (`Aetc`.`ribbon_image` = `RibbonImage`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Aetc`.`timezone_id` = `Timezone`.`id`) WHERE `Aetc`.`id` = 3 LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT `Site`.`id`, `Site`.`title`, `Site`.`code`, `Site`.`description`, `Site`.`image`, `Site`.`imagecaption`, `Site`.`address1`, `Site`.`address2`, `Site`.`city`, `Site`.`state`, `Site`.`zip`, `Site`.`phone`, `Site`.`fax`, `Site`.`email`, `Site`.`active`, `Site`.`sortorder`, `Site`.`aetc_id`, `Site`.`timezone_id` FROM `cakedb`.`sites` AS `Site` WHERE `Site`.`aetc_id` = (3) | | 14 | 14 | 1 |
| 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`, `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`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `top_bar_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC | | 0 | 0 | 1 |
| 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`, `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`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `quick_links_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC | | 5 | 5 | 11 |
| 7 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (246, 247, 285, 248, 249) | | 0 | 0 | 0 |
| 8 | 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`, `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`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `national_resources_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC | | 11 | 11 | 12 |
| 9 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260) | | 0 | 0 | 0 |
| 10 | 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` FROM `cakedb`.`menu_links` AS `MenuLink` LEFT JOIN `cakedb`.`links` AS `Link` ON (`MenuLink`.`link_id` = `Link`.`id`) WHERE `MenuLink`.`aetc_id` = 3 ORDER BY `lft` ASC | | 42 | 42 | 1 |
| 11 | SELECT `Site`.`id`, `Site`.`title` FROM `cakedb`.`sites` AS `Site` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Site`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Site`.`timezone_id` = `Timezone`.`id`) WHERE `Site`.`aetc_id` = 3 | | 14 | 14 | 1 |
| 12 | SELECT `Event`.`ERDATE`, `Event`.`site_id` FROM `cakedb`.`events` AS `Event` INNER JOIN sites AS SiteUniq ON SiteUniq.id = Event.site_id WHERE `status_id` = 1 AND `ERDATE` >= '2018-09-01' AND `ERDATE` <= '2018-09-30' AND `SiteUniq`.`aetc_id` = '3' GROUP BY `Event`.`ERDATE` ORDER BY `ERDATE` asc | | 9 | 9 | 1 |
| 13 | SELECT `ContentPage`.`id`, `ContentPage`.`user_id`, `ContentPage`.`title`, `ContentPage`.`subtitle`, `ContentPage`.`body`, `ContentPage`.`slug`, `ContentPage`.`keywords`, `ContentPage`.`sidebar_flag`, `ContentPage`.`sidebar`, `ContentPage`.`content_status_id`, `ContentPage`.`published`, `ContentPage`.`created`, `ContentPage`.`updated`, `ContentPage`.`group_id`, `ContentPage`.`public`, `ContentPage`.`featured`, `ContentPage`.`content_type_id`, `ContentPage`.`news_id`, `ContentPage`.`site_id`, `ContentPage`.`aetc_id`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`credentials`, `User`.`organization`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`dob`, `User`.`uniqueidnumber`, `User`.`active`, `User`.`created`, `User`.`role`, `User`.`taap_access`, `User`.`email_list_bak`, `User`.`site`, `User`.`last_login`, `User`.`attempt_time`, `User`.`attempt_try`, `User`.`speaker`, `User`.`ftcc_id`, `User`.`pif_id`, `User`.`email_list`, `User`.`deleted`, `User`.`deleted_flag`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `Status`.`id`, `Status`.`name`, `Status`.`description`, `Content`.`id`, `Content`.`user_id`, `Content`.`content_id`, `Content`.`content_type_id`, `Content`.`site_id` FROM `cakedb`.`content_pages` AS `ContentPage` LEFT JOIN `cakedb`.`users` AS `User` ON (`ContentPage`.`user_id` = `User`.`id`) LEFT JOIN `cakedb`.`content_statuses` AS `Status` ON (`ContentPage`.`content_status_id` = `Status`.`id`) LEFT JOIN `cakedb`.`contents` AS `Content` ON (`Content`.`content_id` = `ContentPage`.`id`) WHERE NOT (`ContentPage`.`published` IS NULL) AND `ContentPage`.`content_status_id` = 2 AND `ContentPage`.`content_type_id` = 2 AND `ContentPage`.`aetc_id` = 3 ORDER BY `ContentPage`.`published` DESC LIMIT 4 | | 4 | 4 | 3 |
| 14 | SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'ContentPage' AND `Attachment`.`foreign_key` IN (157, 161, 160, 163) | | 0 | 0 | 1 |
| 15 | SELECT `ContentPagesGroup`.`id`, `ContentPagesGroup`.`content_page_id`, `ContentPagesGroup`.`group_id`, `ContentPagesGroup`.`created`, `ContentPagesGroup`.`updated` FROM `cakedb`.`content_pages_groups` AS `ContentPagesGroup` WHERE `ContentPagesGroup`.`content_page_id` IN (157, 161, 160, 163) | | 0 | 0 | 0 |
| 16 | SELECT `ContentPagesEditor`.`id`, `ContentPagesEditor`.`content_page_id`, `ContentPagesEditor`.`user_id`, `ContentPagesEditor`.`user_type_id`, `ContentPagesEditor`.`created`, `ContentPagesEditor`.`updated` FROM `cakedb`.`content_pages_users` AS `ContentPagesEditor` WHERE `ContentPagesEditor`.`user_type_id` = 3 AND `ContentPagesEditor`.`content_page_id` IN (157, 161, 160, 163) | | 0 | 0 | 0 |
| 17 | SELECT `ContentPagesUser`.`id`, `ContentPagesUser`.`content_page_id`, `ContentPagesUser`.`user_id`, `ContentPagesUser`.`user_type_id`, `ContentPagesUser`.`created`, `ContentPagesUser`.`updated` FROM `cakedb`.`content_pages_users` AS `ContentPagesUser` WHERE `ContentPagesUser`.`content_page_id` IN (157, 161, 160, 163) | | 0 | 0 | 0 |
| 18 | SELECT `ContentPagesViewer`.`id`, `ContentPagesViewer`.`content_page_id`, `ContentPagesViewer`.`user_id`, `ContentPagesViewer`.`user_type_id`, `ContentPagesViewer`.`created`, `ContentPagesViewer`.`updated` FROM `cakedb`.`content_pages_users` AS `ContentPagesViewer` WHERE `ContentPagesViewer`.`user_type_id` = 2 AND `ContentPagesViewer`.`content_page_id` IN (157, 161, 160, 163) | | 0 | 0 | 0 |
| 19 | SELECT `Group`.`id`, `Group`.`name`, `Group`.`user_id`, `Group`.`created`, `Group`.`updated`, `Group`.`created_by`, `Group`.`updated_by`, `Group`.`description`, `ContentPagesGroup`.`id`, `ContentPagesGroup`.`content_page_id`, `ContentPagesGroup`.`group_id`, `ContentPagesGroup`.`created`, `ContentPagesGroup`.`updated` FROM `cakedb`.`groups` AS `Group` JOIN `cakedb`.`content_pages_groups` AS `ContentPagesGroup` ON (`ContentPagesGroup`.`content_page_id` IN (157, 161, 160, 163) AND `ContentPagesGroup`.`group_id` = `Group`.`id`) | | 0 | 0 | 0 |
| 20 | 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`, `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`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `national_resources_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC | | 11 | 11 | 12 |
| 21 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260) | | 0 | 0 | 0 |
| 22 | 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`, `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`.`paypal_username`, `Aetc`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`clinical_consultation_eval_link`, `Aetc`.`clinical_preceptorships_eval_link`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`name`, `Attachment`.`attachment`, `Attachment`.`dir`, `Attachment`.`type`, `Attachment`.`size`, `Attachment`.`url`, `Attachment`.`visibility`, `Attachment`.`active`, `Attachment`.`category_id`, `Attachment`.`created`, `Attachment`.`aetc_id` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`aetcs` AS `Aetc` ON (`Link`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `slider_flag` = '1' AND `Link`.`aetc_id` = 3 ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC | | 3 | 3 | 4 |
| 23 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `MenuLink`.`aetc_id` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (263, 265, 279) | | 0 | 0 | 0 |
| 24 |
SELECT
events.id,
events.ERDATE AS sort_order,
'event' AS content_type,
(SELECT count(id) FROM registrations AS r1 WHERE r1.event_id = events.id) AS registration_count,
events.password,
events.ERNAME AS 'title',
events.description,
events.max_registrants,
events.AETC,
events.fee,
events.type,
registrations.id AS is_registered,
sites.title AS site_name
FROM events
LEFT JOIN registrations ON registrations.event_id = events.id AND registrations.user_id = 0
LEFT JOIN sites ON sites.id = events.site_id
LEFT JOIN aetcs ON aetcs.id = sites.aetc_id
WHERE
events.registration_close_date >= NOW() AND
events.ERDATE >= NOW() AND
events.featured = 1 AND
events.status_id = 1 AND
aetcs.id = 3
Union All
SELECT
content_pages.id,
content_pages.published as sort_order,
'news' AS content_type,
null,
null,
content_pages.title,
content_pages.body as description,
null,
null,
null,
null,
null,
null
FROM content_pages
LEFT JOIN aetcs ON aetcs.id = content_pages.aetc_id
WHERE
content_pages.content_type_id = 2 AND
content_pages.published is not null AND
content_pages.featured = 1 AND
content_pages.public = 1 AND
aetcs.id = 3
ORDER BY sort_order
LIMIT 4; | | 4 | 4 | 2 |
