All News

  • 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
  • 06/03/15 Professor Jan Wiebe is the Academic Keynote Speaker at the Canadian AI Conference 2015 in Halifax, Nova Scotia, Canada.
  • 06/08/15 It is with a heavy heart that we inform you of the sudden passing of the CS Department's long time Part-Time Instructor George Jucha. George w
  • 05/22/15 88 more students declare as a Computer Science major since January 2015! The CS Department grows as the demand for computer scientists is on
  • 04/30/15 It is with extreme sadness that we share the news that Dr. Robert Daley has passed away this week. Dr. Daley was a professor in the Department
  • 04/29/15 Congrats to all of the Computer Science students that entered the Randall Family Big Idea Competition! The Department of Computer Science had t
  • 04/22/15 Check out Pitt Computer Science student Elliot Spencer Bingol's work on bringing Homestead and West Homestead into the 21st century with digita
  • 04/16/15 Congratulations to Professor Panos Chrysanthis for receiving the Provost's Mentor Award! The Provost's Award for Excellence in Mentoring recogn
  • 04/15/15 The Class of 2015 is expected to be the largest graduating class the Computer Science Department has ever had, with an anticipated 107 graduates!
  • 04/08/15 Congrats to Pitt CS undergraduates Natalie Isenberg and Sylvia Ujwary on being a 2015 DAAD RISE recipient! (German Academic Exchange Service R
  • 04/07/15 Congratulations to Professor Adam Lee and Doctoral Candidate Bill Garrison on their Mentor-Mentee Teaching Award! We are happy to announce th
  • 04/02/15 Congrats to Pitt CS Alumnus Jesse Thomason Jesse has been awarded the 2015 NSF Graduate Research Fellowship! Congrats Jesse! #H2P
  • 03/17/15 Congratulations to Panos Chrysanthis and Alex Labrinidis on recieving a MCSI 2015 Research Seed Grant!
  • 04/01/15 Congrats to our CS Day Graduate Research Winners! AI: Charmgil Hong, Systems/Networks: Xiaolong Cui, Theory/Algorithms: Neal Barcelo, Datab
  • 03/16/15 Breaking the 300-Mark: CS Declared Majors are at an All-Time High This year the Department of Computer Science is proud to announce that we hav
  • 03/16/15 The Department of Computer Science has ranked #52 according to US News and World Report Rankings on the best grad schools and #26
  • 03/02/15 CS DAY 2015 is right around the corner! March 27, 2015 is the 15th Annual Computer Science Day! Find out all the details at our
  • 02/20/15 SteelHacks - March 27th - 29th 2015! Department of Computer Science will host 150 students from Pitt, CMU, and Duquesne for SteelHacks
  • 01/26/15 We are proud to announce that NCWIT (National Center for Women and Information Technology) has selected the University of Pittsburgh’s Women
  • 02/05/15 Announcing the CS Day Hackathon: SteelHacks The Department of Computer Science is partnering with the Pitt CS Club to bring you SteelHacks
  • 01/26/15 Professor Jan Wiebe will be the Academic Keynote Speaker for The 28th Canadian Conference on Artificial Intelligence, Halifax, Nova Scotia, J
  • 01/23/15 Department of Computer Science Alumnus Robert S. (Bob) Seiner (class of 1985) recently published his first book on Non-Invasive Data Governanc
  • 11/24/14 December Graduate Recognition and Reception to be held on Wednesday, December 10th, 2014 at 4:00pm!
  • 01/21/15 She Innovates Kick-off Party will be held on 1/30/2015 at 5pm-7pm in 5317 Sennott Square! Pitt's first all-women's hackathon!
  • 01/14/15 NCWIT Collegiate Award Applications Are Now Open Sponsored by Hewlett-Packard, the NCWIT Collegiate Award honors outstanding undergraduate wom
  • 12/22/14 Department of Computer Science Alumnus Chad Lane (class of 2004) recently accepted a position as Assoc. Professor at the University of Illino
  • 12/03/14 SHE INNOVATES... The Department of Computer Science will be partnering with Innovation Institute, Pitt SWE, and Pitt WiCS to host Pitt's first all wo
  • 12/01/14 The Mu chapter of Upsilon Pi Epsilon, the international honor society for the computing and information disciplines inducted four new members on Novem
  • 11/05/14 CS DAY 2015! CS DAY will be held on March 27th, 2015!
  • 11/11/14 CS welcomes high school students in Big Data Class on 11/19!!
  • 11/11/14 Brunch for Newly Declared CS Majors on 11/21/2014 @ 10:00am in 5317 Sennott Square! If you declared after January 2014, then you are invited!!
  • 07/14/14 Professor Alexandros Labrinidis is the co-author of a new review article, entitled Big Data
  • 10/16/14 Professors Alexandros Labrinidis and Panos K. Chrysanthis are co-investigators in the newly funded Center for Causal Modeling and Discovery of Biomedi
  • 05/08/14 Congratulations to Professor Alexandros Labrinidis on being a newly elected member of the Faculty Assembly for Natural Sciences from the Dietr
  • 05/01/14 Congratulations to Professor Adam Lee on becoming a tenured faculty member effective September 2014!
  • 04/11/14 Graduate student Chris Thomas has been awarded the 2013-2014 Eliza
  • 04/04/14 Alumni Andrew Head received a NSF Graduate Resear
  • 04/02/14 The Computer Science Department and the Graduate School of Public and International Affairs will host an international workshop,
  • 10/28/13 The Department of Computer Science has lost Alfs Berztiss, Professor Emeritus. Dr. Berztiss was hired during the departments early years in Se
  • 09/01/13 PhD student Nicholas L. Farnan and Professors Adam J. Lee and Panos K. Chrysanthis demonstrated "PAQO: A Preference-Aware Query O
  • 10/21/13 Second year graduate students John Wenskovitch (CS),Tim Luciani (CS), and Koonwah Chen (IS), and Professor G. Elisabeta Marai
  • 10/15/13 Professor Daniel Mosse' will present for the University Honors College Friday Afternoon Lecture series on Friday, October 25th at 2:00pm, 3500
  • 10/03/13 Graduate student Adrian Maries and Professor G. Elisabeta Marai will be presenting their paper entitled GRACE: A Visual Comparison Fr
  • 09/04/13 Graduate student Md. Abedul Haque and Professor G. Elisabeta Marai will be presenting their paper entitled "A Semi-Automated Method for
  • 08/21/13 Professor G. Elisabeta Marai (Computer Science) and Professor Kay Nieselt (Bioinformatics, University of Tuebingen) are Program Chairs for the
  • 08/09/13 The department just concluded its Technology Leadership Initiative (TLI) where over 70 middle and
  • 08/08/13 Graduate student Timothy Luciani gave a research presentation titled Large-Scale Overlays and Trends: Visually Mining, Panning and Zooming the
  • 08/07/13 Graduate student Nicholas Farnan received the Andrew Mellon Pre-Doctoral Fellowship and graduate student Wenting Xiong is an alt
  • 08/01/13 Professor Alexandros Labrinidis participated in the panel on "Education and career paths for data scientists" of the 25th International Confere
  • 07/31/13 Professor Diane Litman will be presenting a keynote address entitled "Enhancing the Effectiveness of Spoken Dialogue for STEM Education" at the
  • 07/30/13 Graduate student Md. Abedul Haque and Professor G. Elisabeta Marai will be presenting their paper entitled "Image to Mesh: Spinal Ligame
  • 07/16/13 Graduate student Eric Heim received a SMART Scholarship (Science, Mathematics, and Researc
  • 07/08/13 Professor Panos K. Chrysanthis together with Professor Ling Liu of Georgia Institute of Technology are trusted to co-chair again the 2nd
  • 06/24/13 Graduate student Daniel Walker will be presenting a talk at the M
  • 06/21/13 Graduate student William Garrison III, Professor Adam Lee,University of Illinois at Chicago Professor Timothy L. Hinrichs and Professor Leno
  • 06/20/13 The department is proud to announce that Professor Adam Lee has been honored with an
  • 06/19/13 Newly PhD graduate Panickos Neophytou and his advisors Professors Panos K. Chrysanthis and Alexandros Labrinidis will present their pape
  • 06/19/13 Graduate students Michael Lipschultz, Huy Nguyen and Wenting Xiong, alumni undergraduate Jesse Thomason, and Professor Diane L
  • 05/31/13 Graduate students Wencan Luo and Wenting Xiong, alumni undergraduate Jesse Thomason, and Professor Diane Litman will pres
  • 05/30/13 Professor Sangyeun Cho and graduate student Juyoung Jung will present a paper entitled "Memorage: Emerging Persistent RAM based Malleabl
  • 05/06/13 Congratualtions to undergraduate student Jesse Thomason on receiving an Honorable Mention in the Computing Research Association's (CRA)
  • 05/14/13 Professor Liz Marai organized and ran a hands-on introduction to animation workshop along with Graduate students, Kelli Ireland, Mike Lipsc
  • 05/01/13 Senior Lecturer George Novacky's Introduction to Computer Programming with Python Course was the focus of the Datamation article entitled,
  • 04/22/13 Congratulations to all the high school girls who were named the 2013 NCWIT Aspira
  • 04/22/13 On April 19th, our department hosted a viewing and panel discussion of the film entitled,
  • 04/01/13 Congratulations to PhD Student Neal Barcelo for being one of the eleven recipients this year of an
  • 03/20/13 Professors Chrysanthis and Labrinidis are members of the advisory board that has founded the
  • 03/01/13 PhD student Jiannan Ouyang and Professor Jack Lange will be presenting their paper entitled, "Preemptable Ticket Spinlocks: Improving Consolida
  • 04/04/13 Professors Chrysanthis and Labrinidis were featured in a University Times article
  • 02/28/13 Graduate student Ryan W. Moore and Professor Bruce R. Childers will be presenting their paper entitled, "Automatic Generation of Program
  • 11/09/12 On October 26th Professor John Ramirez was on a panel of faculty who received the 2012 Chancellor\'s Distinguished Teaching Award. You can hear
  • 11/07/12 PHD student Socrates Demetriades and Professor Sangyeun Cho have been chosen to present their paper entitled, \"Predicting Coherence Communicat
  • 10/30/12 CS Professor Panos Chrysanthis, along with Stavros Papastavrou, and George Samaras will be presenting their research on, \"Exploring Con
  • 10/01/12 Professor Adam Lee has started his research on the
  • 10/22/12 Graduate student Timothy Luciani, Astronomy graduate student Brian Cherinka, CS alumni student Boyu Sun, undergraduate student
  • 09/26/12 CS alumni Lindsay Bieda and Julie Pagano founded the nonprofit Pittsburgh chapter of
  • 08/10/12 The Department of Computer Science just concluded its Technology Leadership Initiative! Congr
  • 08/27/12 Congratulations to Dr. Sangyeun Cho for winning a 201
  • 08/08/12 Graduate student PJ Dillon and Professor Taieb Znati will be presenting their paper and poster entitled, “Towards an Architecture for Mobile He
  • 09/19/12 Professors Panos K. Chrysanthis and Alexandros Labrinidis ,co- directors of The Advanced Dat
  • 07/26/12 Graduate student William C. Garrison III, Assistant Professor Adam J. Lee, and their collaborator Timothy L. Hinrichs will be presenting
  • 07/25/12 Tim Luciani, first year doctoral student in CS, is the second CS student to receive an NSF Graduate Research Fellowship! Tim's selection was b
  • 07/23/12 Congratulations to graduate student Mehmud Abliz and Professor Taieb Znati for winning the Best Paper Award on the Workshop on a Community Su
  • 07/16/12 The Department of Computer Science is proud to partner with Girl Develop It which is an
  • 06/18/12 Professors Panos K. Chrysanthis and Alexandros Labrinidis, directors of the Advanced Data Management Technology Lab, were invited to the inaugu
  • 06/07/12 As an initiative to increase diversity in our department, we are proud to be a bronze sponsor of the 2012
  • 05/01/12 On March 29. 2012, the Obama Administration unveiled its $200M Big Data R&D Initiative. Associate Professor Alexandros Labrinidis was part of
  • 05/07/12 We are pleased to announce that our department is now an Academic Alliance member of the National Center for Women & Information Technology, a coaliti
  • 04/25/12 Alice Lingming Lai who received the 2012 Outstanding CS Undergraduate Student Award, has also been awarded a 2012 NSF Graduate Researc
  • 04/19/12 CS Part-time faculty Paul Covaleski receives the Students\' Choice Award from the College of General Studies Student Government. The award was
  • 04/19/12 Rami Melhem, CS faculty, is awarded the 2012 Provost\'s Award for
  • 04/19/12 As we approach the last week of classes and finals week, the Teaching Times would like to offer faculty and graduate instructors some information to h
  • 04/19/12 The Computing Research Association\'s Committee on the Status of Women (CRA-W) and the Coalition to Diversify Computing (CDC), chose graduate student
  • 03/05/12 Marian Iskander, Ryan Moore, and Thao Nguyen Pham, CS graduate students, received the Andrew Mellon Pre-doctoral Fellowship
  • 04/19/12 Graduate student PJ Dillon has been selected to participate in the 2012 NYC Turing Fellows Summer Internship Program and matched with Sulia, a
  • 02/23/12 John Ramirez, CS Senior Lecturer, is one of 5 awarded the 2012 Chancellor\'s Distinguished Teaching Award. Dr. Ramirez was recognized for havi
  • 04/04/03 D. Raja
    D. Raja is the co-founder of Computer Enterprises, Inc., be
  • 03/30/11 Department Chairman Daniel Mosse\' and CS Faculty Diane Litman participated in the
  • 09/01/04 Gerard A. Pompa
    Born in Pittsburgh, Pennsylvania, Mr. Pompa receiv
  • 04/24/09 Liz Marai
    Congratulations to Liz Marai, Assistant Professor,
  • 01/02/09 KyoungSoo Park
    KyoungSoo Park joined the Computer Scie
  • 01/01/04 Panos Chrysanthis
    Dr. Panos K. Chrysanthis became official
  • 08/18/08 Adam Lee
    Adam Lee, Assistant Professor, a new faculty member
  • 06/03/05 Kurt VanLehn Presents LearnLab in D.C.
    Kurt VanLehn,
  • 08/05/05 Optoelectronic Computing Research Group Installs Clean Room
  • 08/05/05 Parsing Arabic Dialects
    This summer, Assistant Professor Reb
  • 01/06/06 Center for Modeling Pulmonary Immunity
    Professor Panos K. Chry
  • 08/04/06 Understanding Events and Beliefs Expressed in Text
    Professor Ja
  • 07/04/08 CAREER: Robust Parsing for New Domains and Languages
    Assistant P
  • 08/07/09 Towards a Dynamic and Composable Model of Trust
    Assistant Profes
  • 09/10/09 An Affect-Adaptive Spoken Dialogue System that Responds Based on User Model an
  • 10/12/09 Word Sense and Multilingual Subjectivity Analysis
    Professor
  • 10/09/09 Using Medical Records Repositories to Improve the Alert System Design
  • 04/09/10 Toward Formal, Risk-Aware Authorization
    Assistant Professor
  • 06/04/10 CSR: Large: Storage Class Memory Architecture for Efficient Data
  • 08/25/03 Rebecca Hwa
    Dr. Rebecca Hwa joined the Department of Computer S
  • 01/19/12 Sangyeun Cho, CS Faculty, is elected as a Senior Member of IEEE. IEEE
  • 09/01/11 Youtao Zhang is promoted to Associate Professor with tenure (effective September 1, 2011). Congr
  • 01/12/12 CS Alum, Tawfig Al Rabiah (MS\'96, PhD\'99), appointed Minister of Commerce and Industry in the Kingdom of Saudi Arabia. The Ministry of Comme
  • 10/24/11 Adam M. Smith and Yao Sun (CS graduate students), Wen Xu (MS \'11), James R. Faeder (Computational Systems & Biology facul
  • 10/21/11 Two CS undergrad teams compete for the World\'s Smartest Trophy lead by coach John Ramirez. The Association for Computing Machinery Int
  • 08/04/11 CS and Physics & Astronomy faculty awarded a 4-year, $1.6M NSF Grant for
  • 08/16/11 Professor Diane Litman, CS Faculty, is honored as s Senior Member in the Association for the Advancement of Artificial Intelligence (AAAI-11).
  • 09/16/11 In April 2011, Professor Kirk Pruhs gave the keynote invited talk, entitled Managing Power Heterogeneity, at
  • 02/25/05 Mary Lou Soffa
    After being recruited by a number of other universi
  • 09/14/05 Ras Bodik
    Ras Bodik got his PhD at Pitt in 2000 under the g
  • 05/02/11 Graduating CS seniors and their family celebrate on Saturday evening at the William Pitt Union. Some
  • 04/08/11 Joanna Drummond, CS alumnus, has been selected to receive a 2011-2012 National Science Found
  • 04/08/11 CS Undergrad Brian Sisco is part of the Pitt team competing in
  • 09/28/11 Congratulations to the Faculty and Graduate Students who received awards at the 2
  • 04/08/11 An Open Space Conference was held April 2nd at the Department of Computer Science. A group of Pittsburgh technologists enthusiasts discussed t
  • 04/04/11 Nancy Kreuzer retires after 29 years in the Department of Computer Science. We celebrated her retirement on Thursday, March 31st and many coll
  • 05/13/11 Jingtao Wang
    Assistant Professor Jingtao Wang selected for
  • 05/13/11 Sangyeun Cho
    Associate Professor Sangyeun Cho selected for t
  • 03/30/11 CS sophomores, Kevin Jeffries and Sean Myers, are among the 50 selected nationwide to receive the Microsoft Golden Ticket. Kevin and Se
  • 03/07/11 Iyad Batal and Wenting Xiong, CS graduate students, received the Andrew Mellon Predoctoral Fellowship for the 2011-2012 academic
  • 03/22/11 The National Research Council (NRC) has ranked the Department of Computer Science 34th out of 128 ranked programs. The department jumping 9 positions
  • 02/24/11 A research submission from Jesse Thomason, sophomore in CS, has been accepted by the upcoming
  • 02/23/11 The CS Department is participating in the A&S Hot Metal Bridge Pro
  • 12/14/10 Yi Deng(Ph.D.'92) was appointed last year as Dean of the College of
  • 01/28/11 Mengmeng Li, CS Graduate Student, awarded the Microsof
  • 12/14/10 Mary Jean Harrold, a 1988 PhD graduate of our department, will be elevated to the grade of Diane Litman
    Professor Diane Litman participates in the <
  • 12/14/10 Two CS alumni were recognized as ACM Distinguished
  • 11/22/10 Associate Professor Milos Hauskrecht received the Homer R. Warner award for his paper MS Puzzle Challenge takes 6th place at CMU
  • 10/29/10 CS Grad students, Wenting Xiao, Yao Sun, Octavio Herrera, and Emilio Zegarra awarded second place in the Technology Scaven
  • 09/20/10 CS Undergraduate Heather Friedberg was awarded the 2010 Google Engineering Intern Scholarship. The recipients are selected from Google
  • 05/15/10 Professors Panos K. Chrysanthis and Kirk Pruhs presented NSF-funded Research on Sustainable Computin
  • 07/26/10 Alexander Conrad, CS graduate student and Gregory Kapfhammer, CS alumnus (PhD,\'07), receive the Best Paper Award in the
  • 07/22/10 CS alumnus, John Grefenstette (PhD,'80), is named the director of the new Public Health Dynamics Laboratory at the Pitt Graduate School of Publ
  • 07/14/10 Sangyeun Paul Cho is promoted to Associate Professor with tenure (effective September 1st,
  • 12/09/09 Enabling Fast and Versatile Packet Processing for Future Larger-Scale Networks
  • 07/13/10 Professor Panos K. Chrysanthis was named the Program Chair for HDMS2010, Pr
  • 07/08/10 Best Paper Award at the 10th International Conference on Intelligent Tutoring Syste
  • 06/23/10 Yann Le Gall, CS graduate student is featured in the article,
  • 08/15/07 Java Lab Upgrade: Our Java Lab classroom was recently upgraded from Sun SPARC machines running Solaris to Intel-based Apple Mac Minis
  • 04/26/07 Pittsburgh rated most livable city in the US
  • 02/10/09 Colleges try to increase numbers of women, minorities in science and eng
  • 07/31/07 Congratulations to the
  • 11/02/07 Starting salary offers for
  • 11/28/07 Staff Appreciation: Bob Hoffman, Nancy Kreuzer, Kathy O'Connor, and Terry Wood are being recognized by
  • 02/12/09 Sri Mandayam (a WiCS coordinator), Kelli Ireland (CoE), and Tonya Groover (CS), all
  • 09/28/07 Graduate Student Tonya Groover named Entrepreneur of the year by NFTE.
  • 03/27/07 Xin Li's work on Face Alive Icons has been mentioned in the Daniel Mossé was also featured in a recent article that ran in the
  • 03/15/07 Professor Daniel Mossé was recently featured in an Kirk Pruhs has been invited to join the editorial board of
  • 09/17/07 Ahmed Amer discussed his thoughts on the future of CD's in a recent issue of the ADMT Lab<
  • 06/23/10 Michal Valko, CS graduate student, receives the Google Best Paper Award during
  • 04/27/06 After years of networking research, Professor Taieb Znati, has become the NSF Director o
  • 01/30/09 Raja, the Chair of the CS Industry Board was selected as a Prof. Panos K. Chrysanthis: Panos is among the
  • 02/23/11 Wen Xu, CS Graduate student, has been selected to attend CRA-W 2011<
  • 01/15/08 Prof. Chrysanthis and Prof. Labrinidis to participate in Large Synoptic Survey Telescope effort (Pitt News for hi
  • 03/12/09 Ihsan Ayyub Qazi and Swapna Somasundaran, CS graduate students, received the Andrew Mellon Predoctoral Fellowship for the 2009-20
  • 03/20/09 CS Day was a great success!! CS graduate and undergraduate students participated in several competitions and the <
  • 06/12/08 Alex Connor, an undergraduate student and staff member of the ADMT Lab, won the best p
  • 03/17/08 Michal Valko, Qing
  • 08/24/07 Liz Marai
    Dr. Liz Marai joined the Computer Science Departme
  • 06/16/08 Kirk Pruhs, a Professor in our Department is the recipient of a
  • 08/20/04 Daniel Mossé
    Dr. Daniel Mossé became a full Professor in
  • 09/01/09 Assistant Professor Liz Marai and other colleagues in the Center for Simulation and
  • 04/01/10 CAREER: Data-driven Bottom-Up Humanoid Articulations
    Assistant
  • 06/09/09 The Pitt CS Technology Leadership Initiative, TLI , is the recipient of a ACL-IJCNLP 2009<
  • 06/03/09 Undergraduate Heather Friedberg (WiCS undergrad coordinator) was awarded a
  • 09/10/09 Instructor and Graduate Student Jonathan Misurda was recognized by the Center for
  • 11/10/09 Undergraduate Yann Le Gall has been awarded the Arts & Sciences
  • 06/10/09 Kathleen O'Connor, CS staff member, has served four years on the Provost Advisory Committee on Women's Concerns (PACWC). PACWC received the 20
  • 03/25/10 The Pitt CS Technology Leadership Initiative, TLI, has been awarded $7,500 from the
  • 03/19/10 CS Grad students, Michal Valko, John Yackovich, Maio Zhou, Santiago Bock,
  • 03/23/10 Miao Zhou, CS graduate student, received the outstanding paper award for his presen
  • 04/13/10 Amy Scarbrough, Honors College Student and CS Bioinformatics undergraduate, receives the Morr
  • 08/20/04 Sangyeun Paul Cho
    Sangyeun Cho joined the Department of
  • 09/01/09 Rebecca Hwa is promoted to Associate Professor with tenure (effective Sep
  • 06/15/09 Professor Alexandros Labrinidis elected Secretary/Treasurer of ACM SIGMOD to ser
  • 09/24/09 Congratulations to the Faculty and Graduate Students who received awards at the
  • 07/04/08 CAREER: User-Centric Data Management
    Associate Professor
  • 10/09/09 Detecting Deviations in Clinical Care in ICU data Streams
    Asso
  • 02/09/10 Dara Kusic has joined the Department of Computer Science as a 2009-2010 C
  • 03/24/10 Associate Professor Alexandros Labrinidis was quoted in the Pittsburgh Tribune-Review in an article about the Kelli Ireland, a 2009
  • 03/24/10 Assistant Professor Youtao Zhang receives Google award to design course projects for CS2210/CS16
  • 08/02/10 Panos Chrysanthis
    Professor Panos Chrysanthis receives the
    • (default) 88 queries took 32 ms
    NrQueryErrorAffectedNum. rowsTook (ms)
    1SELECT `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 = 122122130
    2SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `name` LIKE 'Top Menu' LIMIT 1110
    3SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (11) ORDER BY `MenuItem`.`position` ASC220
    4SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (11) ORDER BY `Child`.`position` ASC660
    5SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 44110
    6SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 31110
    7SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 52110
    8SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 47110
    9SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 43110
    10SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 36110
    11SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '44' LIMIT 1110
    12SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (44) ORDER BY `MenuItem`.`position` ASC880
    13SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (44) ORDER BY `Child`.`position` ASC110
    14SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 50110
    15SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '50' LIMIT 1110
    16SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (50) ORDER BY `MenuItem`.`position` ASC220
    17SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (50) ORDER BY `Child`.`position` ASC000
    18SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '31' LIMIT 1110
    19SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (31) ORDER BY `MenuItem`.`position` ASC660
    20SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (31) ORDER BY `Child`.`position` ASC000
    21SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '52' LIMIT 1110
    22SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (52) ORDER BY `MenuItem`.`position` ASC220
    23SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (52) ORDER BY `Child`.`position` ASC330
    24SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 54110
    25SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 55110
    26SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 56110
    27SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '54' LIMIT 1110
    28SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (54) ORDER BY `MenuItem`.`position` ASC330
    29SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (54) ORDER BY `Child`.`position` ASC000
    30SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '55' LIMIT 1110
    31SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (55) ORDER BY `MenuItem`.`position` ASC330
    32SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (55) ORDER BY `Child`.`position` ASC000
    33SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '56' LIMIT 1110
    34SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (56) ORDER BY `MenuItem`.`position` ASC330
    35SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (56) ORDER BY `Child`.`position` ASC000
    36SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '47' LIMIT 1110
    37SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (47) ORDER BY `MenuItem`.`position` ASC10100
    38SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (47) ORDER BY `Child`.`position` ASC001
    39SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '43' LIMIT 1110
    40SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (43) ORDER BY `MenuItem`.`position` ASC110
    41SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (43) ORDER BY `Child`.`position` ASC220
    42SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 48110
    43SELECT `ChildMenu`.`id`, `ChildMenu`.`name` FROM `cs_jkl26`.`menus` AS `ChildMenu` WHERE `ChildMenu`.`id` = 51110
    44SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '48' LIMIT 1110
    45SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (48) ORDER BY `MenuItem`.`position` ASC440
    46SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (48) ORDER BY `Child`.`position` ASC000
    47SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '51' LIMIT 1110
    48SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (51) ORDER BY `MenuItem`.`position` ASC660
    49SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (51) ORDER BY `Child`.`position` ASC000
    50SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `Id` LIKE '36' LIMIT 1110
    51SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (36) ORDER BY `MenuItem`.`position` ASC660
    52SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (36) ORDER BY `Child`.`position` ASC000
    53SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE '/News' LIMIT 1000
    54SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'News/index' LIMIT 1001
    55SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`context`, `Menu`.`link`, `Menu`.`created`, `Menu`.`modified` FROM `cs_jkl26`.`menus` AS `Menu` WHERE `context` LIKE 'News' LIMIT 1110
    56SELECT `MenuItem`.`id`, `MenuItem`.`menu_id`, `MenuItem`.`text`, `MenuItem`.`link`, `MenuItem`.`new_window`, `MenuItem`.`position`, `MenuItem`.`created`, `MenuItem`.`modified` FROM `cs_jkl26`.`menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = (48) ORDER BY `MenuItem`.`position` ASC440
    57SELECT `Child`.`id`, `Child`.`position`, `Child`.`child_id`, `Child`.`parent_id` FROM `cs_jkl26`.`submenus` AS `Child` WHERE `Child`.`parent_id` = (48) ORDER BY `Child`.`position` ASC000
    58SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-01' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    59SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-02' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    60SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-03' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    61SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-04' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    62SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-05' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    63SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-06' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    64SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-07' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    65SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-08' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    66SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-09' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    67SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-10' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    68SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-11' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    69SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-12' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    70SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-13' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    71SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-14' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    72SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-15' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    73SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-16' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    74SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-17' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    75SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-18' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    76SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-19' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    77SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-20' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    78SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-21' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    79SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-22' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    80SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-23' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    81SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-24' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    82SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-25' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    83SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-26' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    84SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-27' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    85SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-28' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    86SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-29' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    87SELECT COUNT(*) AS `count` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `Event`.`published` = '1' AND '2024-04-30' BETWEEN date(`Event`.`start_date`) AND date(`Event`.`end_date`)110
    88SELECT `Event`.`id`, `Event`.`title`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`location`, `Event`.`organizer_name`, `Event`.`organizer_email`, `Event`.`speaker_name`, `Event`.`speaker_affiliation`, `Event`.`speaker_bio`, `Event`.`abstract`, `Event`.`description`, `Event`.`committee`, `Event`.`note1`, `Event`.`note2`, `Event`.`note3`, `Event`.`twitter`, `Event`.`image`, `Event`.`attachment`, `Event`.`published`, `Event`.`event_template_id`, `Event`.`person_id`, `Event`.`modifier_id`, `Event`.`created`, `Event`.`modified`, `Modifier`.`id`, `Modifier`.`objectguid`, `Modifier`.`samaccountname`, `Modifier`.`cssdsamaccountname`, `Modifier`.`useraccountcontrol`, `Modifier`.`memberof`, `Modifier`.`userprincipalname`, `Modifier`.`distinguishedname`, `Modifier`.`displayname`, `Modifier`.`givenname`, `Modifier`.`sn`, `Modifier`.`mail`, `Modifier`.`physicaldeliveryofficename`, `Modifier`.`postofficebox`, `Modifier`.`telephonenumber`, `Modifier`.`title`, `Modifier`.`homepage`, `Modifier`.`bio`, `Modifier`.`pendingHomepage`, `Modifier`.`pendingBio`, `Modifier`.`created`, `Modifier`.`modified`, `Person`.`id`, `Person`.`objectguid`, `Person`.`samaccountname`, `Person`.`cssdsamaccountname`, `Person`.`useraccountcontrol`, `Person`.`memberof`, `Person`.`userprincipalname`, `Person`.`distinguishedname`, `Person`.`displayname`, `Person`.`givenname`, `Person`.`sn`, `Person`.`mail`, `Person`.`physicaldeliveryofficename`, `Person`.`postofficebox`, `Person`.`telephonenumber`, `Person`.`title`, `Person`.`homepage`, `Person`.`bio`, `Person`.`pendingHomepage`, `Person`.`pendingBio`, `Person`.`created`, `Person`.`modified`, `EventTemplate`.`id`, `EventTemplate`.`name`, `EventTemplate`.`fields`, `EventTemplate`.`color`, `EventTemplate`.`created`, `EventTemplate`.`modified` FROM `cs_jkl26`.`events` AS `Event` LEFT JOIN `cs_jkl26`.`people` AS `Modifier` ON (`Event`.`modifier_id` = `Modifier`.`id`) LEFT JOIN `cs_jkl26`.`people` AS `Person` ON (`Event`.`person_id` = `Person`.`id`) LEFT JOIN `cs_jkl26`.`event_templates` AS `EventTemplate` ON (`Event`.`event_template_id` = `EventTemplate`.`id`) WHERE `published` = '1' LIMIT 3330