Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_events): failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_events) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_model_ cache was unable to write 'production_cakedb_2022_events' to File cache [CORE/Cake/Cache/Cache.php, line 327]
Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_events) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_events) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_model_ cache was unable to write 'production_cakedb_2022_events' to File cache [CORE/Cake/Cache/Cache.php, line 327]
Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_registrations) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_registrations) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_model_ cache was unable to write 'production_cakedb_2022_registrations' to File cache [CORE/Cake/Cache/Cache.php, line 327]
Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_registrations) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): SplFileInfo::openFile(/var/www/production/develop-10.3/tmp/cache/PAMAAETC_cake_model_production_cakedb_2022_registrations) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_model_ cache was unable to write 'production_cakedb_2022_registrations' to File cache [CORE/Cake/Cache/Cache.php, line 327]
test aetc: Events
New user? Sign up here |
Loading...

Training and Conferences

Upcoming Training Programs And In Person Events

View All

Online On Demand Training

View All

Filter By Site

On Demand Training (Archive)

Results

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) 13 queries took 84 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Aetc`.`id`, `Aetc`.`name_short`, `Aetc`.`url`, `Aetc`.`code` FROM `cakedb_2022`.`aetcs` AS `Aetc` WHERE 1 = 1441
2SELECT `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`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Aetc`.`public_flag`, `Aetc`.`associated_states`, `Aetc`.`ga_account`, `Aetc`.`footer_grant`, `Aetc`.`google_tag_manager`, `Aetc`.`grant_number`, `Aetc`.`institution`, `Aetc`.`certificate_text`, `Aetc`.`color_4`, `Aetc`.`color_5`, `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_2022`.`aetcs` AS `Aetc` LEFT JOIN `cakedb_2022`.`attachments` AS `HeaderImage` ON (`Aetc`.`header_image` = `HeaderImage`.`id`) LEFT JOIN `cakedb_2022`.`attachments` AS `HomepageMapImage` ON (`Aetc`.`homepage_map_image` = `HomepageMapImage`.`id`) LEFT JOIN `cakedb_2022`.`attachments` AS `RibbonImage` ON (`Aetc`.`ribbon_image` = `RibbonImage`.`id`) LEFT JOIN `cakedb_2022`.`timezones` AS `Timezone` ON (`Aetc`.`timezone_id` = `Timezone`.`id`) WHERE `Aetc`.`id` = 4 LIMIT 1111
3SELECT `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`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `top_bar_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC001
4SELECT `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`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `quick_links_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC001
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`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `national_resources_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC000
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`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`links` AS `Link` WHERE `regional_resources_flag` = '1' AND `Link`.`aetc_id` = 4 ORDER BY `Link`.`sort` ASC000
7SELECT `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`, `Link`.`regional_resources_flag` FROM `cakedb_2022`.`menu_links` AS `MenuLink` LEFT JOIN `cakedb_2022`.`links` AS `Link` ON (`MenuLink`.`link_id` = `Link`.`id`) WHERE `MenuLink`.`aetc_id` = 4 ORDER BY `lft` ASC001
8SELECT `Site`.`id`, `Site`.`title` FROM `cakedb_2022`.`sites` AS `Site` WHERE `Site`.`aetc_id` = 4000
9SELECT `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_bak`, `Event`.`active`, `Event`.`status`, `Event`.`address`, `Event`.`description`, `Event`.`description_audience`, `Event`.`description_contact`, `Event`.`description_contact_email`, `Event`.`event_accreditation`, `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`.`status_id_previous`, `Event`.`status_id_last_changed`, `Event`.`event_type`, `Event`.`event_tech_hosting_needed`, `Event`.`event_tech_hosting_zoom`, `Event`.`ER5`, `Event`.`ER5_01`, `Event`.`ER5_02`, `Event`.`ER5_03`, `Event`.`ER5_04`, `Event`.`ER5_05`, `Event`.`ER5_specify`, `Event`.`ER5_pillar_primary`, `Event`.`ER5_pillar_diagnose`, `Event`.`ER5_pillar_treat`, `Event`.`ER5_pillar_prevent`, `Event`.`ER5_pillar_respond`, `Event`.`ER4`, `Event`.`ER6_01`, `Event`.`ER6_02`, `Event`.`ER6_03`, `Event`.`ER6_04`, `Event`.`ER6_07`, `Event`.`ER6_08`, `Event`.`ER6_09`, `Event`.`ER9`, `Event`.`ER10`, `Event`.`ER11`, `Event`.`ER15_07`, `Event`.`ER15_08`, `Event`.`ER15_06`, `Event`.`ER15_05`, `Event`.`ER15_04`, `Event`.`ER15_03`, `Event`.`ER15_02`, `Event`.`ER15_01`, `Event`.`ER15_07_other`, `Event`.`ER6_05`, `Event`.`ER6_06`, `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`.`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_specify`, `Event`.`ER17_14`, `Event`.`ER18_01`, `Event`.`ER18_02`, `Event`.`ER18_03`, `Event`.`ER18_04`, `Event`.`ER18_05`, `Event`.`ER18_06`, `Event`.`ER18_07`, `Event`.`ER18_08`, `Event`.`ER18_09`, `Event`.`ER18_10`, `Event`.`ER18_11`, `Event`.`ER18_12`, `Event`.`ER18_13`, `Event`.`ER18_14`, `Event`.`ER18_15`, `Event`.`ER18_16`, `Event`.`ER18_17`, `Event`.`ER18_18`, `Event`.`ER18_19`, `Event`.`ER18_21`, `Event`.`ER18_22`, `Event`.`ER18_23_specify`, `Event`.`ER18_23`, `Event`.`ER18_24`, `Event`.`ER18_25`, `Event`.`ER18_20`, `Event`.`ER19_01`, `Event`.`ER19_02`, `Event`.`ER19_03`, `Event`.`ER19_04`, `Event`.`ER19_05`, `Event`.`ER19_06`, `Event`.`ER19_07`, `Event`.`ER19_07_specify`, `Event`.`ER20_01`, `Event`.`ER20_02`, `Event`.`ER20_03`, `Event`.`ER20_04`, `Event`.`ER20_05`, `Event`.`ER20_06`, `Event`.`ER20_07`, `Event`.`ER20_08`, `Event`.`ER20_09`, `Event`.`ER20_10`, `Event`.`ER20_11`, `Event`.`ER20_12`, `Event`.`ER20_13`, `Event`.`ER20_14`, `Event`.`ER20_15`, `Event`.`ER20_16`, `Event`.`ER20_16_specify`, `Event`.`ER20_17`, `Event`.`ER20_18`, `Event`.`ER20_19`, `Event`.`ER20_20`, `Event`.`ER20_21`, `Event`.`ER20_21_specify`, `Event`.`ER21_01`, `Event`.`ER21_02`, `Event`.`ER21_03`, `Event`.`ER21_04`, `Event`.`ER21_05`, `Event`.`ER21_06`, `Event`.`ER21_07`, `Event`.`ER21_08`, `Event`.`ER21_09`, `Event`.`ER21_10`, `Event`.`ER21_10_other`, `Event`.`ER21_11`, `Event`.`ER21_12`, `Event`.`ER21_13`, `Event`.`ER21_14`, `Event`.`ER21_15`, `Event`.`ER21_16`, `Event`.`ER21_17`, `Event`.`ER21_18`, `Event`.`ER21_19`, `Event`.`ER21_20`, `Event`.`ER21_21`, `Event`.`ER21_18_other`, `Event`.`ER22_01`, `Event`.`ER22_02`, `Event`.`ER22_03`, `Event`.`ER22_04`, `Event`.`ER22_05`, `Event`.`ER22_06`, `Event`.`ER22_07`, `Event`.`ER22_08`, `Event`.`ER22_09`, `Event`.`ER22_10`, `Event`.`ER22_11`, `Event`.`ER22_12`, `Event`.`ER22_13`, `Event`.`ER22_bak`, `Event`.`ER23_01`, `Event`.`ER23_02`, `Event`.`ER23_03`, `Event`.`ER23_04`, `Event`.`ER23_05`, `Event`.`ER23_06`, `Event`.`ER23_07`, `Event`.`ER23_08`, `Event`.`ER23_09`, `Event`.`ER23_10`, `Event`.`ER24_01`, `Event`.`ER24_02`, `Event`.`ER24_03`, `Event`.`ER24_04`, `Event`.`ER24_05`, `Event`.`ER24_06`, `Event`.`ER24_07`, `Event`.`ER24_08`, `Event`.`ER24_09`, `Event`.`ER24_10`, `Event`.`ER24_11`, `Event`.`ER24_12`, `Event`.`ER24_13`, `Event`.`ER24_14`, `Event`.`ER24_15`, `Event`.`ER24_16`, `Event`.`ER24_17`, `Event`.`ER24_18`, `Event`.`ER24_13_specify`, `Event`.`ER25_01`, `Event`.`ER25_02`, `Event`.`ER25_03`, `Event`.`ER25_04`, `Event`.`ER25_05`, `Event`.`ER25_06`, `Event`.`ER25_07`, `Event`.`ER25_08`, `Event`.`ER25_09`, `Event`.`ER25_10`, `Event`.`ER25_11`, `Event`.`ER25_12`, `Event`.`ER25_13`, `Event`.`ER25_14`, `Event`.`ER25_15`, `Event`.`ER25_16`, `Event`.`ER25_13_num_coaching_sessions`, `Event`.`ER25_13_coaching_end_date`, `Event`.`ER25_13_coaching_start_date`, `Event`.`ER25_12_num_coaching_sessions`, `Event`.`ER25_12_coaching_end_date`, `Event`.`ER25_12_coaching_start_date`, `Event`.`ER26`, `Event`.`ER28`, `Event`.`ER29`, `Event`.`priority1`, `Event`.`priority2`, `Event`.`priority3`, `Event`.`timezone_id`, `Event`.`post_eval_form_id`, `Event`.`post_eval_notification_flag`, `Event`.`follow_up_form_id`, `Event`.`loc_state`, `Event`.`paypal_content`, `Event`.`fee`, `Event`.`pre_reg_redirect_link`, `Event`.`post_eval_notification_delay`, `Event`.`ER30`, `Event`.`disable_event_reminder`, `Event`.`disable_follow_eval`, `Event`.`disable_immediate_eval`, `Event`.`ER31`, `Event`.`ER32`, `Event`.`ER32_Other`, `Event`.`evaluation_external`, `Event`.`event_postponed`, `Event`.`post_eval_submit_redirect`, `Event`.`disable_certificate`, `Event`.`TAR12`, `Event`.`TAR13_01`, `Event`.`TAR13_02`, `Event`.`TAR13_03`, `Event`.`TAR13_04`, `Event`.`TAR13_05`, `Event`.`TAR13_06`, `Event`.`TAR13_07`, `Event`.`TAR13_08`, `Event`.`TAR13_07_Specify`, `Event`.`TAR14`, `Event`.`TAR17_01`, `Event`.`TAR17_02`, `Event`.`TAR18_09`, `Event`.`TAR18_09_Specify`, `Event`.`TAR19_06`, `Event`.`TAR20_01`, `Event`.`TAR20_02`, `Event`.`TAR20_04`, `Event`.`TAR20_18`, `Event`.`TAR22_01`, `Event`.`TAR22_12`, `Event`.`TAR23_08`, `Event`.`TAR23_10`, `Event`.`TAR24_12`, `Event`.`TAR25_04`, `Event`.`TAR25_09`, `Event`.`TAR25_10`, `Event`.`TAR25_09_Specify`, `Event`.`TAR26_03`, `Event`.`TAR26_04`, `Event`.`TAR26_11`, `Event`.`TAR26_14`, `Event`.`TAR26_18`, `Event`.`TAR27`, `Event`.`TAR28_01`, `Event`.`TAR28_02`, `Event`.`TAR28_03`, `Event`.`TAR28_04`, `Event`.`TAR28_05`, `Event`.`TAR28_06`, `Event`.`TAR28_07`, `Event`.`TAR29`, `Event`.`TAR30`, `Event`.`TAR31`, `Event`.`TAR32`, `Event`.`event_cancelled`, `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`, `Site`.`is_hq`, `Site`.`is_parent`, `Site`.`parent_site_id`, `Site`.`logo_url`, `Site`.`coverage_area_url`, `Site`.`coverage_area_text`, `Site`.`counties_served`, `Timezone`.`id`, `Timezone`.`name`, `Timezone`.`abbreviation` FROM `cakedb_2022`.`events` AS `Event` LEFT JOIN `cakedb_2022`.`sites` AS `Site` ON (`Event`.`site_id` = `Site`.`id`) LEFT JOIN `cakedb_2022`.`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 `Site`.`active` = 1 AND `Event`.`registration_close_date` > '2026-06-29 08:56:35' AND `SiteUniq`.`aetc_id` = '4' ORDER BY `Event`.`end_date` DESC LIMIT 5002
10SELECT `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`, `Site`.`is_hq`, `Site`.`is_parent`, `Site`.`parent_site_id`, `Site`.`logo_url`, `Site`.`coverage_area_url`, `Site`.`coverage_area_text`, `Site`.`counties_served`, `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`.`homepage_map_image`, `Aetc`.`homepage_overview`, `Aetc`.`twitter_text`, `Aetc`.`email_subject`, `Aetc`.`email_body`, `Aetc`.`system_email`, `Aetc`.`system_phone`, `Aetc`.`footer_text`, `Aetc`.`evaluation_text`, `Aetc`.`public_flag`, `Aetc`.`associated_states`, `Aetc`.`ga_account`, `Aetc`.`footer_grant`, `Aetc`.`google_tag_manager`, `Aetc`.`grant_number`, `Aetc`.`institution`, `Aetc`.`certificate_text`, `Aetc`.`color_4`, `Aetc`.`color_5`, `Timezone`.`id`, `Timezone`.`name`, `Timezone`.`abbreviation` FROM `cakedb_2022`.`sites` AS `Site` LEFT JOIN `cakedb_2022`.`aetcs` AS `Aetc` ON (`Site`.`aetc_id` = `Aetc`.`id`) LEFT JOIN `cakedb_2022`.`timezones` AS `Timezone` ON (`Site`.`timezone_id` = `Timezone`.`id`) WHERE `active` = 1 AND `Site`.`aetc_id` = 4001
11SELECT `CreditType`.`id`, `CreditType`.`title` FROM `cakedb_2022`.`credit_types` AS `CreditType` WHERE `CreditType`.`aetc_id` = 4002
12SELECT `Registration`.`id`, `Registration`.`event_id`, `Registration`.`user_id`, `Registration`.`remind`, `Registration`.`created`, `Registration`.`thank_you`, `Registration`.`forms_submission_id`, `Registration`.`immed_eval_email_send_date`, `Registration`.`immed_eval_email_cnt`, `Registration`.`follow_up_forms_submission_id`, `Registration`.`follow_up_eval_email_cnt`, `Registration`.`follow_up_eval_email_send_date`, `Registration`.`certificate_url`, `Registration`.`aetc`, `Registration`.`remind_1_hour` FROM `cakedb_2022`.`registrations` AS `Registration` WHERE `Registration`.`user_id` IS NULL000
13SELECT COUNT(1) as Registration__count, event_id FROM registrations AS Registration GROUP BY event_id;226462264674