| 1 |
1.17 ms |
SELECT t0.id AS id_5, t0.uuid AS uuid_6, t0.id_apl AS id_apl_7, t0.started_at AS started_at_8, t0.updated_at AS updated_at_9, t0.close_at AS close_at_10, t0.status AS status_11, t0.current_step AS current_step_12, t0.title AS title_13, t0.last_name AS last_name_14, t0.first_name AS first_name_15, t0.nationality AS nationality_16, t0.nationality2 AS nationality2_17, t0.birthdate AS birthdate_18, t0.gender AS gender_19, t0.address AS address_20, t0.zipcode AS zipcode_21, t0.city AS city_22, t0.country AS country_23, t0.website AS website_24, t0.synchro AS synchro_25, t0.user_id AS user_id_26, t0.type, t1.knowledge_question AS knowledge_question_27, t1.current_studies AS current_studies_28, t1.current_institut AS current_institut_29, t1.pursuit_studies AS pursuit_studies_30, t1.grades AS grades_31, t1.recommendation_emails AS recommendation_emails_32, t1.master_type_id AS master_type_id_33, t1.master_theme_id AS master_theme_id_34, t1.master_spe1_id AS master_spe1_id_35, t1.master_spe2_id AS master_spe2_id_36, t1.master_spe3_id AS master_spe3_id_37, t1.knownfrom_id AS knownfrom_id_38, t2.project AS project_39, t2.recommendation_emails AS recommendation_emails_40, t2.duration AS duration_41, t2.duration2 AS duration2_42, t2.duration_comment AS duration_comment_43, t2.contact AS contact_44, t2.labo_id AS labo_id_45, t2.mscmain_id AS mscmain_id_46, t2.mscsec1_id AS mscsec1_id_47, t2.mscsec2_id AS mscsec2_id_48, t2.mscsec3_id AS mscsec3_id_49, t3.duration AS duration_50, t3.correspondent AS correspondent_51, t3.project AS project_52, t3.thesis_title AS thesis_title_53, t3.thesis_advisor AS thesis_advisor_54, t3.thesis_date AS thesis_date_55, t3.thesis_institution AS thesis_institution_56, t3.recommendation_emails AS recommendation_emails_57, t3.labo_id AS labo_id_58, t3.mscmain_id AS mscmain_id_59, t3.mscsec1_id AS mscsec1_id_60, t3.mscsec2_id AS mscsec2_id_61, t3.mscsec3_id AS mscsec3_id_62, t3.knownfrom_id AS knownfrom_id_63, t4.request_type AS request_type_64, t4.applicant_research_topic AS applicant_research_topic_65, t4.stay_start_date AS stay_start_date_66, t4.stay_end_date AS stay_end_date_67, t4.stay_period AS stay_period_68, t4.stay_duration AS stay_duration_69, t4.carbon_footprint AS carbon_footprint_70, t4.guest_last_name AS guest_last_name_71, t4.guest_first_name AS guest_first_name_72, t4.guest_university AS guest_university_73, t4.guest_research_topic AS guest_research_topic_74, t4.guest_email AS guest_email_75, t4.thesis_director_last_name AS thesis_director_last_name_76, t4.thesis_director_email AS thesis_director_email_77, t4.host_last_name AS host_last_name_78, t4.host_first_name AS host_first_name_79, t4.host_laboratory AS host_laboratory_80, t4.host_university AS host_university_81, t4.host_country AS host_country_82, t4.host_email AS host_email_83, t4.request_description AS request_description_84, t4.applicant_laboratory_id AS applicant_laboratory_id_85, t4.applicant_university_id AS applicant_university_id_86 FROM application t0 LEFT JOIN application_master t1 ON t0.id = t1.id LEFT JOIN application_chair t2 ON t0.id = t2.id LEFT JOIN application_post_doc t3 ON t0.id = t3.id LEFT JOIN application_funding t4 ON t0.id = t4.id WHERE t0.status = ? AND t0.synchro = ?
Parameters: [
"COMPLETED"
0
]
SELECT
t0.id AS id_5,
t0.uuid AS uuid_6,
t0.id_apl AS id_apl_7,
t0.started_at AS started_at_8,
t0.updated_at AS updated_at_9,
t0.close_at AS close_at_10,
t0.status AS status_11,
t0.current_step AS current_step_12,
t0.title AS title_13,
t0.last_name AS last_name_14,
t0.first_name AS first_name_15,
t0.nationality AS nationality_16,
t0.nationality2 AS nationality2_17,
t0.birthdate AS birthdate_18,
t0.gender AS gender_19,
t0.address AS address_20,
t0.zipcode AS zipcode_21,
t0.city AS city_22,
t0.country AS country_23,
t0.website AS website_24,
t0.synchro AS synchro_25,
t0.user_id AS user_id_26,
t0.type,
t1.knowledge_question AS knowledge_question_27,
t1.current_studies AS current_studies_28,
t1.current_institut AS current_institut_29,
t1.pursuit_studies AS pursuit_studies_30,
t1.grades AS grades_31,
t1.recommendation_emails AS recommendation_emails_32,
t1.master_type_id AS master_type_id_33,
t1.master_theme_id AS master_theme_id_34,
t1.master_spe1_id AS master_spe1_id_35,
t1.master_spe2_id AS master_spe2_id_36,
t1.master_spe3_id AS master_spe3_id_37,
t1.knownfrom_id AS knownfrom_id_38,
t2.project AS project_39,
t2.recommendation_emails AS recommendation_emails_40,
t2.duration AS duration_41,
t2.duration2 AS duration2_42,
t2.duration_comment AS duration_comment_43,
t2.contact AS contact_44,
t2.labo_id AS labo_id_45,
t2.mscmain_id AS mscmain_id_46,
t2.mscsec1_id AS mscsec1_id_47,
t2.mscsec2_id AS mscsec2_id_48,
t2.mscsec3_id AS mscsec3_id_49,
t3.duration AS duration_50,
t3.correspondent AS correspondent_51,
t3.project AS project_52,
t3.thesis_title AS thesis_title_53,
t3.thesis_advisor AS thesis_advisor_54,
t3.thesis_date AS thesis_date_55,
t3.thesis_institution AS thesis_institution_56,
t3.recommendation_emails AS recommendation_emails_57,
t3.labo_id AS labo_id_58,
t3.mscmain_id AS mscmain_id_59,
t3.mscsec1_id AS mscsec1_id_60,
t3.mscsec2_id AS mscsec2_id_61,
t3.mscsec3_id AS mscsec3_id_62,
t3.knownfrom_id AS knownfrom_id_63,
t4.request_type AS request_type_64,
t4.applicant_research_topic AS applicant_research_topic_65,
t4.stay_start_date AS stay_start_date_66,
t4.stay_end_date AS stay_end_date_67,
t4.stay_period AS stay_period_68,
t4.stay_duration AS stay_duration_69,
t4.carbon_footprint AS carbon_footprint_70,
t4.guest_last_name AS guest_last_name_71,
t4.guest_first_name AS guest_first_name_72,
t4.guest_university AS guest_university_73,
t4.guest_research_topic AS guest_research_topic_74,
t4.guest_email AS guest_email_75,
t4.thesis_director_last_name AS thesis_director_last_name_76,
t4.thesis_director_email AS thesis_director_email_77,
t4.host_last_name AS host_last_name_78,
t4.host_first_name AS host_first_name_79,
t4.host_laboratory AS host_laboratory_80,
t4.host_university AS host_university_81,
t4.host_country AS host_country_82,
t4.host_email AS host_email_83,
t4.request_description AS request_description_84,
t4.applicant_laboratory_id AS applicant_laboratory_id_85,
t4.applicant_university_id AS applicant_university_id_86
FROM
application t0
LEFT JOIN application_master t1 ON t0.id = t1.id
LEFT JOIN application_chair t2 ON t0.id = t2.id
LEFT JOIN application_post_doc t3 ON t0.id = t3.id
LEFT JOIN application_funding t4 ON t0.id = t4.id
WHERE
t0.status = ?
AND t0.synchro = ?
SELECT t0.id AS id_5, t0.uuid AS uuid_6, t0.id_apl AS id_apl_7, t0.started_at AS started_at_8, t0.updated_at AS updated_at_9, t0.close_at AS close_at_10, t0.status AS status_11, t0.current_step AS current_step_12, t0.title AS title_13, t0.last_name AS last_name_14, t0.first_name AS first_name_15, t0.nationality AS nationality_16, t0.nationality2 AS nationality2_17, t0.birthdate AS birthdate_18, t0.gender AS gender_19, t0.address AS address_20, t0.zipcode AS zipcode_21, t0.city AS city_22, t0.country AS country_23, t0.website AS website_24, t0.synchro AS synchro_25, t0.user_id AS user_id_26, t0.type, t1.knowledge_question AS knowledge_question_27, t1.current_studies AS current_studies_28, t1.current_institut AS current_institut_29, t1.pursuit_studies AS pursuit_studies_30, t1.grades AS grades_31, t1.recommendation_emails AS recommendation_emails_32, t1.master_type_id AS master_type_id_33, t1.master_theme_id AS master_theme_id_34, t1.master_spe1_id AS master_spe1_id_35, t1.master_spe2_id AS master_spe2_id_36, t1.master_spe3_id AS master_spe3_id_37, t1.knownfrom_id AS knownfrom_id_38, t2.project AS project_39, t2.recommendation_emails AS recommendation_emails_40, t2.duration AS duration_41, t2.duration2 AS duration2_42, t2.duration_comment AS duration_comment_43, t2.contact AS contact_44, t2.labo_id AS labo_id_45, t2.mscmain_id AS mscmain_id_46, t2.mscsec1_id AS mscsec1_id_47, t2.mscsec2_id AS mscsec2_id_48, t2.mscsec3_id AS mscsec3_id_49, t3.duration AS duration_50, t3.correspondent AS correspondent_51, t3.project AS project_52, t3.thesis_title AS thesis_title_53, t3.thesis_advisor AS thesis_advisor_54, t3.thesis_date AS thesis_date_55, t3.thesis_institution AS thesis_institution_56, t3.recommendation_emails AS recommendation_emails_57, t3.labo_id AS labo_id_58, t3.mscmain_id AS mscmain_id_59, t3.mscsec1_id AS mscsec1_id_60, t3.mscsec2_id AS mscsec2_id_61, t3.mscsec3_id AS mscsec3_id_62, t3.knownfrom_id AS knownfrom_id_63, t4.request_type AS request_type_64, t4.applicant_research_topic AS applicant_research_topic_65, t4.stay_start_date AS stay_start_date_66, t4.stay_end_date AS stay_end_date_67, t4.stay_period AS stay_period_68, t4.stay_duration AS stay_duration_69, t4.carbon_footprint AS carbon_footprint_70, t4.guest_last_name AS guest_last_name_71, t4.guest_first_name AS guest_first_name_72, t4.guest_university AS guest_university_73, t4.guest_research_topic AS guest_research_topic_74, t4.guest_email AS guest_email_75, t4.thesis_director_last_name AS thesis_director_last_name_76, t4.thesis_director_email AS thesis_director_email_77, t4.host_last_name AS host_last_name_78, t4.host_first_name AS host_first_name_79, t4.host_laboratory AS host_laboratory_80, t4.host_university AS host_university_81, t4.host_country AS host_country_82, t4.host_email AS host_email_83, t4.request_description AS request_description_84, t4.applicant_laboratory_id AS applicant_laboratory_id_85, t4.applicant_university_id AS applicant_university_id_86 FROM application t0 LEFT JOIN application_master t1 ON t0.id = t1.id LEFT JOIN application_chair t2 ON t0.id = t2.id LEFT JOIN application_post_doc t3 ON t0.id = t3.id LEFT JOIN application_funding t4 ON t0.id = t4.id WHERE t0.status = 'COMPLETED' AND t0.synchro = 0;
|