Disordered XY model: Effective medium theory and beyond