Диссекционные кадавер курсы
для врачей косметологов
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` >= '2022-12-07 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
Декабрь
07
лекторы:
Колесова Лияна
16
3 дня
Февраль
15
16
2 дня
21
3 дня
Март
14
2 дня
21
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` >= '2022-12-07 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
Декабрь
11
2 дня
лекторы:
Боровиков Алексей Михайлович
Январь
28
29
лекторы:
Март
18
2 дня
лекторы:
Грищенко Светлана Владимировна
Апрель
01
02
для оториноларингологов
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` >= '2022-12-07 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
Февраль
11
2 дня
лекторы:
18
2 дня
лекторы:
Русецкий Юрий Юрьевич
Чернова Ольга Васильевна
28
2 дня
лекторы:
Карпищенко Сергей Анатольевич
Март
02
2 дня
18 баллов НМО
лекторы:
Карпищенко Сергей Анатольевич
Болознева Елизавета Викторовна
04
2 дня
25
2 дня
лекторы:
Нерсесян Марина Владиславовна
Груша Ярослав Олегович
Полев Георгий Александрович
Июль
06
2 дня
18 баллов НМО
лекторы:
Карпищенко Сергей Анатольевич
Болознева Елизавета Викторовна
08
2 дня
Ноябрь
16
2 дня
18
2 дня
18 баллов НМО
лекторы:
Карпищенко Сергей Анатольевич
Болознева Елизавета Викторовна
для гинекологов
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` >= '2022-12-07 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
:[
К сожалению, курсов по этому направлению пока нет
для челюстно-лицевых хирургов
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` >= '2022-12-07 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
Январь
21
2 дня
Февраль
05
лекторы:
Яременко Андрей Ильич
для стоматологов
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` >= '2022-12-07 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
Февраль
04
лекторы:
Яременко Андрей Ильич
для нейрохирургов
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` >= '2022-12-07 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
Февраль
25
2 дня
27
2 дня
Апрель
15
2 дня
16 баллов НМО
лекторы:
Крылов Владимир Викторович
Лукьянчиков Виктор Александрович
Полунина Наталья Алексеевна
Шатохин Тарас Андреевич
для офтальмологов
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` >= '2022-12-07 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` >= '2022-12-07 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` >= '2022-12-07 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
Февраль
09
лекторы:
Цыкин Алексей Александрович
для остеопатов
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` >= '2022-12-07 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` >= '2022-12-07 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
:[
К сожалению, курсов по этому направлению пока нет