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 (1541,1529,1545,1544,1538,1542,1534,1532,1535,1527,1530,1531,1548,1533,1549,1547,1543,1539,1528,1524) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;