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 (674,687,677,688,678,689,679,686,682,684,675,690,681,673,685,680,671,672,691,666) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;