|
|
|
|
|
| SELECT DISTINCT c.event_id as id , c.event_name as name,c.event_type,c.day_num as dayNum,c.event_date as recentDt,c.teacher_id,c.path , 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 v.venue_id = c.venue_id AND t.teacher_id = c.teacher_id AND c.event_date = '2012-02-05' HAVING distance <='20' union SELECT DISTINCT c.clubday_id as id,c.club_day_name as name,d.day,c.day_num as dayNum, c.last_checked as recentDt,c.teacher_id,c.path , 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 , club_day c, teacher t, day d, ClassTeachers ct WHERE v.venue_id = c.venue_id AND t.teacher_id = c.teacher_id AND d.day_num = c.day_num AND c.isDeleted<>1 AND c.suspend = 0 AND c.day_num = 7 HAVING distance <='20' |
