Symfony Profiler

SELECT
  t0.id_eventtype AS id_eventtype_1,
  t0.title AS title_2,
  t0.shorttitle AS shorttitle_3,
  t0.summary AS summary_4,
  t0.start_on AS start_on_5,
  t0.end_on AS end_on_6,
  t0.address AS address_7,
  t0.city AS city_8,
  t0.state AS state_9,
  t0.postcode AS postcode_10,
  t0.id_country AS id_country_11,
  t0.id_inst AS id_inst_12,
  t0.use_inst_addr AS use_inst_addr_13,
  t0.notes AS notes_14,
  t0.website AS website_15,
  t0.redirect_website AS redirect_website_16,
  t0.keywords AS keywords_17,
  t0.created_by AS created_by_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.last_edit_by AS last_edit_by_21,
  t0.is_public AS is_public_22,
  t0.is_open AS is_open_23,
  t0.show_travel AS show_travel_24,
  t0.email_people AS email_people_25,
  t0.id_contact AS id_contact_26,
  t0.reg_online AS reg_online_27,
  t0.status AS status_28,
  t0.id_event AS id_event_29
FROM
  events t0
WHERE
  t0.id_event = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id_eventtype AS id_eventtype_1, t0.title AS title_2, t0.shorttitle AS shorttitle_3, t0.summary AS summary_4, t0.start_on AS start_on_5, t0.end_on AS end_on_6, t0.address AS address_7, t0.city AS city_8, t0.state AS state_9, t0.postcode AS postcode_10, t0.id_country AS id_country_11, t0.id_inst AS id_inst_12, t0.use_inst_addr AS use_inst_addr_13, t0.notes AS notes_14, t0.website AS website_15, t0.redirect_website AS redirect_website_16, t0.keywords AS keywords_17, t0.created_by AS created_by_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.last_edit_by AS last_edit_by_21, t0.is_public AS is_public_22, t0.is_open AS is_open_23, t0.show_travel AS show_travel_24, t0.email_people AS email_people_25, t0.id_contact AS id_contact_26, t0.reg_online AS reg_online_27, t0.status AS status_28, t0.id_event AS id_event_29 FROM events t0 WHERE t0.id_event = '4861' AND t0.status = 1 LIMIT 1;

SELECT
  t0.eventtype_name AS eventtype_name_1,
  t0.id_eventtype AS id_eventtype_2
FROM
  eventtypes t0
WHERE
  t0.id_eventtype = ?
LIMIT
  1

SELECT t0.eventtype_name AS eventtype_name_1, t0.id_eventtype AS id_eventtype_2 FROM eventtypes t0 WHERE t0.id_eventtype = 4 LIMIT 1;

SELECT
  t0.id_event AS id_event_1,
  t0.filename AS filename_2,
  t0.type AS type_3,
  t0.path AS path_4,
  t0.created_by AS created_by_5,
  t0.created_at AS created_at_6,
  t0.deleted AS deleted_7,
  t0.id AS id_8
FROM
  event_files t0
WHERE
  t0.id_event = ?
LIMIT
  1

SELECT t0.id_event AS id_event_1, t0.filename AS filename_2, t0.type AS type_3, t0.path AS path_4, t0.created_by AS created_by_5, t0.created_at AS created_at_6, t0.deleted AS deleted_7, t0.id AS id_8 FROM event_files t0 WHERE t0.id_event = '4861' LIMIT 1;

SELECT
  i0_.id_ind AS id_ind_0,
  i0_.title AS title_1,
  i0_.fname AS fname_2,
  i0_.sname AS sname_3
FROM
  event_contacts e1_
  LEFT JOIN indiv i0_ ON (i0_.id_ind = e1_.id_ind)
WHERE
  e1_.id_event = ?
  AND i0_.sname IS NOT NULL
ORDER BY
  i0_.sname ASC

SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.sname AS sname_3 FROM event_contacts e1_ LEFT JOIN indiv i0_ ON (i0_.id_ind = e1_.id_ind) WHERE e1_.id_event = '4861' AND i0_.sname IS NOT NULL ORDER BY i0_.sname ASC;

SELECT
  i0_.id_ind AS id_ind_0,
  i0_.title AS title_1,
  i0_.fname AS fname_2,
  i0_.sname AS sname_3
FROM
  event_staff e1_
  LEFT JOIN indiv i0_ ON (i0_.id_ind = e1_.id_ind)
WHERE
  e1_.id_event = ?
ORDER BY
  i0_.sname ASC

SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.sname AS sname_3 FROM event_staff e1_ LEFT JOIN indiv i0_ ON (i0_.id_ind = e1_.id_ind) WHERE e1_.id_event = '4861' ORDER BY i0_.sname ASC;

SELECT
  count(e0_.id_ind) AS sclr_0,
  e0_.status AS status_1
FROM
  event_participants e0_
WHERE
  e0_.id_event = ?
GROUP BY
  e0_.status

SELECT count(e0_.id_ind) AS sclr_0, e0_.status AS status_1 FROM event_participants e0_ WHERE e0_.id_event = '4861' GROUP BY e0_.status;

SELECT
  t0.id_event AS id_event_1,
  t0.id_agendaitem AS id_agendaitem_2,
  t0.title AS title_3,
  t0.parent_idevent AS parent_idevent_4,
  t0.notes AS notes_5,
  t0.required_actions AS required_actions_6,
  t0.agenda_order AS agenda_order_7,
  t0.id AS id_8
FROM
  event_agendaitems t0
WHERE
  t0.id_event = ?
LIMIT
  1

SELECT t0.id_event AS id_event_1, t0.id_agendaitem AS id_agendaitem_2, t0.title AS title_3, t0.parent_idevent AS parent_idevent_4, t0.notes AS notes_5, t0.required_actions AS required_actions_6, t0.agenda_order AS agenda_order_7, t0.id AS id_8 FROM event_agendaitems t0 WHERE t0.id_event = '4861' LIMIT 1;

SELECT
  a0_.id_agendaitem AS id_agendaitem_0,
  d1_.doc_code AS doc_code_1,
  d1_.title AS title_2,
  d1_.id_doc AS id_doc_3,
  d1_.author_text AS author_text_4,
  d1_.updated_at AS updated_at_5
FROM
  agendaitem_documents a0_
  LEFT JOIN documents d1_ ON (d1_.id_doc = a0_.id_doc)
WHERE
  a0_.id_event = ?
ORDER BY
  a0_.id_agendaitem ASC

SELECT a0_.id_agendaitem AS id_agendaitem_0, d1_.doc_code AS doc_code_1, d1_.title AS title_2, d1_.id_doc AS id_doc_3, d1_.author_text AS author_text_4, d1_.updated_at AS updated_at_5 FROM agendaitem_documents a0_ LEFT JOIN documents d1_ ON (d1_.id_doc = a0_.id_doc) WHERE a0_.id_event = '4861' ORDER BY a0_.id_agendaitem ASC;

SELECT
  e0_.id_agendaitem AS id_agendaitem_0,
  d1_.doc_code AS doc_code_1,
  d1_.title AS title_2,
  d1_.id_doc AS id_doc_3,
  d1_.author_text AS author_text_4,
  d1_.updated_at AS updated_at_5
FROM
  event_presentations e0_
  LEFT JOIN documents d1_ ON (d1_.id_doc = e0_.id_doc)
WHERE
  e0_.id_event = ?
ORDER BY
  e0_.id_agendaitem ASC

SELECT e0_.id_agendaitem AS id_agendaitem_0, d1_.doc_code AS doc_code_1, d1_.title AS title_2, d1_.id_doc AS id_doc_3, d1_.author_text AS author_text_4, d1_.updated_at AS updated_at_5 FROM event_presentations e0_ LEFT JOIN documents d1_ ON (d1_.id_doc = e0_.id_doc) WHERE e0_.id_event = '4861' ORDER BY e0_.id_agendaitem ASC;

SELECT
  d0_.doc_code AS doc_code_0,
  d0_.title AS title_1,
  d0_.id_doc AS id_doc_2,
  d0_.author_text AS author_text_3,
  d0_.updated_at AS updated_at_4,
  e1_.id_agendaitem AS id_agendaitem_5
FROM
  event_backgrounddocs e1_
  LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc)
WHERE
  e1_.id_event = ?
ORDER BY
  e1_.id_agendaitem ASC

SELECT d0_.doc_code AS doc_code_0, d0_.title AS title_1, d0_.id_doc AS id_doc_2, d0_.author_text AS author_text_3, d0_.updated_at AS updated_at_4, e1_.id_agendaitem AS id_agendaitem_5 FROM event_backgrounddocs e1_ LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc) WHERE e1_.id_event = 4861 ORDER BY e1_.id_agendaitem ASC;

SELECT
  d0_.doc_code AS doc_code_0,
  d0_.title AS title_1,
  d0_.id_doc AS id_doc_2,
  d0_.author_text AS author_text_3,
  d0_.updated_at AS updated_at_4
FROM
  event_otherdocs e1_
  LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc)
WHERE
  e1_.id_event = ?
ORDER BY
  e1_.ordering ASC

SELECT d0_.doc_code AS doc_code_0, d0_.title AS title_1, d0_.id_doc AS id_doc_2, d0_.author_text AS author_text_3, d0_.updated_at AS updated_at_4 FROM event_otherdocs e1_ LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc) WHERE e1_.id_event = '4861' ORDER BY e1_.ordering ASC;

SELECT
  d0_.doc_code AS doc_code_0,
  d0_.title AS title_1,
  d0_.id_doc AS id_doc_2,
  d0_.author_text AS author_text_3,
  d0_.updated_at AS updated_at_4
FROM
  event_reports e1_
  LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc)
WHERE
  e1_.id_event = ?

SELECT d0_.doc_code AS doc_code_0, d0_.title AS title_1, d0_.id_doc AS id_doc_2, d0_.author_text AS author_text_3, d0_.updated_at AS updated_at_4 FROM event_reports e1_ LEFT JOIN documents d0_ ON (d0_.id_doc = e1_.id_doc) WHERE e1_.id_event = '4861';

SELECT
  e0_.id_role AS id_role_0,
  e0_.id_ind AS id_ind_1,
  i1_.id_ind AS id_ind_2,
  i1_.title AS title_3,
  i1_.fname AS fname_4,
  i1_.sname AS sname_5,
  i1_.tel AS tel_6,
  e2_.role AS role_7,
  i1_.use_inst_addr AS use_inst_addr_8,
  c3_.country AS country_9,
  e2_.role AS role_10,
  e2_.ordering AS ordering_11,
  e0_.status AS status_12,
  e0_.accommodation AS accommodation_13,
  i1_.tel AS tel_14
FROM
  event_participants e0_
  LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
  LEFT JOIN countries c3_ ON (
    c3_.id_country = i1_.country_code
  )
  LEFT JOIN event_participantroles e2_ ON (
    e0_.id_role = e2_.id_role
    AND e0_.id_event = e2_.id_event
  )
WHERE
  e0_.id_event = ?
ORDER BY
  e2_.ordering ASC,
  i1_.sname ASC

SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.tel AS tel_6, e2_.role AS role_7, i1_.use_inst_addr AS use_inst_addr_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = '4861' ORDER BY e2_.ordering ASC, i1_.sname ASC;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 22853;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 61670;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 83038;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 81321;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 22940;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 44354;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 85435;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 79698;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 36124;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 58944;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 79352;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 85199;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 66668;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 58961;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 78981;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 85332;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 85313;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 84620;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 54652;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 83844;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 82819;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 84284;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 80319;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 81942;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 83910;

SELECT
  e0_.role AS role_0,
  e0_.id_role AS id_role_1,
  e0_.ppt_ordering AS ppt_ordering_2
FROM
  event_participantroles e0_
WHERE
  e0_.id_event = ?
ORDER BY
  e0_.ordering ASC

SELECT e0_.role AS role_0, e0_.id_role AS id_role_1, e0_.ppt_ordering AS ppt_ordering_2 FROM event_participantroles e0_ WHERE e0_.id_event = '4861' ORDER BY e0_.ordering ASC;

SELECT
  e0_.id_role AS id_role_0,
  e0_.id_ind AS id_ind_1,
  i1_.id_ind AS id_ind_2,
  i1_.title AS title_3,
  i1_.fname AS fname_4,
  i1_.sname AS sname_5,
  i1_.use_inst_addr AS use_inst_addr_6,
  i1_.tel AS tel_7,
  e2_.role AS role_8,
  c3_.country AS country_9,
  e2_.role AS role_10,
  e2_.ordering AS ordering_11,
  e0_.status AS status_12,
  e0_.accommodation AS accommodation_13,
  i1_.tel AS tel_14
FROM
  event_participants e0_
  LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
  LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind)
  LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst)
  LEFT JOIN countries c3_ ON (
    c3_.id_country = i1_.country_code
  )
  LEFT JOIN event_participantroles e2_ ON (
    e0_.id_role = e2_.id_role
    AND e0_.id_event = e2_.id_event
  )
WHERE
  e0_.id_event = ?
  AND e0_.id_role = ?
ORDER BY
  i1_.sname ASC

SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, i1_.id_ind AS id_ind_2, i1_.title AS title_3, i1_.fname AS fname_4, i1_.sname AS sname_5, i1_.use_inst_addr AS use_inst_addr_6, i1_.tel AS tel_7, e2_.role AS role_8, c3_.country AS country_9, e2_.role AS role_10, e2_.ordering AS ordering_11, e0_.status AS status_12, e0_.accommodation AS accommodation_13, i1_.tel AS tel_14 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i4_ ON (i4_.id_ind = i1_.id_ind) LEFT JOIN institutions i5_ ON (i5_.id_inst = i4_.id_inst) LEFT JOIN countries c3_ ON (c3_.id_country = i1_.country_code) LEFT JOIN event_participantroles e2_ ON (e0_.id_role = e2_.id_role AND e0_.id_event = e2_.id_event) WHERE e0_.id_event = '4861' AND e0_.id_role = 1 ORDER BY i1_.sname ASC;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 22853;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 61670;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 83038;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 81321;

SELECT
  c0_.country AS country_0
FROM
  countries c0_
  LEFT JOIN institutions i1_ ON (
    c0_.id_country = i1_.country_code
  )
  LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst)
WHERE
  i2_.id_ind = ?

SELECT c0_.country AS country_0 FROM countries c0_ LEFT JOIN institutions i1_ ON (c0_.id_country = i1_.country_code) LEFT JOIN indiv_institution i2_ ON (i2_.id_inst = i1_.id_inst) WHERE i2_.id_ind = 22940;