| 1 | SELECT `Site`.`id`, `Site`.`title` FROM `cakedb`.`sites` AS `Site` WHERE 1 = 1 | | 12 | 12 | 0 |
| 2 | SELECT `Event`.`ERDATE`, `Event`.`site_id`, `Event`.`AETC`, `Event`.`ER5_0`, `Event`.`ER10_8`, `Event`.`ER10_9` FROM `cakedb`.`events` AS `Event` WHERE `status` = '1' AND `ERDATE` >= '2016-09-01' AND `ERDATE` <= '2016-09-30' GROUP BY `Event`.`ERDATE` ORDER BY `ERDATE` asc | | 33 | 33 | 4 |
| 3 | SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`body`, `News`.`content_status_id`, `News`.`published`, `News`.`featured`, `News`.`created`, `News`.`updated`, `News`.`public`, `News`.`site_id`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`credentials`, `User`.`organization`, `User`.`address1`, `User`.`address2`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`phone`, `User`.`dob`, `User`.`uniqueidnumber`, `User`.`active`, `User`.`created`, `User`.`role`, `User`.`taap_access`, `User`.`email_list`, `User`.`site`, `User`.`last_login`, `User`.`attempt_time`, `User`.`attempt_try`, `User`.`speaker`, `Status`.`id`, `Status`.`name`, `Status`.`description`, `Content`.`id`, `Content`.`user_id`, `Content`.`content_id`, `Content`.`content_type_id`, `Content`.`site_id` FROM `cakedb`.`news` AS `News` LEFT JOIN `cakedb`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `cakedb`.`content_statuses` AS `Status` ON (`News`.`content_status_id` = `Status`.`id`) LEFT JOIN `cakedb`.`contents` AS `Content` ON (`Content`.`content_id` = `News`.`id`) WHERE NOT (`published` IS NULL) AND `content_status_id` = 2 AND `public` = '0' ORDER BY `News`.`published` DESC LIMIT 4 | | 2 | 2 | 1 |
| 4 | SELECT `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`, `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`.`links` AS `Link` LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `national_resources_flag` = '1' ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC | | 9 | 9 | 4 |
| 5 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (155, 156, 157, 159, 160, 161, 162, 163, 191) | | 0 | 0 | 0 |
| 6 | SELECT `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`, `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`.`links` AS `Link` LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `quick_links_flag` = '1' ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC | | 4 | 4 | 2 |
| 7 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (145, 147, 148, 181) | | 0 | 0 | 0 |
| 8 | SELECT `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`, `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`.`links` AS `Link` LEFT JOIN `cakedb`.`attachments` AS `Attachment` ON (`Attachment`.`foreign_key` = `Link`.`id` AND `Attachment`.`model` = 'Link') WHERE `slider_flag` = '1' ORDER BY `Link`.`sort` ASC, `Link`.`created` ASC | | 2 | 2 | 2 |
| 9 | SELECT `MenuLink`.`id`, `MenuLink`.`link_id`, `MenuLink`.`parent_id`, `MenuLink`.`lft`, `MenuLink`.`rght` FROM `cakedb`.`menu_links` AS `MenuLink` WHERE `MenuLink`.`link_id` IN (195, 165) | | 0 | 0 | 0 |
| 10 |
SELECT
events.id,
events.ERDATE AS sort_order,
'event' AS content_type,
(SELECT count(id) FROM registrations AS r1 WHERE r1.event_id = events.id) AS registration_count,
events.password,
events.ERNAME AS 'title',
events.description,
events.max_registrants,
events.AETC,
events.fee,
events.type,
registrations.id AS is_registered,
sites.title AS site_name
FROM events
LEFT JOIN registrations ON registrations.event_id = events.id AND registrations.user_id = 0
LEFT JOIN sites ON sites.id = events.site_id
WHERE
events.registration_close_date >= NOW() AND
events.ERDATE >= NOW() AND
events.featured = 1 AND
events.status = 1
Union All
SELECT
id,
published as sort_order,
'news' AS content_type,
null,
null,
news.title,
news.body as description,
null,
null,
null,
null,
null,
null
FROM news
WHERE
published is not null AND
featured = 1 AND
public = 1
ORDER BY sort_order
LIMIT 4; | | 2 | 2 | 6 |
