Диссекционные кадавер курсы
для врачей косметологов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (1)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Декабрь
13
2 дня
19
3 дня
Январь
16
2 дня
23
3 дня
Февраль
13
20
2 дня
27
3 дня
Март
05
2 дня
26
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (16)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Февраль
03
04
11
лекторы:
Март
14
2 дня
лекторы:
Грищенко Светлана Владимировна
16
2 дня
лекторы:
Грищенко Светлана Владимировна
Апрель
13
27
Июль
12
Сентябрь
20
Декабрь
07
для оториноларингологов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (14)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Декабрь
09
2 дня
лекторы:
Полев Георгий Александрович
Нерсесян Марина Владиславовна
22
2 дня
05
2 дня
Январь
26
2 дня
лекторы:
Кривопалов Александр Александрович
Павлов Павел Владимирович
Февраль
09
2 дня
14
2 дня
16
2 дня
Март
07
2 дня
22
лекторы:
Полев Георгий Александрович
23
2 дня
лекторы:
Полев Георгий Александрович
Нерсесян Марина Владиславовна
29
2 дня
лекторы:
Кривопалов Александр Александрович
Павлов Павел Владимирович
Апрель
20
2 дня
Май
18
24
2 дня
Июль
06
лекторы:
Косяков Сергей Яковлевич
Пчеленок Екатерина Витальевна
25
2 дня
Август
22
2 дня
Сентябрь
27
2 дня
Ноябрь
13
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (2)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Февраль
24
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (15)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Декабрь
08
лекторы:
Сысолятин Святослав Павлович
Лопатин Андрей Станиславович
Январь
28
лекторы:
Топольницкий Орест Зиновьевич
Федотов Роман Николаевич
для стоматологов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (6)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Март
02
2 дня
лекторы:
Яременко Андрей Ильич
Апрель
06
лекторы:
Каграманян Нина Владимировна
для нейрохирургов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (5)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Январь
21
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (18)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Май
11
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (17)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
:[
К сожалению, курсов по этому направлению пока нет
для подологов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (4)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Февраль
08
лекторы:
Цыкин Алексей Александрович
Шлыков Кирилл
для остеопатов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (13)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
:[
К сожалению, курсов по этому направлению пока нет
для студентов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (19)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
:[
К сожалению, курсов по этому направлению пока нет
для травматологов
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` >= '2023-12-06 00:00:00'
and c.`cadaver_type` in (12)
and c.`type` = 2
and c.`is_webinar` = 0
and c.`Checked` = 1
group by
c.`Message_ID`
order by
c.`date`
limit 99
Январь
19
лекторы:
Глазков Юрий Константинович
Гончаров Евгений Николаевич
Захаров Кирилл Игоревич