| 1 |
1.10 ms |
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 = ? 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 = ?
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 = '564' LIMIT 1;
|
| 2 |
17.66 ms |
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 = ?
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 = '564' ORDER BY e0_.ordering ASC;
|
| 3 |
3.96 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role = ? ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role = ?
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role = 2 ORDER BY i1_.sname ASC;
|
| 4 |
1.31 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role = ? ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role = ?
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role = 3 ORDER BY i1_.sname ASC;
|
| 5 |
12.37 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role = ? ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role = ?
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role = 4 ORDER BY i1_.sname ASC;
|
| 6 |
3.51 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role = ? ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role = ?
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role = 5 ORDER BY i1_.sname ASC;
|
| 7 |
2.61 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role = ? ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role = ?
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role = 6 ORDER BY i1_.sname ASC;
|
| 8 |
7.94 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role = ? ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role = ?
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role = 7 ORDER BY i1_.sname ASC;
|
| 9 |
2.78 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role = ? ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role = ?
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role = 8 ORDER BY i1_.sname ASC;
|
| 10 |
2.38 ms |
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = ? AND e0_.status IN (0, 1) AND e0_.id_role IS NULL ORDER BY i1_.sname ASC
SELECT
e0_.id_role AS id_role_0,
e0_.id_ind AS id_ind_1,
e0_.status AS status_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,
i1_.fax AS fax_8,
i1_.addr_1 AS addr_1_9,
i1_.addr_2 AS addr_2_10,
i1_.city AS city_11,
i1_.state AS state_12,
i1_.postcode AS postcode_13,
i1_.jobtitle AS jobtitle_14,
i1_.email1 AS email1_15,
i1_.email2 AS email2_16,
c2_.country_code AS country_code_17,
c2_.country AS country_18,
i3_.inst_name AS inst_name_19,
i3_.inst_name_eng AS inst_name_eng_20,
i1_.dept AS dept_21,
i3_.inst_address AS inst_address_22,
i3_.addr_2 AS addr_2_23,
i3_.city AS city_24,
i3_.state AS state_25,
i3_.postcode AS postcode_26,
c4_.country_code AS country_code_27,
c4_.country AS country_28,
e5_.role AS role_29,
e5_.ordering AS ordering_30
FROM
event_participants e0_
LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind)
LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind)
LEFT JOIN countries c2_ ON (
c2_.id_country = i1_.country_code
)
LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst)
LEFT JOIN countries c4_ ON (
c4_.id_country = i3_.country_code
)
LEFT JOIN event_participantroles e5_ ON (
e0_.id_role = e5_.id_role
AND e0_.id_event = e5_.id_event
)
WHERE
e0_.id_event = ?
AND e0_.status IN (0, 1)
AND e0_.id_role IS NULL
ORDER BY
i1_.sname ASC
SELECT e0_.id_role AS id_role_0, e0_.id_ind AS id_ind_1, e0_.status AS status_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, i1_.fax AS fax_8, i1_.addr_1 AS addr_1_9, i1_.addr_2 AS addr_2_10, i1_.city AS city_11, i1_.state AS state_12, i1_.postcode AS postcode_13, i1_.jobtitle AS jobtitle_14, i1_.email1 AS email1_15, i1_.email2 AS email2_16, c2_.country_code AS country_code_17, c2_.country AS country_18, i3_.inst_name AS inst_name_19, i3_.inst_name_eng AS inst_name_eng_20, i1_.dept AS dept_21, i3_.inst_address AS inst_address_22, i3_.addr_2 AS addr_2_23, i3_.city AS city_24, i3_.state AS state_25, i3_.postcode AS postcode_26, c4_.country_code AS country_code_27, c4_.country AS country_28, e5_.role AS role_29, e5_.ordering AS ordering_30 FROM event_participants e0_ LEFT JOIN indiv i1_ ON (i1_.id_ind = e0_.id_ind) LEFT JOIN indiv_institution i6_ ON (i6_.id_ind = i1_.id_ind) LEFT JOIN countries c2_ ON (c2_.id_country = i1_.country_code) LEFT JOIN institutions i3_ ON (i3_.id_inst = i6_.id_inst) LEFT JOIN countries c4_ ON (c4_.id_country = i3_.country_code) LEFT JOIN event_participantroles e5_ ON (e0_.id_role = e5_.id_role AND e0_.id_event = e5_.id_event) WHERE e0_.id_event = '564' AND e0_.status IN (0, 1) AND e0_.id_role IS NULL ORDER BY i1_.sname ASC;
|