Symfony Profiler

SELECT
  t0.identifier AS identifier_1,
  t0.provider AS provider_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.pec AS pec_5,
  t0.cellular AS cellular_6,
  t0.fiscal_code AS fiscal_code_7,
  t0.password AS password_8,
  t0.last_access AS last_access_9,
  t0.is_user_suspended AS is_user_suspended_10,
  t0.id AS id_11,
  t0.active AS active_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.person_id AS person_id_16,
  t0.last_operating_institution_id AS last_operating_institution_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.identifier AS identifier_1, t0.provider AS provider_2, t0.username AS username_3, t0.email AS email_4, t0.pec AS pec_5, t0.cellular AS cellular_6, t0.fiscal_code AS fiscal_code_7, t0.password AS password_8, t0.last_access AS last_access_9, t0.is_user_suspended AS is_user_suspended_10, t0.id AS id_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.person_id AS person_id_16, t0.last_operating_institution_id AS last_operating_institution_id_17 FROM user t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.label AS label_4
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.fiscal_code AS fiscal_code_4,
  t0.birth_date AS birth_date_5,
  t0.gender AS gender_6,
  t0.residence_address AS residence_address_7,
  t0.residence_address_number AS residence_address_number_8,
  t0.residence_address_zip AS residence_address_zip_9,
  t0.foreign_city AS foreign_city_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t14.identifier AS identifier_15,
  t14.provider AS provider_16,
  t14.username AS username_17,
  t14.email AS email_18,
  t14.pec AS pec_19,
  t14.cellular AS cellular_20,
  t14.fiscal_code AS fiscal_code_21,
  t14.password AS password_22,
  t14.last_access AS last_access_23,
  t14.is_user_suspended AS is_user_suspended_24,
  t14.id AS id_25,
  t14.active AS active_26,
  t14.created_at AS created_at_27,
  t14.updated_at AS updated_at_28,
  t14.deleted_at AS deleted_at_29,
  t14.person_id AS person_id_30,
  t14.last_operating_institution_id AS last_operating_institution_id_31,
  t0.birth_nation_id AS birth_nation_id_32,
  t0.birth_city_id AS birth_city_id_33,
  t0.residence_city_id AS residence_city_id_34,
  t0.residence_province_id AS residence_province_id_35,
  t0.residence_nation_id AS residence_nation_id_36,
  t37.signature_certificate_expires_on AS signature_certificate_expires_on_38,
  t37.signature_kit_notification_level AS signature_kit_notification_level_39,
  t37.id AS id_40,
  t37.active AS active_41,
  t37.created_at AS created_at_42,
  t37.updated_at AS updated_at_43,
  t37.deleted_at AS deleted_at_44,
  t37.person_id AS person_id_45,
  t37.signature_certifier_id AS signature_certifier_id_46
FROM
  persons t0
  LEFT JOIN user t14 ON t14.person_id = t0.id
  LEFT JOIN legal_owner t37 ON t37.person_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.fiscal_code AS fiscal_code_4, t0.birth_date AS birth_date_5, t0.gender AS gender_6, t0.residence_address AS residence_address_7, t0.residence_address_number AS residence_address_number_8, t0.residence_address_zip AS residence_address_zip_9, t0.foreign_city AS foreign_city_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t14.identifier AS identifier_15, t14.provider AS provider_16, t14.username AS username_17, t14.email AS email_18, t14.pec AS pec_19, t14.cellular AS cellular_20, t14.fiscal_code AS fiscal_code_21, t14.password AS password_22, t14.last_access AS last_access_23, t14.is_user_suspended AS is_user_suspended_24, t14.id AS id_25, t14.active AS active_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.deleted_at AS deleted_at_29, t14.person_id AS person_id_30, t14.last_operating_institution_id AS last_operating_institution_id_31, t0.birth_nation_id AS birth_nation_id_32, t0.birth_city_id AS birth_city_id_33, t0.residence_city_id AS residence_city_id_34, t0.residence_province_id AS residence_province_id_35, t0.residence_nation_id AS residence_nation_id_36, t37.signature_certificate_expires_on AS signature_certificate_expires_on_38, t37.signature_kit_notification_level AS signature_kit_notification_level_39, t37.id AS id_40, t37.active AS active_41, t37.created_at AS created_at_42, t37.updated_at AS updated_at_43, t37.deleted_at AS deleted_at_44, t37.person_id AS person_id_45, t37.signature_certifier_id AS signature_certifier_id_46 FROM persons t0 LEFT JOIN user t14 ON t14.person_id = t0.id LEFT JOIN legal_owner t37 ON t37.person_id = t0.id WHERE t0.id = 15;

SELECT
  t0.name AS name_1,
  t0.tax_code AS tax_code_2,
  t0.fiscal_code AS fiscal_code_3,
  t0.pec_address AS pec_address_4,
  t0.email_address AS email_address_5,
  t0.telephone AS telephone_6,
  t0.telephone_mobile AS telephone_mobile_7,
  t0.operating AS operating_8,
  t0.status AS status_9,
  t0.id AS id_10,
  t0.active AS active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.legal_form_id AS legal_form_id_15,
  t0.institution_size_id AS institution_size_id_16,
  t0.ateco_code_version_id AS ateco_code_version_id_17,
  t0.legal_owner_id AS legal_owner_id_18
FROM
  institutions t0
WHERE
  t0.legal_owner_id = ?

SELECT t0.name AS name_1, t0.tax_code AS tax_code_2, t0.fiscal_code AS fiscal_code_3, t0.pec_address AS pec_address_4, t0.email_address AS email_address_5, t0.telephone AS telephone_6, t0.telephone_mobile AS telephone_mobile_7, t0.operating AS operating_8, t0.status AS status_9, t0.id AS id_10, t0.active AS active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.legal_form_id AS legal_form_id_15, t0.institution_size_id AS institution_size_id_16, t0.ateco_code_version_id AS ateco_code_version_id_17, t0.legal_owner_id AS legal_owner_id_18 FROM institutions t0 WHERE t0.legal_owner_id = 1;

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.institution_id IN (?)

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.institution_id IN (2);

SELECT
  t0.context AS context_1,
  t0.id AS id_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.institution_type_id AS institution_type_id_7,
  t0.institution_id AS institution_id_8,
  t9.status AS status_10,
  t9.request_type AS request_type_11,
  t9.code AS code_12,
  t9.accreditation_type AS accreditation_type_13,
  t9.score AS score_14,
  t9.send_at AS send_at_15,
  t9.determina_completed_at AS determina_completed_at_16,
  t9.accreditation_end_date AS accreditation_end_date_17,
  t9.renewal_notification_level AS renewal_notification_level_18,
  t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19,
  t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20,
  t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21,
  t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22,
  t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23,
  t9.id AS id_24,
  t9.active AS active_25,
  t9.created_at AS created_at_26,
  t9.updated_at AS updated_at_27,
  t9.deleted_at AS deleted_at_28,
  t9.institution_id AS institution_id_29,
  t9.legal_owner_id AS legal_owner_id_30,
  t9.institution_typology_id AS institution_typology_id_31,
  t9.parent_application_id AS parent_application_id_32
FROM
  institutions_accreditation_type t0
  LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id
WHERE
  t0.institution_id IN (?)

SELECT t0.context AS context_1, t0.id AS id_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.institution_type_id AS institution_type_id_7, t0.institution_id AS institution_id_8, t9.status AS status_10, t9.request_type AS request_type_11, t9.code AS code_12, t9.accreditation_type AS accreditation_type_13, t9.score AS score_14, t9.send_at AS send_at_15, t9.determina_completed_at AS determina_completed_at_16, t9.accreditation_end_date AS accreditation_end_date_17, t9.renewal_notification_level AS renewal_notification_level_18, t9.viewed_by_instructor_l1 AS viewed_by_instructor_l1_19, t9.viewed_by_instructor_l2 AS viewed_by_instructor_l2_20, t9.viewed_by_instructor_l3 AS viewed_by_instructor_l3_21, t9.assignment_notification2_days_sent AS assignment_notification2_days_sent_22, t9.assignment_notification25_days_sent AS assignment_notification25_days_sent_23, t9.id AS id_24, t9.active AS active_25, t9.created_at AS created_at_26, t9.updated_at AS updated_at_27, t9.deleted_at AS deleted_at_28, t9.institution_id AS institution_id_29, t9.legal_owner_id AS legal_owner_id_30, t9.institution_typology_id AS institution_typology_id_31, t9.parent_application_id AS parent_application_id_32 FROM institutions_accreditation_type t0 LEFT JOIN accreditation_application t9 ON t9.institution_typology_id = t0.id WHERE t0.institution_id IN (2);

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  maintenance_request m0_
WHERE
  m0_.institution_id = ?
  AND m0_.status NOT IN (?, ?, ?)

SELECT COUNT(m0_.id) AS sclr_0 FROM maintenance_request m0_ WHERE m0_.institution_id = 2 AND m0_.status NOT IN ('DETERMINA_COMPLETATA', 'DEFINITIVELY_REJECTED', 'DEFINITIVELY_APPROVED');

SELECT
  a0_.status AS status_0,
  a0_.request_type AS request_type_1,
  a0_.code AS code_2,
  a0_.accreditation_type AS accreditation_type_3,
  a0_.score AS score_4,
  a0_.send_at AS send_at_5,
  a0_.determina_completed_at AS determina_completed_at_6,
  a0_.accreditation_end_date AS accreditation_end_date_7,
  a0_.renewal_notification_level AS renewal_notification_level_8,
  a0_.viewed_by_instructor_l1 AS viewed_by_instructor_l1_9,
  a0_.viewed_by_instructor_l2 AS viewed_by_instructor_l2_10,
  a0_.viewed_by_instructor_l3 AS viewed_by_instructor_l3_11,
  a0_.assignment_notification2_days_sent AS assignment_notification2_days_sent_12,
  a0_.assignment_notification25_days_sent AS assignment_notification25_days_sent_13,
  a0_.id AS id_14,
  a0_.active AS active_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.deleted_at AS deleted_at_18,
  a0_.institution_id AS institution_id_19,
  a0_.legal_owner_id AS legal_owner_id_20,
  a0_.institution_typology_id AS institution_typology_id_21,
  a0_.parent_application_id AS parent_application_id_22
FROM
  accreditation_application a0_
WHERE
  a0_.institution_id = ?
  AND a0_.status = ?
ORDER BY
  a0_.determina_completed_at DESC

SELECT a0_.status AS status_0, a0_.request_type AS request_type_1, a0_.code AS code_2, a0_.accreditation_type AS accreditation_type_3, a0_.score AS score_4, a0_.send_at AS send_at_5, a0_.determina_completed_at AS determina_completed_at_6, a0_.accreditation_end_date AS accreditation_end_date_7, a0_.renewal_notification_level AS renewal_notification_level_8, a0_.viewed_by_instructor_l1 AS viewed_by_instructor_l1_9, a0_.viewed_by_instructor_l2 AS viewed_by_instructor_l2_10, a0_.viewed_by_instructor_l3 AS viewed_by_instructor_l3_11, a0_.assignment_notification2_days_sent AS assignment_notification2_days_sent_12, a0_.assignment_notification25_days_sent AS assignment_notification25_days_sent_13, a0_.id AS id_14, a0_.active AS active_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.deleted_at AS deleted_at_18, a0_.institution_id AS institution_id_19, a0_.legal_owner_id AS legal_owner_id_20, a0_.institution_typology_id AS institution_typology_id_21, a0_.parent_application_id AS parent_application_id_22 FROM accreditation_application a0_ WHERE a0_.institution_id = 2 AND a0_.status = 'DETERMINA_COMPLETATA' ORDER BY a0_.determina_completed_at DESC;

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.parent_application_id = ?

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.parent_application_id = 1;

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.parent_application_id = ?

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.parent_application_id = 3;

SELECT
  t0.status AS status_1,
  t0.request_type AS request_type_2,
  t0.code AS code_3,
  t0.accreditation_type AS accreditation_type_4,
  t0.score AS score_5,
  t0.send_at AS send_at_6,
  t0.determina_completed_at AS determina_completed_at_7,
  t0.accreditation_end_date AS accreditation_end_date_8,
  t0.renewal_notification_level AS renewal_notification_level_9,
  t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10,
  t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11,
  t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12,
  t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13,
  t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14,
  t0.id AS id_15,
  t0.active AS active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t20.id AS id_21,
  t20.active AS active_22,
  t20.created_at AS created_at_23,
  t20.updated_at AS updated_at_24,
  t20.deleted_at AS deleted_at_25,
  t20.accreditation_application_id AS accreditation_application_id_26,
  t20.tipology_id AS tipology_id_27,
  t0.institution_id AS institution_id_28,
  t0.legal_owner_id AS legal_owner_id_29,
  t0.institution_typology_id AS institution_typology_id_30,
  t0.parent_application_id AS parent_application_id_31
FROM
  accreditation_application t0
  LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id
WHERE
  t0.parent_application_id = ?

SELECT t0.status AS status_1, t0.request_type AS request_type_2, t0.code AS code_3, t0.accreditation_type AS accreditation_type_4, t0.score AS score_5, t0.send_at AS send_at_6, t0.determina_completed_at AS determina_completed_at_7, t0.accreditation_end_date AS accreditation_end_date_8, t0.renewal_notification_level AS renewal_notification_level_9, t0.viewed_by_instructor_l1 AS viewed_by_instructor_l1_10, t0.viewed_by_instructor_l2 AS viewed_by_instructor_l2_11, t0.viewed_by_instructor_l3 AS viewed_by_instructor_l3_12, t0.assignment_notification2_days_sent AS assignment_notification2_days_sent_13, t0.assignment_notification25_days_sent AS assignment_notification25_days_sent_14, t0.id AS id_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t20.id AS id_21, t20.active AS active_22, t20.created_at AS created_at_23, t20.updated_at AS updated_at_24, t20.deleted_at AS deleted_at_25, t20.accreditation_application_id AS accreditation_application_id_26, t20.tipology_id AS tipology_id_27, t0.institution_id AS institution_id_28, t0.legal_owner_id AS legal_owner_id_29, t0.institution_typology_id AS institution_typology_id_30, t0.parent_application_id AS parent_application_id_31 FROM accreditation_application t0 LEFT JOIN institutions_accreditation_tipologies t20 ON t20.accreditation_application_id = t0.id WHERE t0.parent_application_id = 5;

SELECT
  a0_.status AS status_0,
  a0_.request_type AS request_type_1,
  a0_.code AS code_2,
  a0_.accreditation_type AS accreditation_type_3,
  a0_.score AS score_4,
  a0_.send_at AS send_at_5,
  a0_.determina_completed_at AS determina_completed_at_6,
  a0_.accreditation_end_date AS accreditation_end_date_7,
  a0_.renewal_notification_level AS renewal_notification_level_8,
  a0_.viewed_by_instructor_l1 AS viewed_by_instructor_l1_9,
  a0_.viewed_by_instructor_l2 AS viewed_by_instructor_l2_10,
  a0_.viewed_by_instructor_l3 AS viewed_by_instructor_l3_11,
  a0_.assignment_notification2_days_sent AS assignment_notification2_days_sent_12,
  a0_.assignment_notification25_days_sent AS assignment_notification25_days_sent_13,
  a0_.id AS id_14,
  a0_.active AS active_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.deleted_at AS deleted_at_18,
  a0_.institution_id AS institution_id_19,
  a0_.legal_owner_id AS legal_owner_id_20,
  a0_.institution_typology_id AS institution_typology_id_21,
  a0_.parent_application_id AS parent_application_id_22
FROM
  accreditation_application a0_
WHERE
  a0_.institution_id = ?
  AND a0_.status = ?
ORDER BY
  a0_.determina_completed_at DESC

SELECT a0_.status AS status_0, a0_.request_type AS request_type_1, a0_.code AS code_2, a0_.accreditation_type AS accreditation_type_3, a0_.score AS score_4, a0_.send_at AS send_at_5, a0_.determina_completed_at AS determina_completed_at_6, a0_.accreditation_end_date AS accreditation_end_date_7, a0_.renewal_notification_level AS renewal_notification_level_8, a0_.viewed_by_instructor_l1 AS viewed_by_instructor_l1_9, a0_.viewed_by_instructor_l2 AS viewed_by_instructor_l2_10, a0_.viewed_by_instructor_l3 AS viewed_by_instructor_l3_11, a0_.assignment_notification2_days_sent AS assignment_notification2_days_sent_12, a0_.assignment_notification25_days_sent AS assignment_notification25_days_sent_13, a0_.id AS id_14, a0_.active AS active_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.deleted_at AS deleted_at_18, a0_.institution_id AS institution_id_19, a0_.legal_owner_id AS legal_owner_id_20, a0_.institution_typology_id AS institution_typology_id_21, a0_.parent_application_id AS parent_application_id_22 FROM accreditation_application a0_ WHERE a0_.institution_id = 2 AND a0_.status = 'DETERMINA_COMPLETATA' ORDER BY a0_.determina_completed_at DESC;