SELECT tdpr.id, tdpr.type_nom, tdpr.site_agency, tdpr.SITE, ta.site_agency, ta.city FROM `dvf`.`prixm2_rues_final` tdpr,`nestenn_local`.`agency` ta WHERE tdpr.type_nom like 'avenue diesse' AND tdpr.insee=ta.code_INSEE AND tdpr.id!=1108738 AND tdpr.site_agency=ta.site_agency ORDER BY tdpr.donnees DESC LIMIT 0,10