Šablono aptarimas:Fg kom

Naudojamas view:

create view Fgkom as
select x.fed fed, x.uef uef, x.kom_str kom, 
	   case when p._page is null then case when pp._page is null then t._page else pp._page end else p._page end lyg,
	   case when p.met is null then case when pp.met is null then case when t.met is null then case when l.met is null then case when s.met is null then x.uef else s.met end else l.met end else t.met end else pp.met end else p.met end met,
	   case when p.kom is null then case when pp.kom is null then case when t.kom is null then case when l.kom is null then s.kom else l.kom end else t.kom end else pp.kom end else p.kom end pvd,
	   p.tip+1 tip,
	   case when p.tip='0' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta0,
	   case when p.tip='1' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta1,
	   case when p.tip='2' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta2,
	   case when p.tip='3' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta3,
	   case when p.tip='4' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta4,
	   case when p.tip='5' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta5,
	   case when p.tip='6' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta6,
	   case when p.tip='7' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta7,
	   case when p.tip='8' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta8,
	   case when p.tip='9' then concat('[[',p._page,'|',p.vieta,']]') else '' end vta9,
	   case when pp.tip='0' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta0,
	   case when pp.tip='1' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta1,
	   case when pp.tip='2' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta2,
	   case when pp.tip='3' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta3,
	   case when pp.tip='4' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta4,
	   case when pp.tip='5' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta5,
	   case when pp.tip='6' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta6,
	   case when pp.tip='7' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta7,
	   case when pp.tip='8' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta8,
	   case when pp.tip='9' then concat('[[',pp._page,'|',pp.vieta,']]') else '' end zta9,
	   case when pp.sab='fg2' then '' when pp.sab='fg3' then '' else pp.zona end zona,
	   case when p.sab='fg2' then '' when p.sab='fg3' then '' else p.vieta end vtaz,
	   case when t.level is null then '' else concat('[[',t._page,'|',ts.Lt,']]') end taure,
	   case when l.level is null then '' else concat('[[',l._page,'|',ls.Lt,']]') end lygostaure,
	   case when s.level is null then '' else concat('[[',s._page,'|',ss.Lt,']]') end supertaure,
	   p.sab sab2, pp.sab sab4
from varser_k x
left join varsez_kom p on (p.fed=x.fed and p.uef=x.uef and p.kom_str=x.kom_str and p.sab='fg2')
left join varsez_kom pp on (pp.fed=x.fed and pp.uef=x.uef and pp.kom_str=x.kom_str and pp.sab<>'fg2')
left join TaureKom t on (x.fed=t.fed and x.uef=t.uef and x.kom_str=t.kom_str and t.tip='t')
left join `Cup stages` ts on (t.level=ts.level)
left join TaureKom l on (x.fed=l.fed and x.uef=l.uef and x.kom_str=l.kom_str and l.tip='l')
left join `Cup stages` ls on (l.level=ls.level)
left join TaureKom s on (x.fed=s.fed and x.uef=s.uef and x.kom_str=s.kom_str and s.tip='s')
left join `Cup stages` ss on (s.level=ss.level)
where x.kom_str='FBK Kaunas'
order by x.uef ASC