New user? Sign up here |

Overview

The MidAtlantic AIDS Education and Training Center (MA AETC) provides HIV/AIDS education, consultation, technical assistance and resource materials to health care professionals throughout Pennsylvania, Maryland, Virginia, West Virginia, Delaware and the District of Columbia.

Quick Links

National Resources

Regional Training Events

World AIDS Day 2018
National HIV Curriculum is Live!
Help the PEPline!
Rear Adm. Dr. Sylvia Trent-Adams (left) and MAAETC Principal Investigator and Executive Director Dr. Linda Frank (right)
2018 International AIDS Conference (Amsterdam)
Dr. Linda Frank (Executive Director, MAAETC) and Harold Phillips (Dir., HRSA , HIV/AIDS Training and Capacity Development)
Dr. Linda Frank, Executive Director, MAAETC (IAC, 2018)

Features

Integrating Infectious Disease Prevention and Treatment into the Opioid Response

By: Corinna Dan, R.N., M.P.H., Viral Hepatitis Policy Advisor, Office of HIV/AIDS and Infectious Disease Policy, U.S. Department of Health and Huma...

HIV/AIDS - Approved Use for Medical Marijuana in Pennsylvania

According to the Commonwealth of Pennsylvania, studies have shown that medical marijuana can assist patients suffering from certain serious medical c...

Advanced HIV Care Conference

Click Here for Registration Information An Advanced Focus on the Management of Patients Infected with the Human Immunodeficiency Vi...

World AIDS Day 2018

Registration for attendees Register (standard) Registration for submission of abstracts          &...

Training Events

September 2018
Su
Mo
Tu
We
Th
Fr
Sa
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
Loading...
Training Calendar

RSS News Feeds

Announcements

AIDSinfo

  • Loading...

CDC PIN News

  • Loading...

KFF HIV/AIDS News

  • Loading...
 

This is a DEBUG feature. This will not Transfer to production

(production) 24 queries took 90 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 = 1331
2SELECT `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)27271
3SELECT `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` = 2 LIMIT 1111
4SELECT `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` = (2)13131
5SELECT `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` = 2 ORDER BY `Link`.`sort` ASC338
6SELECT `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 (219, 220, 221)001
7SELECT `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` = 2 ORDER BY `Link`.`sort` ASC445
8SELECT `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 (145, 147, 148, 181)000
9SELECT `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` = 2 ORDER BY `Link`.`sort` ASC111112
10SELECT `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 (211, 217, 159, 157, 205, 160, 161, 162, 191, 155, 156)000
11SELECT `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` = 213131
12SELECT `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` = '2' GROUP BY `Event`.`ERDATE` ORDER BY `ERDATE` asc424215
13SELECT `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` = 2 ORDER BY `ContentPage`.`published` DESC LIMIT 4444
14SELECT `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 (113, 152, 112, 115)001
15SELECT `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 (113, 152, 112, 115)000
16SELECT `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 (113, 152, 112, 115)220
17SELECT `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 (113, 152, 112, 115)220
18SELECT `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 (113, 152, 112, 115)000
19SELECT `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 (113, 152, 112, 115) AND `ContentPagesGroup`.`group_id` = `Group`.`id`) 000
20SELECT `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` = 2 ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC111115
21SELECT `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 (211, 217, 159, 157, 205, 160, 161, 162, 191, 155, 156)000
22SELECT `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` = 2 ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC667
23SELECT `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 (282, 212, 207, 209, 283, 284)000
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 = 2 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 = 2 ORDER BY sort_order LIMIT 4;4417