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 = '126' 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 = 3 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 = '126' LIMIT 1;

SELECT 
  t0.country AS country_1, 
  t0.postcode_pos AS postcode_pos_2, 
  t0.postcode_spacer AS postcode_spacer_3, 
  t0.country_code AS country_code_4, 
  t0.latitude AS latitude_5, 
  t0.longitude AS longitude_6, 
  t0.id_country AS id_country_7 
FROM 
  countries t0 
WHERE 
  t0.id_country = ? 
LIMIT 
  1

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.id_country AS id_country_7 FROM countries t0 WHERE t0.id_country = 114 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 = '126' 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 = '126' 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 = '126' 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 = '126' LIMIT 1;

SELECT 
  e0_.id_agendaitem AS id_agendaitem_0, 
  e0_.id AS id_1, 
  e0_.title AS title_2, 
  e0_.parent_idevent AS parent_idevent_3, 
  e0_.agenda_order AS agenda_order_4, 
  e0_.notes AS notes_5, 
  e0_.required_actions AS required_actions_6 
FROM 
  event_agendaitems e0_ 
WHERE 
  e0_.id_event = ? 
ORDER BY 
  e0_.agenda_order ASC

SELECT e0_.id_agendaitem AS id_agendaitem_0, e0_.id AS id_1, e0_.title AS title_2, e0_.parent_idevent AS parent_idevent_3, e0_.agenda_order AS agenda_order_4, e0_.notes AS notes_5, e0_.required_actions AS required_actions_6 FROM event_agendaitems e0_ WHERE e0_.id_event = '126' ORDER BY e0_.agenda_order ASC;

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.14';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.15';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.2';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.3';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.4';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.5';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.6';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.7';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.8';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '10.9';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '2';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '2.1';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '2.2';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '2.3';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '2.4';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '2.5';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '3';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '3.1';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '3.2';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '3.3';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '3.4';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '3.5';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '4';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '4.1';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '4.2';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '4.3';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '4.4';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.1';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.2';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.3';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.4';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.5';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.6';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.7';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '5.8';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '6';

SELECT 
  d0_.title AS title_0, 
  d0_.id_doc AS id_doc_1, 
  d0_.doc_code AS doc_code_2 
FROM 
  agendaitem_documents a1_ 
  LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) 
WHERE 
  a1_.id_event = ? 
  AND a1_.id_agendaitem = ?

SELECT d0_.title AS title_0, d0_.id_doc AS id_doc_1, d0_.doc_code AS doc_code_2 FROM agendaitem_documents a1_ LEFT JOIN documents d0_ ON (d0_.id_doc = a1_.id_doc) WHERE a1_.id_event = '126' AND a1_.id_agendaitem = '6.1';