Agenda for March 30, 2024

(default) 88 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Event`.`id`, `Event`.`title`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`location`, `Event`.`organizer_name`, `Event`.`organizer_email`, `Event`.`speaker_name`, `Event`.`speaker_affiliation`, `Event`.`speaker_bio`, `Event`.`abstract`, `Event`.`description`, `Event`.`committee`, `Event`.`note1`, `Event`.`note2`, `Event`.`note3`, `Event`.`twitter`, `Event`.`image`, `Event`.`attachment`, `Event`.`published`, `Event`.`event_template_id`, `Event`.`person_id`, `Event`.`modifier_id`, `Event`.`created`, `Event`.`modified`, `Modifier`.`id`, `Modifier`.`objectguid`, `Modifier`.`samaccountname`, `Modifier`.`cssdsamaccountname`, `Modifier`.`useraccountcontrol`, `Modifier`.`memberof`, `Modifier`.`userprincipalname`, `Modifier`.`distinguishedname`, `Modifier`.`displayname`, `Modifier`.`givenname`, `Modifier`.`sn`, `Modifier`.`mail`, `Modifier`.`physicaldeliveryofficename`, `Modifier`.`postofficebox`, `Modifier`.`telephonenumber`, `Modifier`.`title`, `Modifier`.`homepage`, `Modifier`.`bio`, `Modifier`.`pendingHomepage`, `Modifier`.`pendingBio`, `Modifier`.`created`, `Modifier`.`modified`, `Person`.`id`, `Person`.`objectguid`, `Person`.`samaccountname`, `Person`.`cssdsamaccountname`, `Person`.`useraccountcontrol`, `Person`.`memberof`, `Person`.`userprincipalname`, `Person`.`distinguishedname`, `Person`.`displayname`, `Person`.`givenname`, `Person`.`sn`, `Person`.`mail`, `Person`.`physicaldeliveryofficename`, `Person`.`postofficebox`, `Person`.`telephonenumber`, `Person`.`title`, `Person`.`homepage`, `Person`.`bio`, `Person`.`pendingHomepage`, `Person`.`pendingBio`, `Person`.`created`, `Person`.`modified`, `EventTemplate`.`id`, `EventTemplate`.`name`, `EventTemplate`.`fields`, `EventTemplate`.`color`, `EventTemplate`.`created`, `EventTemplate`.`modified` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `published` = '1' AND '2024-03-30' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)001
2SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `name` LIKE 'Top Menu' LIMIT 1110
3SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (11) ORDER BY `MenuItem`.`position` ASC220
4SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (11) ORDER BY `Child`.`position` ASC660
5SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 44110
6SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 31110
7SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 52110
8SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 47110
9SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 43110
10SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 36110
11SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '44' LIMIT 1110
12SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (44) ORDER BY `MenuItem`.`position` ASC880
13SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (44) ORDER BY `Child`.`position` ASC110
14SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 50110
15SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '50' LIMIT 1110
16SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (50) ORDER BY `MenuItem`.`position` ASC220
17SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (50) ORDER BY `Child`.`position` ASC000
18SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '31' LIMIT 1110
19SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (31) ORDER BY `MenuItem`.`position` ASC660
20SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (31) ORDER BY `Child`.`position` ASC000
21SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '52' LIMIT 1110
22SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (52) ORDER BY `MenuItem`.`position` ASC220
23SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (52) ORDER BY `Child`.`position` ASC330
24SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 54110
25SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 55110
26SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 56110
27SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '54' LIMIT 1110
28SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (54) ORDER BY `MenuItem`.`position` ASC330
29SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (54) ORDER BY `Child`.`position` ASC000
30SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '55' LIMIT 1110
31SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (55) ORDER BY `MenuItem`.`position` ASC330
32SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (55) ORDER BY `Child`.`position` ASC000
33SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '56' LIMIT 1110
34SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (56) ORDER BY `MenuItem`.`position` ASC330
35SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (56) ORDER BY `Child`.`position` ASC000
36SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '47' LIMIT 1110
37SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (47) ORDER BY `MenuItem`.`position` ASC10100
38SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (47) ORDER BY `Child`.`position` ASC000
39SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '43' LIMIT 1110
40SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (43) ORDER BY `MenuItem`.`position` ASC110
41SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (43) ORDER BY `Child`.`position` ASC220
42SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 48110
43SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 51110
44SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '48' LIMIT 1110
45SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (48) ORDER BY `MenuItem`.`position` ASC440
46SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (48) ORDER BY `Child`.`position` ASC000
47SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '51' LIMIT 1110
48SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (51) ORDER BY `MenuItem`.`position` ASC660
49SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (51) ORDER BY `Child`.`position` ASC000
50SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '36' LIMIT 1110
51SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (36) ORDER BY `MenuItem`.`position` ASC660
52SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (36) ORDER BY `Child`.`position` ASC000
53SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE '/events/agenda/2024-03-30' LIMIT 1000
54SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'events/agenda' LIMIT 1000
55SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'events' LIMIT 1110
56SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (51) ORDER BY `MenuItem`.`position` ASC660
57SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (51) ORDER BY `Child`.`position` ASC000
58SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-01' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
59SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-02' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
60SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-03' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
61SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-04' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
62SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-05' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
63SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-06' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
64SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-07' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
65SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-08' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
66SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-09' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
67SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-10' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
68SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-11' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
69SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-12' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
70SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-13' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
71SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-14' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
72SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-15' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
73SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-16' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
74SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-17' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
75SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-18' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
76SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-19' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
77SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-20' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
78SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-21' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
79SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-22' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
80SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-23' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
81SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-24' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
82SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-25' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
83SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-26' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
84SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-27' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
85SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-28' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
86SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-29' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
87SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-30' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
88SELECT `Event`.`id`, `Event`.`title`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`location`, `Event`.`organizer_name`, `Event`.`organizer_email`, `Event`.`speaker_name`, `Event`.`speaker_affiliation`, `Event`.`speaker_bio`, `Event`.`abstract`, `Event`.`description`, `Event`.`committee`, `Event`.`note1`, `Event`.`note2`, `Event`.`note3`, `Event`.`twitter`, `Event`.`image`, `Event`.`attachment`, `Event`.`published`, `Event`.`event_template_id`, `Event`.`person_id`, `Event`.`modifier_id`, `Event`.`created`, `Event`.`modified`, `Modifier`.`id`, `Modifier`.`objectguid`, `Modifier`.`samaccountname`, `Modifier`.`cssdsamaccountname`, `Modifier`.`useraccountcontrol`, `Modifier`.`memberof`, `Modifier`.`userprincipalname`, `Modifier`.`distinguishedname`, `Modifier`.`displayname`, `Modifier`.`givenname`, `Modifier`.`sn`, `Modifier`.`mail`, `Modifier`.`physicaldeliveryofficename`, `Modifier`.`postofficebox`, `Modifier`.`telephonenumber`, `Modifier`.`title`, `Modifier`.`homepage`, `Modifier`.`bio`, `Modifier`.`pendingHomepage`, `Modifier`.`pendingBio`, `Modifier`.`created`, `Modifier`.`modified`, `Person`.`id`, `Person`.`objectguid`, `Person`.`samaccountname`, `Person`.`cssdsamaccountname`, `Person`.`useraccountcontrol`, `Person`.`memberof`, `Person`.`userprincipalname`, `Person`.`distinguishedname`, `Person`.`displayname`, `Person`.`givenname`, `Person`.`sn`, `Person`.`mail`, `Person`.`physicaldeliveryofficename`, `Person`.`postofficebox`, `Person`.`telephonenumber`, `Person`.`title`, `Person`.`homepage`, `Person`.`bio`, `Person`.`pendingHomepage`, `Person`.`pendingBio`, `Person`.`created`, `Person`.`modified`, `EventTemplate`.`id`, `EventTemplate`.`name`, `EventTemplate`.`fields`, `EventTemplate`.`color`, `EventTemplate`.`created`, `EventTemplate`.`modified` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `published` = '1' LIMIT 3331