不正
select c.id as id ,c.name as name ,c.spot as spot ,c.category as category ,c.term_st as term_st ,c.term_ed as term_ed ,c.link as link ,c.linkcaption as linkcaption ,c.outline1 as outline1 ,c.outline1caption as outline1caption ,c.outline2 as outline2 ,c.outline2caption as outline2caption ,c.entry1 as entry1 ,c.entry1caption as entry1caption ,c.entry2 as entry2 ,c.entry2caption as entry2caption ,c.entry3 as entry3 ,c.entry3caption as entry3caption ,c.timetable as timetable ,c.result as result ,c.resultcaption as resultcaption ,tr.cnt as cnt_trk ,re.cnt as cnt_rel ,hi.cnt as cnt_hig ,ln.cnt as cnt_lng ,ro.cnt as cnt_rod ,de.cnt as cnt_dec ,ek.cnt as cnt_eki from (((((((tm_competition c left join (select competition_code,count(id) as cnt from tt_result_trk where status = 1 group by competition_code) tr on c.code = tr.competition_code) left join (select competition_code,count(id) as cnt from tt_result_rel where status = 1 group by competition_code) re on c.code = re.competition_code) left join (select competition_code,count(id) as cnt from tt_result_hig where status = 1 group by competition_code) hi on c.code = hi.competition_code) left join (select competition_code,count(id) as cnt from tt_result_lng where status = 1 group by competition_code) ln on c.code = ln.competition_code) left join (select competition_code,count(id) as cnt from tt_result_rod where status = 1 group by competition_code) ro on c.code = ro.competition_code) left join (select competition_code,count(id) as cnt from tt_result_dec where status = 1 group by competition_code) de on c.code = de.competition_code) left join (select competition_code,count(id) as cnt from tt_result_eki where status = 1 group by competition_code) ek on c.code = ek.competition_code) where c.status = 1 and c.term_st <= '-0001-12-31' and c.term_ed >= '-0001-12-01' order by c.category,c.showorder desc
競技会日程｜ 一般財団法人福井陸上競技協会 福井県の陸上競技大会日程、開催要項、タイムテーブル、申込み、速報、記録検索
