Pitt Computer Science : Home

07/07/15 Professor Jan Wiebe has been named the General Chair of the 2016 Empirical Methods in Natural Language Processing Conference (EMNLP-2016).
07/14/15 Congrats to CS Student Kyle Amoroso on his win in the online hackathon on ChallengePost, Reinvent the Selfie! His hack called, Game Boy Selfie
06/11/15 Professors Wang, Menekse, and Litman are collaborating with grad students on an exciting new project, CourseMIRROR! CourseMIRROR improves stude

More News

Events and Talks

09/09/15 Pitt-CIRTL opportunities to engage in and learn about scholarly teaching
11/07/08 Transactional Memory: The Surprising Complexity of a Simple Idea
09/05/08 Building and Verifying a Shallow Ontology for Higher-Quality NLP

More Events

Please select an event to the left.

D
E
T
A
I
L
S

April

S	M	T	W	H	F	S
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30

(default) 94 queries took 25 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `News`.`id`, `News`.`title`, `News`.`content`, `News`.`published`, `News`.`person_id`, `News`.`modifier_id`, `News`.`created`, `News`.`modified`, `News`.`PressReleases`, `News`.`Accolades`, `News`.`OutreachNews`, `News`.`DepartmentalNews`, `News`.`upload`, `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` FROM `cs_jkl26`.`news` AS `News` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`News`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`News`.`person_id` = `Person`.`id`) WHERE 1 = 1 LIMIT 3	3	3	15
2	SELECT `Slide`.`id`, `Slide`.`image`, `Slide`.`link`, `Slide`.`created`, `Slide`.`modified` FROM `cs_jkl26`.`slides` AS `Slide` WHERE 1 = 1 ORDER BY `created` DESC	3	3	1
3	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `name` LIKE 'Top Menu' LIMIT 1	1	1	1
4	SELECT `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` ASC	2	2	0
5	SELECT `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` ASC	6	6	0
6	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 44	1	1	0
7	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 31	1	1	0
8	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 52	1	1	0
9	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 47	1	1	0
10	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 43	1	1	0
11	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 36	1	1	0
12	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '44' LIMIT 1	1	1	0
13	SELECT `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` ASC	8	8	0
14	SELECT `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` ASC	1	1	0
15	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 50	1	1	0
16	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '50' LIMIT 1	1	1	0
17	SELECT `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` ASC	2	2	0
18	SELECT `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` ASC	0	0	0
19	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '31' LIMIT 1	1	1	0
20	SELECT `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` ASC	6	6	0
21	SELECT `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` ASC	0	0	0
22	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '52' LIMIT 1	1	1	0
23	SELECT `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` ASC	2	2	1
24	SELECT `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` ASC	3	3	0
25	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 54	1	1	0
26	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 55	1	1	0
27	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 56	1	1	0
28	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '54' LIMIT 1	1	1	0
29	SELECT `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` ASC	3	3	0
30	SELECT `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` ASC	0	0	0
31	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '55' LIMIT 1	1	1	0
32	SELECT `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` ASC	3	3	1
33	SELECT `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` ASC	0	0	0
34	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '56' LIMIT 1	1	1	0
35	SELECT `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` ASC	3	3	0
36	SELECT `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` ASC	0	0	0
37	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '47' LIMIT 1	1	1	0
38	SELECT `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` ASC	10	10	0
39	SELECT `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` ASC	0	0	0
40	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '43' LIMIT 1	1	1	0
41	SELECT `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` ASC	1	1	0
42	SELECT `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` ASC	2	2	0
43	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 48	1	1	0
44	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 51	1	1	0
45	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '48' LIMIT 1	1	1	1
46	SELECT `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` ASC	4	4	0
47	SELECT `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` ASC	0	0	0
48	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '51' LIMIT 1	1	1	0
49	SELECT `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` ASC	6	6	0
50	SELECT `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` ASC	0	0	0
51	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '36' LIMIT 1	1	1	0
52	SELECT `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` ASC	6	6	1
53	SELECT `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` ASC	0	0	1
54	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE '/' LIMIT 1	0	0	0
55	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'pages/display' LIMIT 1	0	0	0
56	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'pages' LIMIT 1	0	0	0
57	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `name` LIKE 'Default Quicklinks' LIMIT 1	1	1	0
58	SELECT `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` = (33) ORDER BY `MenuItem`.`position` ASC	1	1	0
59	SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (33) ORDER BY `Child`.`position` ASC	1	1	0
60	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 31	1	1	0
61	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '31' LIMIT 1	1	1	0
62	SELECT `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` ASC	6	6	0
63	SELECT `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` ASC	0	0	0
64	SELECT 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`)	1	1	0
65	SELECT 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`)	1	1	1
66	SELECT 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`)	1	1	0
67	SELECT 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`)	1	1	0
68	SELECT 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`)	1	1	0
69	SELECT 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`)	1	1	0
70	SELECT 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`)	1	1	0
71	SELECT 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`)	1	1	0
72	SELECT 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`)	1	1	0
73	SELECT 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`)	1	1	0
74	SELECT 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`)	1	1	0
75	SELECT 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`)	1	1	0
76	SELECT 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`)	1	1	0
77	SELECT 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`)	1	1	0
78	SELECT 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`)	1	1	0
79	SELECT 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`)	1	1	0
80	SELECT 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`)	1	1	0
81	SELECT 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`)	1	1	0
82	SELECT 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`)	1	1	0
83	SELECT 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`)	1	1	0
84	SELECT 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`)	1	1	0
85	SELECT 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`)	1	1	0
86	SELECT 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`)	1	1	0
87	SELECT 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`)	1	1	0
88	SELECT 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`)	1	1	0
89	SELECT 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`)	1	1	1
90	SELECT 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`)	1	1	0
91	SELECT 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`)	1	1	0
92	SELECT 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`)	1	1	0
93	SELECT 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`)	1	1	0
94	SELECT `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 3	3	3	1

(default) 94 queries took 25 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `News`.`id`, `News`.`title`, `News`.`content`, `News`.`published`, `News`.`person_id`, `News`.`modifier_id`, `News`.`created`, `News`.`modified`, `News`.`PressReleases`, `News`.`Accolades`, `News`.`OutreachNews`, `News`.`DepartmentalNews`, `News`.`upload`, `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` FROM `cs_jkl26`.`news` AS `News` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`News`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`News`.`person_id` = `Person`.`id`) WHERE 1 = 1 LIMIT 3

SELECT `Slide`.`id`, `Slide`.`image`, `Slide`.`link`, `Slide`.`created`, `Slide`.`modified` FROM `cs_jkl26`.`slides` AS `Slide` WHERE 1 = 1 ORDER BY `created` DESC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `name` LIKE 'Top Menu' LIMIT 1

SELECT `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` ASC

SELECT `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` ASC

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 44

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 31

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 52

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 47

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 43

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 36

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '44' LIMIT 1

SELECT `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` ASC

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 50

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '50' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '31' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '52' LIMIT 1

SELECT `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` ASC

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 54

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 55

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 56

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '54' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '55' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '56' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '47' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '43' LIMIT 1

SELECT `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` ASC

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 48

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 51

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '48' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '51' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '36' LIMIT 1

SELECT `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` ASC

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE '/' LIMIT 1

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'pages/display' LIMIT 1

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'pages' LIMIT 1

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `name` LIKE 'Default Quicklinks' LIMIT 1

SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (33) ORDER BY `Child`.`position` ASC

SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 31

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '31' LIMIT 1

SELECT `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` ASC

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT 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`)

SELECT `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 3

Events and Talks

VISIT US

CONNECT WITH US