New user? Sign up here |

ACRN/AACRN Review

Details

SMC Campus Center, 621 W. Lombard Street, Baltimore, MD 21201
Starts at: October 2, 2014 12:30am
Ends at: October 4, 2014 5:00pm
Fee: See Description
 
(production) 8 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Site`.`id`, `Site`.`title` FROM `cakedb`.`sites` AS `Site` WHERE 1 = 112121
2SELECT COUNT(*) AS `count` FROM `cakedb`.`events` AS `Event` WHERE `Event`.`id` = 740110
3SELECT 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` = 740 AND `Registration`.`user_id` IS NULL110
4SELECT `Event`.`id`, `Event`.`ERDATE`, `Event`.`end_date`, `Event`.`ERNAME`, `Event`.`LOCZIP`, `Event`.`ER4_1`, `Event`.`ER4_2`, `Event`.`ER4_3`, `Event`.`ER4_4`, `Event`.`ER4_5`, `Event`.`ER4_6`, `Event`.`ER4_7`, `Event`.`ER4_8`, `Event`.`ER4_9`, `Event`.`ER4_10`, `Event`.`ER4_11`, `Event`.`ER4_12`, `Event`.`ER4_13`, `Event`.`ER4_14`, `Event`.`ER4_15`, `Event`.`ER4_16`, `Event`.`ER4_17`, `Event`.`ER4_18`, `Event`.`ER4_19`, `Event`.`ER4_20`, `Event`.`ER4_21`, `Event`.`ER4_22`, `Event`.`ER4_23`, `Event`.`ER4_24`, `Event`.`ER4_25`, `Event`.`ER4_26`, `Event`.`ER4_27`, `Event`.`ER4_28`, `Event`.`ER4_29`, `Event`.`ER4_30`, `Event`.`ER4_31`, `Event`.`ER4_32`, `Event`.`ER4_33`, `Event`.`ER4_34`, `Event`.`ER4_35`, `Event`.`ER4_36`, `Event`.`ER4_37`, `Event`.`ER4_38`, `Event`.`ER4_39`, `Event`.`ER4_40`, `Event`.`ER4_41`, `Event`.`ER4_42`, `Event`.`ER4_43`, `Event`.`ER4_44`, `Event`.`ER5_0`, `Event`.`ER5_1`, `Event`.`ER5_2`, `Event`.`ER5_3`, `Event`.`ER6_0`, `Event`.`ER6_1`, `Event`.`ER6_2`, `Event`.`ER6_3`, `Event`.`ER6_4`, `Event`.`ER6_5`, `Event`.`ER6_6`, `Event`.`ER6_7`, `Event`.`ER6_8`, `Event`.`ER6_9`, `Event`.`ER6_10`, `Event`.`ER6_11`, `Event`.`ER6_12`, `Event`.`ER6_13`, `Event`.`ER6_14`, `Event`.`ER6_15`, `Event`.`ER6_16`, `Event`.`ER6_17`, `Event`.`ER6_18`, `Event`.`ER6_19`, `Event`.`ER6_20`, `Event`.`ER6_21`, `Event`.`ER6_22`, `Event`.`ER6_23`, `Event`.`ER6_24`, `Event`.`ER6_25`, `Event`.`ER6_26`, `Event`.`ER6_27`, `Event`.`ER6_28`, `Event`.`ER6_29`, `Event`.`ER6_30`, `Event`.`ER7`, `Event`.`ER8`, `Event`.`ER9_1`, `Event`.`ER9_2`, `Event`.`ER9_3`, `Event`.`ER9_4a`, `Event`.`ER9_4b`, `Event`.`ER9_5`, `Event`.`ER10_1`, `Event`.`ER10_2`, `Event`.`ER10_3`, `Event`.`ER10_4`, `Event`.`ER10_5`, `Event`.`ER10_6`, `Event`.`ER10_7`, `Event`.`ER10_8`, `Event`.`ER10_9`, `Event`.`AETC`, `Event`.`SUBSITE`, `Event`.`PROG_ID`, `Event`.`max_registrants`, `Event`.`is_password_protected`, `Event`.`password`, `Event`.`webinar_link`, `Event`.`confirmation_email`, `Event`.`extra_questions`, `Event`.`level`, `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` FROM `cakedb`.`events` AS `Event` WHERE `Event`.`id` = 740 LIMIT 1112
5SELECT `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` = (740)000
6SELECT `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` = (740)991
7SELECT `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
8SELECT COUNT(1) as Registration__count, event_id FROM registrations AS Registration GROUP BY event_id;428242827