New user? Sign up here |

ARCHIVE WEBINAR: HIV and Aging: Law and Estate Planning

Details

Starts at: September 13, 2017 12:00pm
Ends at: September 13, 2017 1:00pm
Free Admission
 
(production) 9 queries took 13 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 COUNT(*) AS `count` FROM `cakedb`.`events` AS `Event` WHERE `Event`.`id` = 9917110
4SELECT COUNT(*) AS `count` FROM `cakedb`.`registrations` AS `Registration` LEFT JOIN `cakedb`.`events` AS `Event` ON (`Registration`.`event_id` = `Event`.`id`) LEFT JOIN `cakedb`.`users` AS `User` ON (`Registration`.`user_id` = `User`.`id`) LEFT JOIN `cakedb`.`ftcc_pifs` AS `FtccPif` ON (`FtccPif`.`registration_id` = `Registration`.`id`) LEFT JOIN `cakedb`.`pifs` AS `Pif` ON (`Pif`.`registration_id` = `Registration`.`id`) LEFT JOIN `cakedb`.`transactions` AS `Transaction` ON (`Transaction`.`registration_id` = `Registration`.`id`) WHERE `Registration`.`event_id` = 9917 AND `Registration`.`user_id` IS NULL110
5SELECT `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` FROM `cakedb`.`events` AS `Event` WHERE `Event`.`id` = 9917 LIMIT 1112
6SELECT `Presentation`.`id`, `Presentation`.`title`, `Presentation`.`description`, `Presentation`.`objectives`, `Presentation`.`speakers`, `Presentation`.`start`, `Presentation`.`end`, `Presentation`.`active`, `Presentation`.`evaluation_redirect`, `Presentation`.`event_id`, `Presentation`.`user_id` FROM `cakedb`.`presentations` AS `Presentation` WHERE `Presentation`.`event_id` = (9917)000
7SELECT `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` = 'Event' AND `Attachment`.`foreign_key` = (9917)441
8SELECT `Registration`.`id`, `Registration`.`event_id`, `Registration`.`user_id`, `Registration`.`remind`, `Registration`.`created`, `Registration`.`thank_you` FROM `cakedb`.`registrations` AS `Registration` WHERE `Registration`.`user_id` IS NULL000
9SELECT COUNT(1) as Registration__count, event_id FROM registrations AS Registration GROUP BY event_id;554055409