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 (2004,1981,1978,1982,1976,1980,1946,1986,1979,1947,1949,1975,1983,1984,1968,1977,1967,1948,1985,1971) ORDER BYv0_.date_visiteDESC,p1_.property_nameASC;