SELECT sc.*, sch_cources_tags.tag as form_name,`sc`.form_study as form_id, si.enable
FROM `onesem_and_mdl_v2` as sc
INNER JOIN `sch_cources_tags` ON ((sch_cources_tags.sem_id = `sc`.id and sc.as_seminar=0) or (sch_cources_tags.mdl_id = `sc`.id and sc.as_seminar=2))
LEFT JOIN `shop_items` si on si.id = sc.id_shop
WHERE sc.active_rasp = 1
and sc.form_study = 5
group by (case when sc.uri = '' then sc.id else uri end), sch_cources_tags.tag
ORDER BY FIELD( sch_cources_tags.tag,'Бацзы','Фэн шуй','Ци Мэнь Дунь Цзя','Выбор дат'), as_seminar desc, case when as_seminar = 2 then sc.cid when as_seminar in (0,1) then sc.date_beg end desc, (case when as_seminar = 2 then 10000000000-CONVERT(date_beg, UNSIGNED) else date_beg end) desc
