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 (6616,6621,6631,6604,6622,6630,6623,6611,6603,6594,6582,6581,6599,6583,6580,6596,6610,6585,6586,6593) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;