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 (3606,3609,3620,3601,3608,3637,3602,3638,3619,3607,3621,3603,3610,3613,3604,3690,4001,3588,3589,3594) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;