select equipement0_.LIEUFK as LIEUFK3_1_0_, equipement0_.id as id1_1_0_, equipement0_.id as id1_1_1_, equipement0_.LIEUFK as LIEUFK3_1_1_, equipement0_.SALLEFK as SALLEFK4_1_1_, equipement0_.type as type2_1_1_, salle1_.id as id1_0_2_, salle1_.codeUserToCreate as codeUser2_0_2_, salle1_.codeUserToUpdate as codeUser3_0_2_, salle1_.dateCreaEnr as dateCrea4_0_2_, salle1_.dateModifEnr as dateModi5_0_2_, salle1_.temoinEnService as temoinEn6_0_2_, salle1_.lieu_id as lieu_id2_3_2_, salle1_.type as type1_3_2_, lieu2_.id as id1_0_3_, lieu2_.codeUserToCreate as codeUser2_0_3_, lieu2_.codeUserToUpdate as codeUser3_0_3_, lieu2_.dateCreaEnr as dateCrea4_0_3_, lieu2_.dateModifEnr as dateModi5_0_3_, lieu2_.temoinEnService as temoinEn6_0_3_ from Equipement equipement0_ inner join Salle salle1_ on equipement0_.SALLEFK=salle1_.id inner join Lieu lieu2_ on salle1_.lieu_id=lieu2_.id where equipement0_.LIEUFK=?