SELECTv0_.idASid_0,v0_.date_visiteASdate_visite_1,v0_.uuidASuuid_2,v0_.client_uuidASclient_uuid_3,v0_.commentaireAScommentaire_4,p1_.idASid_5,p1_.property_nameASproperty_name_6,p1_.communeAScommune_7,p1_.surface_totaleASsurface_totale_8,p1_.contract_nameAScontract_name_9,p1_.adresse_1ASadresse_1_10,p1_.adresse_2ASadresse_2_11,p1_.code_postalAScode_postal_12,v0_.property_idASproperty_id_13,p1_.departement_idASdepartement_id_14FROMvisitev0_LEFT JOINpropertyp1_ONv0_.property_id=p1_.idWHEREv0_.idIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC
SELECTv0_.idASid_0,v0_.date_visiteASdate_visite_1,v0_.uuidASuuid_2,v0_.client_uuidASclient_uuid_3,v0_.commentaireAScommentaire_4,p1_.idASid_5,p1_.property_nameASproperty_name_6,p1_.communeAScommune_7,p1_.surface_totaleASsurface_totale_8,p1_.contract_nameAScontract_name_9,p1_.adresse_1ASadresse_1_10,p1_.adresse_2ASadresse_2_11,p1_.code_postalAScode_postal_12,v0_.property_idASproperty_id_13,p1_.departement_idASdepartement_id_14FROMvisitev0_LEFT JOINpropertyp1_ONv0_.property_id=p1_.idWHEREv0_.idIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
ORDER BYv0_.date_visiteDESC,p1_.property_nameASC
SELECTv0_.idASid_0,v0_.date_visiteASdate_visite_1,v0_.uuidASuuid_2,v0_.client_uuidASclient_uuid_3,v0_.commentaireAScommentaire_4,p1_.idASid_5,p1_.property_nameASproperty_name_6,p1_.communeAScommune_7,p1_.surface_totaleASsurface_totale_8,p1_.contract_nameAScontract_name_9,p1_.adresse_1ASadresse_1_10,p1_.adresse_2ASadresse_2_11,p1_.code_postalAScode_postal_12,v0_.property_idASproperty_id_13,p1_.departement_idASdepartement_id_14FROMvisitev0_LEFT JOINpropertyp1_ONv0_.property_id=p1_.idWHEREv0_.idIN (14,21,15,32,9,26,24,25,22,13,8,10,28,3,4,1353,1,56) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;