Прошедшие стажировки
для врачей косметологов
select
c.`Message_ID`, c.`name` as title, c.`shortname`, UNIX_TIMESTAMP(c.date) as date, c.`color`, t.`warning`, t.`theory`, c.`is_webinar`,
t.`practice`, t.`duration`, t.`price`, t.`teacher`, c.`type`, c.`days`, c.`cadaver_doctors`, ca.`cadaverarea_Name` as area, c.`duration` as cduration,
count(om.`trainingID`) as modelCount, c.`cadaver_type`, c.`cadaver_price_1`, c.`cadaver_price_2`, c.`cadaver_price_3`, t.`hmo`
from
`novonexus`.`Message2009` as c
left join `novonexus`.`Message2106` as t
on t.`Message_ID` = c.`training_id`
left join `dev_repleri`.`office_model` as om
on om.`trainingID` = c.`Message_ID`
left join `novonexus`.`Classificator_cadaverarea` as ca
on c.`cadaver_area` = ca.`cadaverarea_ID`
where
c.`date` < '2024-04-25 00:00:00'
and c.`cadaver_type` in (1)
and c.`type` = 4
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date` desc
limit 10
Июнь
22
лекторы:
Колесова Лияна
Февраль
21
2 дня
лекторы:
Колесова Лияна
08
3 дня
лекторы:
Колесова Лияна
Косило Олеся
Январь
17
2 дня
лекторы:
Колесова Лияна
Ноябрь
30
2 дня
лекторы:
Колесова Лияна
08
3 дня
лекторы:
Колесова Лияна
Косило Олеся
Октябрь
12
3 дня
лекторы:
Колесова Лияна
Косило Олеся
Сентябрь
13
3 дня
лекторы:
Колесова Лияна
Косило Олеся
06
3 дня
лекторы:
Колесова Лияна
Косило Олеся
Июль
06
3 дня
лекторы:
Колесова Лияна
Косило Олеся
для оториноларингологов
select
c.`Message_ID`, c.`name` as title, c.`shortname`, UNIX_TIMESTAMP(c.date) as date, c.`color`, t.`warning`, t.`theory`, c.`is_webinar`,
t.`practice`, t.`duration`, t.`price`, t.`teacher`, c.`type`, c.`days`, c.`cadaver_doctors`, ca.`cadaverarea_Name` as area, c.`duration` as cduration,
count(om.`trainingID`) as modelCount, c.`cadaver_type`, c.`cadaver_price_1`, c.`cadaver_price_2`, c.`cadaver_price_3`, t.`hmo`
from
`novonexus`.`Message2009` as c
left join `novonexus`.`Message2106` as t
on t.`Message_ID` = c.`training_id`
left join `dev_repleri`.`office_model` as om
on om.`trainingID` = c.`Message_ID`
left join `novonexus`.`Classificator_cadaverarea` as ca
on c.`cadaver_area` = ca.`cadaverarea_ID`
where
c.`date` < '2024-04-25 00:00:00'
and c.`cadaver_type` in (14)
and c.`type` = 4
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date` desc
limit 10
Июнь
22
2 дня
лекторы:
Карпищенко Сергей Анатольевич
Март
28
2 дня
лекторы:
Асманов Алан Исмаилович
Полев Георгий Александрович
Полунин Михаил Михайлович
для анестезиологов
select
c.`Message_ID`, c.`name` as title, c.`shortname`, UNIX_TIMESTAMP(c.date) as date, c.`color`, t.`warning`, t.`theory`, c.`is_webinar`,
t.`practice`, t.`duration`, t.`price`, t.`teacher`, c.`type`, c.`days`, c.`cadaver_doctors`, ca.`cadaverarea_Name` as area, c.`duration` as cduration,
count(om.`trainingID`) as modelCount, c.`cadaver_type`, c.`cadaver_price_1`, c.`cadaver_price_2`, c.`cadaver_price_3`, t.`hmo`
from
`novonexus`.`Message2009` as c
left join `novonexus`.`Message2106` as t
on t.`Message_ID` = c.`training_id`
left join `dev_repleri`.`office_model` as om
on om.`trainingID` = c.`Message_ID`
left join `novonexus`.`Classificator_cadaverarea` as ca
on c.`cadaver_area` = ca.`cadaverarea_ID`
where
c.`date` < '2024-04-25 00:00:00'
and c.`cadaver_type` in (5)
and c.`type` = 4
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date` desc
limit 10
Июнь
19
2 дня
лекторы:
Григорьев Андрей Юрьевич
Апрель
30
лекторы:
Ошоров Андрей Васильевич
Куликов Александр Сергеевич
для гинекологов
select
c.`Message_ID`, c.`name` as title, c.`shortname`, UNIX_TIMESTAMP(c.date) as date, c.`color`, t.`warning`, t.`theory`, c.`is_webinar`,
t.`practice`, t.`duration`, t.`price`, t.`teacher`, c.`type`, c.`days`, c.`cadaver_doctors`, ca.`cadaverarea_Name` as area, c.`duration` as cduration,
count(om.`trainingID`) as modelCount, c.`cadaver_type`, c.`cadaver_price_1`, c.`cadaver_price_2`, c.`cadaver_price_3`, t.`hmo`
from
`novonexus`.`Message2009` as c
left join `novonexus`.`Message2106` as t
on t.`Message_ID` = c.`training_id`
left join `dev_repleri`.`office_model` as om
on om.`trainingID` = c.`Message_ID`
left join `novonexus`.`Classificator_cadaverarea` as ca
on c.`cadaver_area` = ca.`cadaverarea_ID`
where
c.`date` < '2024-04-25 00:00:00'
and c.`cadaver_type` in (2)
and c.`type` = 4
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date` desc
limit 10
Июнь
11
лекторы:
Ершов Георгий
Апрель
30
лекторы:
Ершов Георгий
Сентябрь
11
лекторы:
Ершов Георгий