[selectRecords]
select
	 v.hakken_kbn
	,v.hakken_kbn_nm
	,v.furyo_kbn
	,v.furyo_kbn_nm
	,v.furyo_uti_kbn
	,v.furyo_uti_kbn_nm
	,coalesce(１月,'0') as １月
	,coalesce(２月,'0') as ２月
	,coalesce(３月,'0') as ３月
	,coalesce(４月,'0') as ４月
	,coalesce(５月,'0') as ５月
	,coalesce(６月,'0') as ６月
	,coalesce(７月,'0') as ７月
	,coalesce(８月,'0') as ８月
	,coalesce(９月,'0') as ９月
	,coalesce(１０月,'0') as １０月
	,coalesce(１１月,'0') as １１月
	,coalesce(１２月,'0') as １２月
	,coalesce(合計,'0') as 合計
	,substr(fnc_get_furyo_ymd('201712', 1),1,4)||'/'||substr(fnc_get_furyo_ymd('201712', 1),5,2)||'/'||substr(fnc_get_furyo_ymd('201712', 1),7,2) ||'〜'||substr(fnc_get_furyo_ymd('201712', 2),1,4)||'/'||substr(fnc_get_furyo_ymd('201712', 2),5,2)||'/'||substr(fnc_get_furyo_ymd('201712', 2),7,2)  as sitei_ymd
from v_geppo_title v
left join (
	select
		disc_kbn,
		furyo_kbn,
		furyo_uti_kbn,
		count(case 
			when substr(hasei_ymd,5,2) = '01' then furyo_uti_kbn
		end) as １月,
		count(case 
			when substr(hasei_ymd,5,2) = '02' then furyo_uti_kbn
		end) as ２月,
		count(case 
			when substr(hasei_ymd,5,2) = '03' then furyo_uti_kbn
		end) as ３月,
		count(case 
			when substr(hasei_ymd,5,2) = '04' then furyo_uti_kbn
		end) as ４月,
		count(case 
			when substr(hasei_ymd,5,2) = '05' then furyo_uti_kbn
		end) as ５月,
		count(case 
			when substr(hasei_ymd,5,2) = '06' then furyo_uti_kbn
		end) as ６月,
		count(case 
			when substr(hasei_ymd,5,2) = '07' then furyo_uti_kbn
		end) as ７月,
		count(case 
			when substr(hasei_ymd,5,2) = '08' then furyo_uti_kbn
		end) as ８月,
		count(case 
			when substr(hasei_ymd,5,2) = '09' then furyo_uti_kbn
		end) as ９月,
		count(case 
			when substr(hasei_ymd,5,2) = '10' then furyo_uti_kbn
		end) as １０月,
		count(case 
			when substr(hasei_ymd,5,2) = '11' then furyo_uti_kbn
		end) as １１月,
		count(case 
			when substr(hasei_ymd,5,2) = '12' then furyo_uti_kbn
		end) as １２月,
		count(*) as 合計
	from t_furyo f
	where 1 = 1
	and hasei_ymd >= fnc_get_furyo_ymd('&1', 1) 
	and hasei_ymd <= fnc_get_furyo_ymd('&1', 2) 
	group by  disc_kbn,furyo_kbn,furyo_uti_kbn
) s on (hakken_kbn = s.disc_kbn and v.furyo_kbn =s.furyo_kbn and v.furyo_uti_kbn = s.furyo_uti_kbn)
where 1=1
order by v.hakken_kbn,v.furyo_kbn,v.furyo_uti_kbn