Symfony Profiler

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  event e0_
  LEFT JOIN event_offsite_lecture e1_ ON e0_.id = e1_.id
  LEFT JOIN conference c2_ ON e0_.id = c2_.id
  LEFT JOIN lecture l3_ ON e0_.id = l3_.id
WHERE
  (
    (
      e0_.dtype IN (
        'offsitelecture', 'conference', 'lecture',
        'event'
      )
      AND NOT e0_.dtype IN ('lecture')
      AND NOT e0_.dtype IN ('offsitelecture')
    )
  )
  AND e0_.public = 1
  AND e0_.dtype IN ('conference')
  AND e0_.start >= ?
  AND e0_.start <= ?

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN event_offsite_lecture e1_ ON e0_.id = e1_.id LEFT JOIN conference c2_ ON e0_.id = c2_.id LEFT JOIN lecture l3_ ON e0_.id = l3_.id WHERE ((e0_.dtype IN ('offsitelecture', 'conference', 'lecture', 'event') AND NOT e0_.dtype IN ('lecture') AND NOT e0_.dtype IN ('offsitelecture'))) AND e0_.public = 1 AND e0_.dtype IN ('conference') AND e0_.start >= '2026-03-04 00:00:00' AND e0_.start <= '2026-05-03 00:00:00';

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.start AS start_1
FROM
  event e0_
  LEFT JOIN event_offsite_lecture e1_ ON e0_.id = e1_.id
  LEFT JOIN conference c2_ ON e0_.id = c2_.id
  LEFT JOIN lecture l3_ ON e0_.id = l3_.id
WHERE
  (
    (
      e0_.dtype IN (
        'offsitelecture', 'conference', 'lecture',
        'event'
      )
      AND NOT e0_.dtype IN ('lecture')
      AND NOT e0_.dtype IN ('offsitelecture')
    )
  )
  AND e0_.public = 1
  AND e0_.dtype IN ('conference')
  AND e0_.start >= ?
  AND e0_.start <= ?
ORDER BY
  e0_.start DESC
LIMIT
  50

SELECT DISTINCT e0_.id AS id_0, e0_.start AS start_1 FROM event e0_ LEFT JOIN event_offsite_lecture e1_ ON e0_.id = e1_.id LEFT JOIN conference c2_ ON e0_.id = c2_.id LEFT JOIN lecture l3_ ON e0_.id = l3_.id WHERE ((e0_.dtype IN ('offsitelecture', 'conference', 'lecture', 'event') AND NOT e0_.dtype IN ('lecture') AND NOT e0_.dtype IN ('offsitelecture'))) AND e0_.public = 1 AND e0_.dtype IN ('conference') AND e0_.start >= '2026-03-04 00:00:00' AND e0_.start <= '2026-05-03 00:00:00' ORDER BY e0_.start DESC LIMIT 50;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.description AS description_2,
  e0_.location AS location_3,
  e0_.notes AS notes_4,
  e0_.start AS start_5,
  e0_.duration AS duration_6,
  e0_.public AS public_7,
  e0_.created AS created_8,
  e0_.created_by AS created_by_9,
  e0_.updated AS updated_10,
  e0_.updated_by AS updated_by_11,
  e1_.expiration AS expiration_12,
  e1_.redirect_term AS redirect_term_13,
  c2_.active AS active_14,
  l3_.objectives AS objectives_15,
  l3_.grandrounds AS grandrounds_16,
  l3_.financial_interest AS financial_interest_17,
  l3_.attendance_flag AS attendance_flag_18,
  l3_.video_url AS video_url_19,
  l3_.video_url_livestream AS video_url_livestream_20,
  l3_.audience_faculty AS audience_faculty_21,
  l3_.audience_resident AS audience_resident_22,
  l3_.audience_student AS audience_student_23,
  l3_.attendance_required AS attendance_required_24,
  l3_.credit_time AS credit_time_25,
  l3_.faculty_extra AS faculty_extra_26,
  e0_.dtype AS dtype_27,
  e0_.event_location_id AS event_location_id_28,
  l3_.conference_id AS conference_id_29,
  l3_.category_id AS category_id_30
FROM
  event e0_
  LEFT JOIN event_offsite_lecture e1_ ON e0_.id = e1_.id
  LEFT JOIN conference c2_ ON e0_.id = c2_.id
  LEFT JOIN lecture l3_ ON e0_.id = l3_.id
WHERE
  (
    (
      e0_.dtype IN (
        'offsitelecture', 'conference', 'lecture',
        'event'
      )
      AND NOT e0_.dtype IN ('lecture')
      AND NOT e0_.dtype IN ('offsitelecture')
    )
  )
  AND e0_.public = 1
  AND e0_.dtype IN ('conference')
  AND e0_.start >= ?
  AND e0_.start <= ?
  AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  e0_.start DESC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.location AS location_3, e0_.notes AS notes_4, e0_.start AS start_5, e0_.duration AS duration_6, e0_.public AS public_7, e0_.created AS created_8, e0_.created_by AS created_by_9, e0_.updated AS updated_10, e0_.updated_by AS updated_by_11, e1_.expiration AS expiration_12, e1_.redirect_term AS redirect_term_13, c2_.active AS active_14, l3_.objectives AS objectives_15, l3_.grandrounds AS grandrounds_16, l3_.financial_interest AS financial_interest_17, l3_.attendance_flag AS attendance_flag_18, l3_.video_url AS video_url_19, l3_.video_url_livestream AS video_url_livestream_20, l3_.audience_faculty AS audience_faculty_21, l3_.audience_resident AS audience_resident_22, l3_.audience_student AS audience_student_23, l3_.attendance_required AS attendance_required_24, l3_.credit_time AS credit_time_25, l3_.faculty_extra AS faculty_extra_26, e0_.dtype AS dtype_27, e0_.event_location_id AS event_location_id_28, l3_.conference_id AS conference_id_29, l3_.category_id AS category_id_30 FROM event e0_ LEFT JOIN event_offsite_lecture e1_ ON e0_.id = e1_.id LEFT JOIN conference c2_ ON e0_.id = c2_.id LEFT JOIN lecture l3_ ON e0_.id = l3_.id WHERE ((e0_.dtype IN ('offsitelecture', 'conference', 'lecture', 'event') AND NOT e0_.dtype IN ('lecture') AND NOT e0_.dtype IN ('offsitelecture'))) AND e0_.public = 1 AND e0_.dtype IN ('conference') AND e0_.start >= '2026-03-04 00:00:00' AND e0_.start <= '2026-05-03 00:00:00' AND e0_.id IN (7693, 7687, 7681, 7675, 7669, 7663, 7657, 7651, 7645) ORDER BY e0_.start DESC;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.active AS active_2
FROM
  lecture_category l0_
ORDER BY
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.active AS active_2 FROM lecture_category l0_ ORDER BY l0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7693;

SELECT
  t1.id AS id_2,
  t1.title AS title_3,
  t1.description AS description_4,
  t1.location AS location_5,
  t1.notes AS notes_6,
  t1.start AS start_7,
  t1.duration AS duration_8,
  t1.public AS public_9,
  t1.created AS created_10,
  t1.created_by AS created_by_11,
  t1.updated AS updated_12,
  t1.updated_by AS updated_by_13,
  t0.objectives AS objectives_14,
  t0.grandrounds AS grandrounds_15,
  t0.financial_interest AS financial_interest_16,
  t0.attendance_flag AS attendance_flag_17,
  t0.video_url AS video_url_18,
  t0.video_url_livestream AS video_url_livestream_19,
  t0.audience_faculty AS audience_faculty_20,
  t0.audience_resident AS audience_resident_21,
  t0.audience_student AS audience_student_22,
  t0.attendance_required AS attendance_required_23,
  t0.credit_time AS credit_time_24,
  t0.faculty_extra AS faculty_extra_25,
  t1.event_location_id AS event_location_id_26,
  t0.conference_id AS conference_id_27,
  t0.category_id AS category_id_28,
  t1.dtype
FROM
  lecture t0
  INNER JOIN event t1 ON t0.id = t1.id
WHERE
  t0.conference_id = ?
ORDER BY
  t1.start ASC

SELECT t1.id AS id_2, t1.title AS title_3, t1.description AS description_4, t1.location AS location_5, t1.notes AS notes_6, t1.start AS start_7, t1.duration AS duration_8, t1.public AS public_9, t1.created AS created_10, t1.created_by AS created_by_11, t1.updated AS updated_12, t1.updated_by AS updated_by_13, t0.objectives AS objectives_14, t0.grandrounds AS grandrounds_15, t0.financial_interest AS financial_interest_16, t0.attendance_flag AS attendance_flag_17, t0.video_url AS video_url_18, t0.video_url_livestream AS video_url_livestream_19, t0.audience_faculty AS audience_faculty_20, t0.audience_resident AS audience_resident_21, t0.audience_student AS audience_student_22, t0.attendance_required AS attendance_required_23, t0.credit_time AS credit_time_24, t0.faculty_extra AS faculty_extra_25, t1.event_location_id AS event_location_id_26, t0.conference_id AS conference_id_27, t0.category_id AS category_id_28, t1.dtype FROM lecture t0 INNER JOIN event t1 ON t0.id = t1.id WHERE t0.conference_id = 7693 ORDER BY t1.start ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7694;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7695;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7696;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7697;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7698;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7694;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institution AS institution_3,
  t0.lecture_id AS lecture_id_4,
  t0.employee_id AS employee_id_5
FROM
  lecture_speaker t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institution AS institution_3, t0.lecture_id AS lecture_id_4, t0.employee_id AS employee_id_5 FROM lecture_speaker t0 WHERE t0.lecture_id = 7694;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7695;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institution AS institution_3,
  t0.lecture_id AS lecture_id_4,
  t0.employee_id AS employee_id_5
FROM
  lecture_speaker t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institution AS institution_3, t0.lecture_id AS lecture_id_4, t0.employee_id AS employee_id_5 FROM lecture_speaker t0 WHERE t0.lecture_id = 7695;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7696;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institution AS institution_3,
  t0.lecture_id AS lecture_id_4,
  t0.employee_id AS employee_id_5
FROM
  lecture_speaker t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institution AS institution_3, t0.lecture_id AS lecture_id_4, t0.employee_id AS employee_id_5 FROM lecture_speaker t0 WHERE t0.lecture_id = 7696;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7697;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institution AS institution_3,
  t0.lecture_id AS lecture_id_4,
  t0.employee_id AS employee_id_5
FROM
  lecture_speaker t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institution AS institution_3, t0.lecture_id AS lecture_id_4, t0.employee_id AS employee_id_5 FROM lecture_speaker t0 WHERE t0.lecture_id = 7697;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7698;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institution AS institution_3,
  t0.lecture_id AS lecture_id_4,
  t0.employee_id AS employee_id_5
FROM
  lecture_speaker t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institution AS institution_3, t0.lecture_id AS lecture_id_4, t0.employee_id AS employee_id_5 FROM lecture_speaker t0 WHERE t0.lecture_id = 7698;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7687;

SELECT
  t1.id AS id_2,
  t1.title AS title_3,
  t1.description AS description_4,
  t1.location AS location_5,
  t1.notes AS notes_6,
  t1.start AS start_7,
  t1.duration AS duration_8,
  t1.public AS public_9,
  t1.created AS created_10,
  t1.created_by AS created_by_11,
  t1.updated AS updated_12,
  t1.updated_by AS updated_by_13,
  t0.objectives AS objectives_14,
  t0.grandrounds AS grandrounds_15,
  t0.financial_interest AS financial_interest_16,
  t0.attendance_flag AS attendance_flag_17,
  t0.video_url AS video_url_18,
  t0.video_url_livestream AS video_url_livestream_19,
  t0.audience_faculty AS audience_faculty_20,
  t0.audience_resident AS audience_resident_21,
  t0.audience_student AS audience_student_22,
  t0.attendance_required AS attendance_required_23,
  t0.credit_time AS credit_time_24,
  t0.faculty_extra AS faculty_extra_25,
  t1.event_location_id AS event_location_id_26,
  t0.conference_id AS conference_id_27,
  t0.category_id AS category_id_28,
  t1.dtype
FROM
  lecture t0
  INNER JOIN event t1 ON t0.id = t1.id
WHERE
  t0.conference_id = ?
ORDER BY
  t1.start ASC

SELECT t1.id AS id_2, t1.title AS title_3, t1.description AS description_4, t1.location AS location_5, t1.notes AS notes_6, t1.start AS start_7, t1.duration AS duration_8, t1.public AS public_9, t1.created AS created_10, t1.created_by AS created_by_11, t1.updated AS updated_12, t1.updated_by AS updated_by_13, t0.objectives AS objectives_14, t0.grandrounds AS grandrounds_15, t0.financial_interest AS financial_interest_16, t0.attendance_flag AS attendance_flag_17, t0.video_url AS video_url_18, t0.video_url_livestream AS video_url_livestream_19, t0.audience_faculty AS audience_faculty_20, t0.audience_resident AS audience_resident_21, t0.audience_student AS audience_student_22, t0.attendance_required AS attendance_required_23, t0.credit_time AS credit_time_24, t0.faculty_extra AS faculty_extra_25, t1.event_location_id AS event_location_id_26, t0.conference_id AS conference_id_27, t0.category_id AS category_id_28, t1.dtype FROM lecture t0 INNER JOIN event t1 ON t0.id = t1.id WHERE t0.conference_id = 7687 ORDER BY t1.start ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7691;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7688;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7689;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7690;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7692;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7691;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institution AS institution_3,
  t0.lecture_id AS lecture_id_4,
  t0.employee_id AS employee_id_5
FROM
  lecture_speaker t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institution AS institution_3, t0.lecture_id AS lecture_id_4, t0.employee_id AS employee_id_5 FROM lecture_speaker t0 WHERE t0.lecture_id = 7691;