New user? Sign up here |

Browse Events RSS Feed

Search by Keywords


Page 1 of 1, showing 0 records out of 0 total, starting on record 0, ending on 0

< previousnext >
 

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

(production) 17 queries took 72 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)000
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` ASC111111
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 `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` = 2 ORDER BY `lft` ASC51511
12SELECT `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
13SELECT `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`.`ERDATE` BETWEEN '2018-09-07 00:00:00' AND '2018-09-07 23:59:59' AND `SiteUniq`.`aetc_id` = '2' ORDER BY `Event`.`ERDATE` asc LIMIT 50027
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` = 213131
15SELECT `CreditType`.`id`, `CreditType`.`title` FROM `cakedb`.`credit_types` AS `CreditType` WHERE `CreditType`.`aetc_id` = 210100
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;6660666014