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 (7538,7522,7526,7539,7541,7529,7530,7490,7531,7537,7523,7525,7532,7543,7533,7527,7492,7524,7540,7536) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;