Акушер-гинеколог (10) | Аллерголог (8) | Андролог (7) |
Анестезиолог (1) | Вегетолог (1) | Венеролог (10) |
Гастроэнтеролог (15) | Гепатолог (1) | Гинеколог (20) |
Гомеопат (1) | Дерматовенеролог (6) | Дерматолог (15) |
Диетолог (2) | Иммунолог (2) | Инфекционист (2) |
Кардиолог (16) | Косметолог (10) | Логопед (1) |
Лор (отоларинголог) (16) | Маммолог (11) | Мануальный терапевт (7) |
Массажист (7) | Невролог (14) | Окулист (офтальмолог) (13) |
Онколог (5) | Ортопед (11) | Остеопат (3) |
Педиатр (12) | Пластический хирург (3) | Подолог (2) |
Проктолог (7) | Психиатр (1) | Психолог (2) |
Психотерапевт (5) | Пульмонолог (4) | Ревматолог (3) |
Рентгенолог (4) | Сексолог (1) | Стоматолог (15) |
Терапевт (16) | Трихолог (1) | УЗИ-специалист (18) |
Уролог (18) | Флеболог (12) | Хирург (14) |
Эндокринолог (17) | Эндоскопист (2) |
SET SQL_AUTO_IS_NULL = 0
SELECT `core_metro`.`id`, `core_metro`.`position`, `core_metro`.`slug`,
`core_metro`.`name`, `core_metro`.`code`, `core_metro`.`line`,
`core_metro`.`latitude`, `core_metro`.`longitude`
FROM `core_metro`
WHERE `core_metro`.`slug` = 'volokolamskaya' LIMIT 21
SELECT `core_specialization`.`id`, `core_specialization`.`slug`, `core_specialization`.`name`,
`core_specialization`.`name_mn`, `core_specialization`.`name_rod`, `core_specialization`.`name_im2`,
`core_specialization`.`description`
FROM `core_specialization`
WHERE `core_specialization`.`slug` = 'flebolog' LIMIT 21
SELECT COUNT(*)
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `clinic_clinic` ON ( `medic_medic_clinics`.`clinic_id` = `clinic_clinic`.`id` ) INNER JOIN `clinic_clinic_metro` ON ( `clinic_clinic`.`id` = `clinic_clinic_metro`.`clinic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` )
WHERE (`medic_medic`.`active` = 1 AND `clinic_clinic_metro`.`metro_id` = 41 AND `medic_medic_specializations`.`specialization_id` = 43)
SELECT `core_setting`.`id`, `core_setting`.`meta_title`, `core_setting`.`meta_keywords`,
`core_setting`.`meta_description`, `core_setting`.`name`, `core_setting`.`from_email`,
`core_setting`.`notification_emails`, `core_setting`.`description`, `core_setting`.`static_block_id`,
`core_setting`.`phone_code`, `core_setting`.`phone_number`, `core_setting`.`worktime`,
`core_setting`.`address`, `core_setting`.`footer`, `core_setting`.`soc_facebook`,
`core_setting`.`soc_twitter`, `core_setting`.`soc_vkontakte`, `core_setting`.`soc_gplus`
FROM `core_setting`
WHERE `core_setting`.`id` = 1 LIMIT 21
SELECT `core_specialization`.`id`, `core_specialization`.`slug`, `core_specialization`.`name`,
`core_specialization`.`name_mn`, `core_specialization`.`name_rod`, `core_specialization`.`name_im2`,
`core_specialization`.`description`
FROM `core_specialization` ORDER BY `core_specialization`.`name` ASC
SELECT `core_specialization`.`id`, `core_specialization`.`slug`, `core_specialization`.`name`,
`core_specialization`.`name_mn`, `core_specialization`.`name_rod`, `core_specialization`.`name_im2`,
`core_specialization`.`description`, COUNT(`clinic_clinic_specializations`.`clinic_id`) AS `specialization_clinics__count`
FROM `core_specialization` LEFT OUTER JOIN `clinic_clinic_specializations` ON ( `core_specialization`.`id` = `clinic_clinic_specializations`.`specialization_id` ) GROUP BY `core_specialization`.`id` HAVING COUNT(`clinic_clinic_specializations`.`clinic_id`) > 0 ORDER BY `core_specialization`.`name` ASC