select if(year_begin+kurs0>2018,2018,year_begin+kurs0) as deb,year_begin,plan,disciplina
from (select year_begin,substring_index(group_concat(pe.plan_education order by tf.orderby),',',1) as plan
from plan_education pe
join web_training_form tf on pe.training_form=tf.training_form
where
pe.profil=107 and pe.spec=2947 and pe.fizlico=0 and pe.cenatype=0 and pe.dell=0 and pe.`status` in (24,25,18) and pe.year_begin<2019
and exists (select 0 from `web_groups` g where g.`plan_education`=pe.`plan_education` and g.`countpeople`>0)
group by pe.year_begin desc
) x
join (select 8670 as disciplina,0 as kurs0 union select 8667,0 union select 8668,1 union select 8669,1) y
12.03.03;Фотоника и оптоинформатика;Бакалавр - Фотоника в инфокоммуникациях: Очная