| SELECT DISTINCT c.event_id ,c.event_date,c.day_num, c.event_name,event_type,c.path,c.teacher_id , v.venue_name, v.address_1,v.postcode, v.venue_id,t.teacher_name, v.latitude,v.longitude , round(((acos(sin((51.4433*pi()/180)) * sin((v.latitude*pi()/180))+cos((51.4433*pi()/180)) * cos((v.latitude*pi()/180)) * cos(((-0.1553- v.longitude)*pi()/180))))*180/pi())*60*1.1515*1.609344,1) as distance FROM venue as v , events c, teacher t WHERE c.event_name<>'' and (c.isDeleted=0 or c.isDeleted is null or c.isDeleted is null) AND v.venue_id = c.venue_id AND t.teacher_id = c.teacher_id AND ( c.event_date >= '2013-05-25' OR c.event_end_date >= '2013-05-25') And c.Festival=1 ORDER BY event_date asc, c.premium desc, v.VENUE_NAME, c.rating_sum desc |
