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 (active_shop = 1 or (sc.as_seminar = 0 and (select active_shop from sch_modules where id = sc.mid and active_rasp = 1) = 1)) and sc.form_study = 4 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

Ming Li - навигатор по судьбе