May

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	31

Wednesday, Sep 9, 2015 - 3:00pm
Pitt-CIRTL opportunities to engage in and learn about scholarly teaching
Friday, Nov 7, 2008 - 10:30am
Transactional Memory: The Surprising Complexity of a Simple Idea
Friday, Sep 5, 2008 - 10:30am
Building and Verifying a Shallow Ontology for Higher-Quality NLP

[More Events]

IMPROVING PEER LEARNING AND KNOWLEDGE SHARING IN STEM COURSES VIA PATTERN BASED GRAPH VISUALIZATION

Type	Dissertation Defense
Start Date	July 10, 2015 01:00 PM
End Date	July 10, 2015 01:00 PM
Location	6106 SENSQ
Speaker Name	Emilio Zegarra
Abstract	High quality education in Science, Technology, Engineering and Math (STEM) majors expects not only the acquisition of comprehensive domain knowledge, but also the mastery of skills to solve open ended and even ill-defined problems in real world. Problem-based Learning (PBL) is usually adopted to achieve such goals by encouraging students to learn by solving real-life problems. However, successful PBL requires sustained and in-depth involvement of faculty members, hence making PBL not scalable. Even though discussion forums and Q&A systems can help address the scalability problem of faculty involvement on large class sizes, it introduces new problems. First of all, as knowledge bases grow in size, the sheer size of the accumulated knowledge makes it harder to locate the desired information. Secondly, existing knowledge discovery techniques do not provide effective facilities for the capture and reuse of solutions to recurring problems under different contexts. To address these challenges, we developed MicroBrowser, an interactive Question & Answer (Q&A) system augmented with 2D discussion visualizations and pattern based expertise sharing interfaces. MicroBrowser allows learners to browse and navigate important discussions in PBL based on topic similarity encoded by node proximity in a knowledge graph. MicroBrowser also provides a set of pattern based expertise sharing interfaces to allow both learners and instructors to refine, reuse, and share major findings in PBL. Results of empirical evaluations of our proposed solution using students in STEM majors show task difficulty and success rate improves over state-of-the-art Q&A systems for knowledge discovery and reuse tasks. Moreover, we show that, students also found the pattern based expertise sharing interface easy to use and were able to contribute new knowledge in the form of new knowledge connections and even recommending new design patterns.
Committee	Dr. Jingtao Wang, Department of Computer Science Dr. Diane Litman, Department of Computer Science Dr. Chris Schunn, Department of Psychology Dr. Jennifer Iriti, Learning Research and Development Center

(default) 89 queries took 3 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	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 `Event`.`id` = 103 LIMIT 1	1	1	1
2	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	0
3	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
4	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
5	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 44	1	1	0
6	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 31	1	1	0
7	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 52	1	1	0
8	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 47	1	1	0
9	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 43	1	1	0
10	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 36	1	1	0
11	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
12	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
13	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
14	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 50	1	1	0
15	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
16	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
17	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
18	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
19	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
20	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
21	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
22	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	0
23	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
24	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 54	1	1	0
25	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 55	1	1	0
26	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 56	1	1	0
27	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
28	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
29	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
30	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
31	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	0
32	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
33	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
34	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
35	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	1
36	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
37	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
38	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
39	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
40	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
41	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
42	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 48	1	1	0
43	SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 51	1	1	0
44	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	0
45	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
46	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
47	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
48	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
49	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
50	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
51	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	0
52	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	0
53	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE '/events/view/103' LIMIT 1	0	0	0
54	SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'events/view' 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 'events' LIMIT 1	1	1	0
56	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
57	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
58	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-05-01' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	0
59	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-05-02' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	0
60	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-05-03' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	0
61	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-05-04' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	0
62	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-05-05' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	0
63	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-05-06' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	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-05-07' 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-05-08' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	0
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-05-09' 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-05-10' 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-05-11' 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-05-12' 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-05-13' 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-05-14' 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-05-15' 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-05-16' 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-05-17' 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-05-18' 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-05-19' 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-05-20' 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-05-21' 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-05-22' 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-05-23' 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-05-24' 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-05-25' 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-05-26' 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-05-27' 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-05-28' 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-05-29' 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-05-30' 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-05-31' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)	1	1	0
89	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) 89 queries took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

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 `Event`.`id` = 103 LIMIT 1

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 '/events/view/103' LIMIT 1

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

SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'events' 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 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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-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-05-30' 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-05-31' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)

IMPROVING PEER LEARNING AND KNOWLEDGE SHARING IN STEM COURSES VIA PATTERN BASED GRAPH VISUALIZATION

VISIT US

CONNECT WITH US