SELECTv0_.idASid_0,v0_.date_visiteASdate_visite_1,v0_.uuidASuuid_2,v0_.client_uuidASclient_uuid_3,v0_.commentaireAScommentaire_4,v0_.main_consultantASmain_consultant_5,p1_.idASid_6,p1_.property_nameASproperty_name_7,p1_.communeAScommune_8,p1_.surface_totaleASsurface_totale_9,p1_.contract_nameAScontract_name_10,p1_.adresse_1ASadresse_1_11,p1_.adresse_2ASadresse_2_12,p1_.code_postalAScode_postal_13,v0_.property_idASproperty_id_14,p1_.departement_idASdepartement_id_15,p1_.main_consultant_idASmain_consultant_id_16FROMvisitev0_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,v0_.main_consultantASmain_consultant_5,p1_.idASid_6,p1_.property_nameASproperty_name_7,p1_.communeAScommune_8,p1_.surface_totaleASsurface_totale_9,p1_.contract_nameAScontract_name_10,p1_.adresse_1ASadresse_1_11,p1_.adresse_2ASadresse_2_12,p1_.code_postalAScode_postal_13,v0_.property_idASproperty_id_14,p1_.departement_idASdepartement_id_15,p1_.main_consultant_idASmain_consultant_id_16FROMvisitev0_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,v0_.main_consultantASmain_consultant_5,p1_.idASid_6,p1_.property_nameASproperty_name_7,p1_.communeAScommune_8,p1_.surface_totaleASsurface_totale_9,p1_.contract_nameAScontract_name_10,p1_.adresse_1ASadresse_1_11,p1_.adresse_2ASadresse_2_12,p1_.code_postalAScode_postal_13,v0_.property_idASproperty_id_14,p1_.departement_idASdepartement_id_15,p1_.main_consultant_idASmain_consultant_id_16FROMvisitev0_LEFT JOINpropertyp1_ONv0_.property_id=p1_.idWHEREv0_.idIN (6593,6590,6579,6587,6609,6591,6597,6578,6577,6589,6576,6575,6574,6588,6573,6592,6595,6572,6571,6598) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;