1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
Hibernate:
select responsesc0_.check_lists_id as check_li4_6_0_,
responsesc0_.id_responsescheck as id_respo1_6_0_,
responsesc0_.id_responsescheck as id_respo1_6_1_,
responsesc0_.check_lists_id as check_li4_6_1_,
responsesc0_.missions_id as missions5_6_1_,
responsesc0_.conformite as conformi2_6_1_,
responsesc0_.date_response as date_res3_6_1_,
missions1_.id_mission as id_missi1_5_2_,
missions1_.date_debut as date_deb2_5_2_,
missions1_.date_fin as date_fin3_5_2_,
missions1_.description as descript4_5_2_,
missions1_.etat_mission as etat_mis5_5_2_,
missions1_.nom_mission as nom_miss6_5_2_,
missions1_.societe_id as societe_7_5_2_,
societeaud2_.id_societe as id_socie1_8_3_,
societeaud2_.date_ajout_societe as date_ajo2_8_3_,
societeaud2_.adresse as adresse3_8_3_,
societeaud2_.logo as logo4_8_3_,
societeaud2_.mail_contact as mail_con5_8_3_,
societeaud2_.nom_societe as nom_soci6_8_3_,
societeaud2_.responsable_securite as responsa7_8_3_,
societeaud2_.secteur as secteur8_8_3_,
societeaud2_.tel_responsable as tel_resp9_8_3_,
societeaud2_.tel_societe as tel_soc10_8_3_
from responses_check_lists responsesc0_
left outer join missions missions1_
on responsesc0_.missions_id=missions1_.id_mission
left outer join societe_auditee societeaud2_
on missions1_.societe_id=societeaud2_.id_societe
where responsesc0_.check_lists_id=? |
Partager