Copyright (c) 2009 UK Salsa Festival. All rights reserved
Design and Developed by: KDM- Web Design Company
SELECT DISTINCT t.city,t.path,teacher,promoter,performer,musician,other,manager,t.teacher_name ,t.TEACHER_EMAIL,t.teacher_id,t.Username, t.latitude,t.longitude , round(((acos(sin((51.4433*pi()/180)) * sin((t.latitude*pi()/180))+cos((51.4433*pi()/180)) * cos((t.latitude*pi()/180)) * cos(((-0.1553- t.longitude)*pi()/180))))*180/pi())*60*1.1515*1.609344,1) as distance FROM teacher t WHERE t.teacher_name<>'' AND t.IsDeleted<>1 HAVING distance <='10' ORDER BY distance