New user? Sign up here |

  • Filter By Credit

Browse Events RSS Feed

Search by Keywords


Annual HIV Primary Care Conference 2018 Recording

Description
Recording of the 2018 Annual HIV Primary Care Conference, May 11, 2018, Nashua, NH.
Agenda
Ten Things PCPs Should Know About HIV Prevention and Care Philip Bolduc, MD Hep B & C Prevention and Care Update Alysse Wurcel, MD Providing Culturally Competent Care of ...

Starts at: May 11, 2018 7:00am ET

Ends at: May 11, 2018 12:31pm ET

Sponsored by UMass Medical School

Fee: None

View Details Register

CROI Update 2018 Recording

Description
Recordings of Dr. Kenneth Mayer, Dr. Virginia Triant, and Dr. Rajesh Gandhi providing updates from the 2018 25th Conference on Retroviruses and Opportunistic Infections (CROI). 

Starts at: March 21, 2018 6:00pm ET

Ends at: March 21, 2018 8:30pm ET

Sponsored by Massachusetts

Fee: None

View Details Register

HIV Interprofessional Update 2018 Recording

Description
This live recording of NEAETC/BU Graduate School of Dental Medicine event for oral health and medical professionals includes presentations on Pre-Exposure Prophylaxis (PrEP) with Kevin Ard, MD, MPH; Oral Manifestations of HIV Disease with Herve Sroussi, DMD, PhD; and ...

Starts at: March 14, 2018 5:30pm ET

Ends at: March 14, 2018 8:30pm ET

Sponsored by Massachusetts

Fee: None

View Details Register

Pre-Exposure Prophylaxis (PrEP) for HIV in Clinical Practice Recording

Description
In this webinar, Dr. Kevin Ard reviews how to prescribe and monitor PrEP. Using patient cases, he discusses unique considerations that apply to PrEP management for transgender people, serodifferent couples, those who are pregnant or trying to conceive, and adolescents. ...

Starts at: November 22, 2017 12:00pm ET

Ends at: November 22, 2017 1:00pm ET

Sponsored by Fenway Health

Fee: None

View Details Register

Annual HIV Primary Care Conference 2017 Recording

Description
Recording of the 2017 Annual HIV Primare Care Conference held on Friday, April 28th, 2017 at the Provincetown Inn, MA.
Agenda
What Every Primary Care Provider Needs to Know About HIV and HepatitisArthur Kim, MDDirector of the Viral Hepatitis ClinicDivision of Infectious ...

Starts at: April 28, 2017 8:00am ET

Ends at: April 28, 2017 4:00pm ET

Sponsored by Massachusetts

Fee: None

View Details Register

Page 1 of 2, showing 5 records out of 6 total, starting on record 1, ending on 5

< previous12
 

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

(production) 17 queries took 42 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` = 3 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` = (3)14141
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` = 3 ORDER BY `Link`.`sort` ASC001
6SELECT `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` ASC556
7SELECT `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)000
8SELECT `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` ASC111110
9SELECT `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)001
10SELECT `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` ASC42421
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` = 314141
12SELECT `Event`.`id`, `Event`.`ERDATE`, `Event`.`end_date`, `Event`.`ERNAME`, `Event`.`LOCZIP`, `Event`.`ER9_1_bak`, `Event`.`ER9_2_bak`, `Event`.`ER9_3_bak`, `Event`.`ER9_4a_bak`, `Event`.`ER9_4b_bak`, `Event`.`ER9_5_bak`, `Event`.`AETC`, `Event`.`PROG_ID`, `Event`.`max_registrants`, `Event`.`is_password_protected`, `Event`.`password`, `Event`.`webinar_link`, `Event`.`confirmation_email`, `Event`.`extra_questions`, `Event`.`fee`, `Event`.`active`, `Event`.`status`, `Event`.`address`, `Event`.`description`, `Event`.`meta_data`, `Event`.`acre_redirect`, `Event`.`webex_link`, `Event`.`webex_password`, `Event`.`archived_web_posts`, `Event`.`webex_test_link`, `Event`.`edited`, `Event`.`type`, `Event`.`site_id`, `Event`.`user_id`, `Event`.`featured`, `Event`.`registration_close_date`, `Event`.`archived`, `Event`.`evaluation_btn_flag`, `Event`.`post_reg_redirect_link`, `Event`.`group_id`, `Event`.`location_name`, `Event`.`status_id`, `Event`.`event_type`, `Event`.`ER7_01`, `Event`.`ER7_02`, `Event`.`ER7_03`, `Event`.`ER7_04`, `Event`.`ER7_05`, `Event`.`ER7_06`, `Event`.`ER7_07`, `Event`.`ER8_01`, `Event`.`ER8_02`, `Event`.`ER8_03`, `Event`.`ER8_04`, `Event`.`ER8_05`, `Event`.`ER8_06`, `Event`.`ER8_07`, `Event`.`ER8_08`, `Event`.`ER8_09`, `Event`.`ER8_10`, `Event`.`ER8_11`, `Event`.`ER8_12`, `Event`.`ER8_13`, `Event`.`ER9_01`, `Event`.`ER9_02`, `Event`.`ER9_03`, `Event`.`ER9_04`, `Event`.`ER9_05`, `Event`.`ER9_06`, `Event`.`ER9_07`, `Event`.`ER9_08`, `Event`.`ER9_09`, `Event`.`ER9_10`, `Event`.`ER9_11`, `Event`.`ER9_12`, `Event`.`ER9_13`, `Event`.`ER9_14`, `Event`.`ER9_15`, `Event`.`ER9_16`, `Event`.`ER9_17`, `Event`.`ER9_18`, `Event`.`ER9_19`, `Event`.`ER9_20`, `Event`.`ER9_21`, `Event`.`ER10_01`, `Event`.`ER10_02`, `Event`.`ER10_03`, `Event`.`ER10_04`, `Event`.`ER10_05`, `Event`.`ER11_01`, `Event`.`ER11_02`, `Event`.`ER11_03`, `Event`.`ER11_04`, `Event`.`ER12_01`, `Event`.`ER12_02`, `Event`.`ER12_03`, `Event`.`ER12_04`, `Event`.`ER12_05`, `Event`.`ER12_06`, `Event`.`ER12_07`, `Event`.`ER12_08`, `Event`.`ER12_09`, `Event`.`ER12_10`, `Event`.`ER12_11`, `Event`.`ER12_12`, `Event`.`ER12_13`, `Event`.`ER12_14`, `Event`.`ER12_15`, `Event`.`ER12_16`, `Event`.`ER13_01`, `Event`.`ER13_02`, `Event`.`ER13_03`, `Event`.`ER13_04`, `Event`.`ER13_05`, `Event`.`ER13_06`, `Event`.`ER13_07`, `Event`.`ER13_08`, `Event`.`ER13_09`, `Event`.`ER13_10`, `Event`.`ER13_10_other`, `Event`.`ER13_11`, `Event`.`ER13_12`, `Event`.`ER13_13`, `Event`.`ER13_14`, `Event`.`ER13_15`, `Event`.`ER13_16`, `Event`.`ER13_17`, `Event`.`ER13_18`, `Event`.`ER13_18_other`, `Event`.`ER14_01`, `Event`.`ER14_02`, `Event`.`ER14_03`, `Event`.`ER14_04`, `Event`.`ER14_05`, `Event`.`ER14_06`, `Event`.`ER14_07`, `Event`.`ER14_08`, `Event`.`ER14_09`, `Event`.`ER14_10`, `Event`.`ER14_11`, `Event`.`ER14_12`, `Event`.`ER14_12_other`, `Event`.`ER14_13`, `Event`.`ER14_14`, `Event`.`ER14_15`, `Event`.`ER14_16`, `Event`.`ER14_17`, `Event`.`ER15_01`, `Event`.`ER15_02`, `Event`.`ER15_03`, `Event`.`ER15_04`, `Event`.`ER15_05`, `Event`.`ER15_06`, `Event`.`ER15_07`, `Event`.`ER15_08`, `Event`.`ER16_01`, `Event`.`ER16_02`, `Event`.`ER16_03`, `Event`.`ER16_04`, `Event`.`ER16_05`, `Event`.`ER16_06`, `Event`.`ER16_07`, `Event`.`ER16_08`, `Event`.`ER16_09`, `Event`.`ER16_10`, `Event`.`ER16_11`, `Event`.`ER16_12`, `Event`.`ER16_13`, `Event`.`ER16_13_other`, `Event`.`ER17_01`, `Event`.`ER17_02`, `Event`.`ER17_03`, `Event`.`ER17_04`, `Event`.`ER17_05`, `Event`.`ER17_06`, `Event`.`ER17_07`, `Event`.`ER17_08`, `Event`.`ER17_09`, `Event`.`ER17_10`, `Event`.`ER17_11`, `Event`.`ER17_12`, `Event`.`ER17_13`, `Event`.`ER17_14`, `Event`.`ER18`, `Event`.`ER19_01`, `Event`.`ER19_02`, `Event`.`ER19_03`, `Event`.`ER19_04`, `Event`.`ER19_05`, `Event`.`ER20`, `Event`.`ER21`, `Event`.`ER22`, `Event`.`priority1`, `Event`.`priority2`, `Event`.`priority3`, `Event`.`timezone_id`, `Event`.`post_eval_form_id`, `Event`.`post_eval_notification_flag`, `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`, `Timezone`.`id`, `Timezone`.`name`, `Timezone`.`abbreviation` FROM `cakedb`.`events` AS `Event` LEFT JOIN `cakedb`.`sites` AS `Site` ON (`Event`.`site_id` = `Site`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Event`.`timezone_id` = `Timezone`.`id`) INNER JOIN sites AS SiteUniq ON SiteUniq.id = Event.site_id WHERE `Event`.`status_id` = 1 AND `Event`.`archived` = '1' AND `SiteUniq`.`aetc_id` = '3' ORDER BY `Event`.`ERDATE` desc LIMIT 5553
13SELECT COUNT(*) AS `count` FROM `cakedb`.`events` AS `Event` LEFT JOIN `cakedb`.`sites` AS `Site` ON (`Event`.`site_id` = `Site`.`id`) LEFT JOIN `cakedb`.`timezones` AS `Timezone` ON (`Event`.`timezone_id` = `Timezone`.`id`) INNER JOIN sites AS SiteUniq ON SiteUniq.id = Event.site_id WHERE `Event`.`status_id` = 1 AND `Event`.`archived` = '1' AND `SiteUniq`.`aetc_id` = '3'111
14SELECT `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`, `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`, `Timezone`.`id`, `Timezone`.`name`, `Timezone`.`abbreviation` 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` = 314141
15SELECT `CreditType`.`id`, `CreditType`.`title` FROM `cakedb`.`credit_types` AS `CreditType` WHERE `CreditType`.`aetc_id` = 3990
16SELECT `Registration`.`id`, `Registration`.`event_id`, `Registration`.`user_id`, `Registration`.`remind`, `Registration`.`created`, `Registration`.`thank_you`, `Registration`.`forms_submission_id`, `Registration`.`immed_eval_email_cnt`, `Registration`.`immed_eval_email_send_date` FROM `cakedb`.`registrations` AS `Registration` WHERE `Registration`.`user_id` IS NULL000
17SELECT COUNT(1) as Registration__count, event_id FROM registrations AS Registration GROUP BY event_id;6664666413