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=102 and pe.spec=3689 and pe.fizlico=0 and pe.cenatype=0 and 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

05.03.06;Экология и природопользование;Прикладной бакалавр - Прикладная экология: Очная

ДисциплиныУчебный годРПД