New user? Sign up here |

Overview

The Mid Atlantic 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.

Regional Training Events

Training Events

July 2017
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
31
1
2
3
4
5
Loading...
 
(production) 17 queries took 26 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght`, `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` FROM `cakedb`.`menu_links` AS `MenuLink` LEFT JOIN `cakedb`.`links` AS `Link` ON (`MenuLink`.`link_id` = `Link`.`id`) WHERE 1 = 1 ORDER BY `lft` ASC49491
2SELECT `Site`.`id`, `Site`.`title` FROM `cakedb`.`sites` AS `Site` WHERE 1 = 112120
3SELECT `Event`.`ERDATE`, `Event`.`site_id` FROM `cakedb`.`events` AS `Event` WHERE `status` = '1' AND `ERDATE` >= '2017-07-01' AND `ERDATE` <= '2017-07-31' GROUP BY `Event`.`ERDATE` ORDER BY `ERDATE` asc004
4SELECT `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`, `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`, `User`.`site`, `User`.`last_login`, `User`.`attempt_time`, `User`.`attempt_try`, `User`.`speaker`, `User`.`ftcc_id`, `User`.`pif_id`, `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 ORDER BY `ContentPage`.`published` DESC LIMIT 4442
5SELECT `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` FROM `cakedb`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'ContentPage' AND `Attachment`.`foreign_key` IN (102, 101, 104, 97)001
6SELECT `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 (102, 101, 104, 97)000
7SELECT `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 (102, 101, 104, 97)220
8SELECT `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 (102, 101, 104, 97)220
9SELECT `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 (102, 101, 104, 97)000
10SELECT `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 (102, 101, 104, 97) AND `ContentPagesGroup`.`group_id` = `Group`.`id`) 000
11SELECT `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`, `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` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `national_resources_flag` = '1' ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC995
12SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (155, 156, 157, 159, 205, 160, 161, 162, 191)000
13SELECT `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`, `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` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `quick_links_flag` = '1' ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC443
14SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (145, 147, 148, 181)000
15SELECT `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`, `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` FROM `cakedb`.`links` AS `Link` LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `slider_flag` = '1' ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC332
16SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (206, 207, 209)000
17 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 WHERE events.registration_close_date >= NOW() AND events.ERDATE >= NOW() AND events.featured = 1 AND events.status_id = 1 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 WHERE content_pages.content_type_id = 2 AND content_pages.published is not null AND content_pages.featured = 1 AND content_pages.public = 1 ORDER BY sort_order LIMIT 4;338