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 (747,717,729,732,712,714,730,713,727,719,725,721,715,724,726,718,723,710,720,716) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;