Что такое «Топ Эстет»?

Наша миссия – формирование сообщества для обмена правдивой, полезной и всесторонне объективной информацией, связанной с эстетическим совершенствованием человека.

«Топ Эстет» представляет собой открытую площадку, где каждый желающий может поделиться своим опытом и впечатлениями от:

  • пластической хирургии
  • косметологии
  • антивозрастной медицины
  • эстетической стоматологии
  • иных медицинских процедур, направленных на совершенствование качества жизни

Не секрет, что многие из этих вопросов не принято обсуждать с друзьями и знакомыми, что зачастую лишает человека возможности принять решение на основе какой-либо информации, кроме откровенно рекламной. В нашем сообществе нет подобных «запретных» тем и, в то же время, каждый участник при желании сохраняет полную конфиденциальность.

 

Что такое рейтинг популярности?

 

Рейтинг популярности формируется на основе отзывов и отражает отношение пользователей к той или иной процедуре. Итоговая цифра представляет собой совокупную оценку количества тех, кому данная процедура была проведена и кто по ее итогам:

  • доволен процедурой и готов ее рекомендовать, 
  • не доволен и не готов рекомендовать
  • не определился в своем отношении к процедуре

Формула учитывает несколько разноплановых факторов, но в упрощенном виде – чем выше цифра, тем больший процент удовлетворенных и меньший - неудовлетворенных результатом пациентов. 

Контакты

Связаться с нами можно через специальную форму или по адресу topestet {собака} ya.ru

(default) 31 queries took 56 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Config`.`name`, `Config`.`value` FROM `topestet_ru_db`.`configs` AS `Config` WHERE 1 = 110100
2SET SQL_BIG_SELECTS=1001
3SELECT `Show`.`id`, `Show`.`url`, `Show`.`count`, `Show`.`updated`, `Show`.`created` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`url` = '/page/about/' LIMIT 1111
4BEGIN000
5SELECT COUNT(*) AS `count` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`id` = 18111
6SELECT COUNT(*) AS `count` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`id` = 18110
7SELECT COUNT(*) AS `count` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`id` = 18117
8UPDATE `topestet_ru_db`.`shows` SET `id` = 18, `count` = 17124, `url` = '/page/about/', `updated` = '2019-07-19 10:02:37' WHERE `topestet_ru_db`.`shows`.`id` = '18'111
9COMMIT000
10SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`service_id`, `Review`.`specialist_id`, `Review`.`clinic_id`, `Review`.`region_id`, `Review`.`thank_count`, `Review`.`thank_manual_count`, `Review`.`photo_count`, `Review`.`review_add_count`, `Review`.`specialist_name`, `Review`.`clinic_name`, `Review`.`service_title`, `Review`.`subject`, `Review`.`coast`, `Review`.`description`, `Review`.`note_result`, `Review`.`note_specialist`, `Review`.`comment_note`, `Review`.`comment_image`, `Review`.`remind`, `Review`.`comment_count`, `Review`.`is_adv`, `Review`.`is_translated`, `Review`.`edited`, `Review`.`ip`, `Review`.`updated`, `Review`.`created`, (`Review`.`thank_manual_count` + `Review`.`thank_count`) AS `Review__thank_all_count`, `User`.`id`, `User`.`password`, `User`.`is_specialist`, `User`.`is_admin`, `User`.`is_top_set`, `User`.`is_adv`, `User`.`region_id`, `User`.`social_id`, `User`.`parent_id`, `User`.`rate`, `User`.`coast_avg`, `User`.`active`, `User`.`specialist_service_count`, `User`.`response_count`, `User`.`review_count`, `User`.`review_ex_count`, `User`.`rate_manual`, `User`.`name`, `User`.`name_genitive`, `User`.`name_dative`, `User`.`profession`, `User`.`phone`, `User`.`address`, `User`.`coor`, `User`.`site`, `User`.`social_page`, `User`.`description`, `User`.`specialist_request`, `User`.`mail`, `User`.`personal_mail`, `User`.`birthday`, `User`.`sex`, `User`.`was`, `User`.`send_notification`, `User`.`updated`, `User`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`User`.`birthday`)), "%Y") + 0) AS `User__age`, (`User`.`response_count` + `User`.`review_count`) AS `User__popular`, (if(`User`.`specialist_request` != "", true, false)) AS `User__has_request`, (IF(`User`.`is_top_set` OR (`User`.`response_count` >= 40 AND `User`.`review_ex_count` >= 1), true, false)) AS `User__is_top`, `Specialist`.`id`, `Specialist`.`password`, `Specialist`.`is_specialist`, `Specialist`.`is_admin`, `Specialist`.`is_top_set`, `Specialist`.`is_adv`, `Specialist`.`region_id`, `Specialist`.`social_id`, `Specialist`.`parent_id`, `Specialist`.`rate`, `Specialist`.`coast_avg`, `Specialist`.`active`, `Specialist`.`specialist_service_count`, `Specialist`.`response_count`, `Specialist`.`review_count`, `Specialist`.`review_ex_count`, `Specialist`.`rate_manual`, `Specialist`.`name`, `Specialist`.`name_genitive`, `Specialist`.`name_dative`, `Specialist`.`profession`, `Specialist`.`phone`, `Specialist`.`address`, `Specialist`.`coor`, `Specialist`.`site`, `Specialist`.`social_page`, `Specialist`.`description`, `Specialist`.`specialist_request`, `Specialist`.`mail`, `Specialist`.`personal_mail`, `Specialist`.`birthday`, `Specialist`.`sex`, `Specialist`.`was`, `Specialist`.`send_notification`, `Specialist`.`updated`, `Specialist`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Specialist`.`birthday`)), "%Y") + 0) AS `Specialist__age`, (`Specialist`.`response_count` + `Specialist`.`review_count`) AS `Specialist__popular`, (if(`Specialist`.`specialist_request` != "", true, false)) AS `Specialist__has_request`, (IF(`Specialist`.`is_top_set` OR (`Specialist`.`response_count` >= 40 AND `Specialist`.`review_ex_count` >= 1), true, false)) AS `Specialist__is_top` FROM `topestet_ru_db`.`reviews` AS `Review` LEFT JOIN `topestet_ru_db`.`users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `topestet_ru_db`.`users` AS `Specialist` ON (`Review`.`specialist_id` = `Specialist`.`id`) WHERE `Review`.`specialist_id` IS NOT NULL ORDER BY `edited` DESC LIMIT 3335
11SELECT *, MAX(`Response`.`created`) as m, `Question`.`id` FROM `topestet_ru_db`.`responses` AS `Response` LEFT JOIN `topestet_ru_db`.`questions` AS `Question` ON (`Response`.`question_id` = `Question`.`id`) WHERE 1 = 1 GROUP BY question_id ORDER BY `m` DESC LIMIT 4441
12SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`service_id`, `Review`.`specialist_id`, `Review`.`clinic_id`, `Review`.`region_id`, `Review`.`thank_count`, `Review`.`thank_manual_count`, `Review`.`photo_count`, `Review`.`review_add_count`, `Review`.`specialist_name`, `Review`.`clinic_name`, `Review`.`service_title`, `Review`.`subject`, `Review`.`coast`, `Review`.`description`, `Review`.`note_result`, `Review`.`note_specialist`, `Review`.`comment_note`, `Review`.`comment_image`, `Review`.`remind`, `Review`.`comment_count`, `Review`.`is_adv`, `Review`.`is_translated`, `Review`.`edited`, `Review`.`ip`, `Review`.`updated`, `Review`.`created`, (`Review`.`thank_manual_count` + `Review`.`thank_count`) AS `Review__thank_all_count`, `User`.`id`, `User`.`password`, `User`.`is_specialist`, `User`.`is_admin`, `User`.`is_top_set`, `User`.`is_adv`, `User`.`region_id`, `User`.`social_id`, `User`.`parent_id`, `User`.`rate`, `User`.`coast_avg`, `User`.`active`, `User`.`specialist_service_count`, `User`.`response_count`, `User`.`review_count`, `User`.`review_ex_count`, `User`.`rate_manual`, `User`.`name`, `User`.`name_genitive`, `User`.`name_dative`, `User`.`profession`, `User`.`phone`, `User`.`address`, `User`.`coor`, `User`.`site`, `User`.`social_page`, `User`.`description`, `User`.`specialist_request`, `User`.`mail`, `User`.`personal_mail`, `User`.`birthday`, `User`.`sex`, `User`.`was`, `User`.`send_notification`, `User`.`updated`, `User`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`User`.`birthday`)), "%Y") + 0) AS `User__age`, (`User`.`response_count` + `User`.`review_count`) AS `User__popular`, (if(`User`.`specialist_request` != "", true, false)) AS `User__has_request`, (IF(`User`.`is_top_set` OR (`User`.`response_count` >= 40 AND `User`.`review_ex_count` >= 1), true, false)) AS `User__is_top`, `Region`.`id`, `Region`.`child_count`, `Region`.`specialist_count`, `Region`.`parent_id`, `Region`.`title`, `Region`.`title_genitive`, `Region`.`title_with_preposition`, `Region`.`alias`, `Region`.`order`, `Region`.`order_select`, `Region`.`created` FROM `topestet_ru_db`.`reviews` AS `Review` LEFT JOIN `topestet_ru_db`.`users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `topestet_ru_db`.`regions` AS `Region` ON (`Review`.`region_id` = `Region`.`id`) WHERE (`Review`.`thank_manual_count` + `Review`.`thank_count`) > 0 ORDER BY (`Review`.`thank_manual_count` + `Review`.`thank_count`) desc LIMIT 33316
13SELECT `Page`.`id`, `Page`.`alias`, `Page`.`title`, `Page`.`title_short`, `Page`.`content`, `Page`.`content_right`, `Page`.`order`, `Page`.`is_link`, `Page`.`updated`, `Page`.`created` FROM `topestet_ru_db`.`pages` AS `Page` WHERE `Page`.`alias` = 'about' ORDER BY `order` desc, `title` desc LIMIT 1111
14SELECT `Page`.`alias`, `Page`.`title_short` FROM `topestet_ru_db`.`pages` AS `Page` WHERE `is_link` = '1' ORDER BY `order` desc, `title` desc111
15SELECT `Seo`.`id`, `Seo`.`url`, `Seo`.`title`, `Seo`.`description`, `Seo`.`keywords`, `Seo`.`updated`, `Seo`.`created` FROM `topestet_ru_db`.`seo` AS `Seo` WHERE `Seo`.`url` = '/page/about/' ORDER BY `created` desc LIMIT 1112
16SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`service_id`, `Review`.`specialist_id`, `Review`.`clinic_id`, `Review`.`region_id`, `Review`.`thank_count`, `Review`.`thank_manual_count`, `Review`.`photo_count`, `Review`.`review_add_count`, `Review`.`specialist_name`, `Review`.`clinic_name`, `Review`.`service_title`, `Review`.`subject`, `Review`.`coast`, `Review`.`description`, `Review`.`note_result`, `Review`.`note_specialist`, `Review`.`comment_note`, `Review`.`comment_image`, `Review`.`remind`, `Review`.`comment_count`, `Review`.`is_adv`, `Review`.`is_translated`, `Review`.`edited`, `Review`.`ip`, `Review`.`updated`, `Review`.`created`, (`Review`.`thank_manual_count` + `Review`.`thank_count`) AS `Review__thank_all_count`, `Service`.`title`, `Service`.`alias` FROM `topestet_ru_db`.`reviews` AS `Review` LEFT JOIN `topestet_ru_db`.`services` AS `Service` ON (`Review`.`service_id` = `Service`.`id`) WHERE `Review`.`service_id` IS NOT NULL ORDER BY `Review`.`created` desc LIMIT 6661
17SELECT `Show`.`id`, `Show`.`url`, `Show`.`count`, `Show`.`updated`, `Show`.`created` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `url` = '/page/about/' LIMIT 1118
18SELECT `Block`.`id`, `Block`.`controller`, `Block`.`action`, `Block`.`title`, `Block`.`content`, `Block`.`updated`, `Block`.`created` FROM `topestet_ru_db`.`blocks` AS `Block` WHERE `controller` = 'index' AND `action` = 'document' LIMIT 1000
19SELECT `Specialist`.*, count(`Review`.`id`) as cnt, `Specialist`.`id` FROM `topestet_ru_db`.`reviews` AS `Review` LEFT JOIN `topestet_ru_db`.`users` AS `Specialist` ON (`Review`.`specialist_id` = `Specialist`.`id`) WHERE `Specialist`.`is_specialist` = 1 GROUP BY `Review`.`specialist_id` HAVING COUNT(`Review`.`specialist_id`) > 5 ORDER BY `Specialist`.`rate` DESC, `cnt` DESC LIMIT 5550
20SELECT `Specialist`.*, count(`Review`.`id`) as cnt, `Specialist`.`id` FROM `topestet_ru_db`.`reviews` AS `Review` LEFT JOIN `topestet_ru_db`.`users` AS `Specialist` ON (`Review`.`specialist_id` = `Specialist`.`id`) WHERE `Specialist`.`is_specialist` = 1 GROUP BY `Review`.`specialist_id` HAVING COUNT(`Review`.`specialist_id`) > 5 ORDER BY `Specialist`.`rate` DESC, `cnt` DESC LIMIT 1010100
21SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 4482 ORDER BY `Clinic`.`name` ASC LIMIT 1111
22SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 1103 ORDER BY `Clinic`.`name` ASC LIMIT 1111
23SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 964 ORDER BY `Clinic`.`name` ASC LIMIT 1111
24SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 125 ORDER BY `Clinic`.`name` ASC LIMIT 1111
25SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 1064 ORDER BY `Clinic`.`name` ASC LIMIT 1001
26SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 4483 ORDER BY `Clinic`.`name` ASC LIMIT 1111
27SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 5250 ORDER BY `Clinic`.`name` ASC LIMIT 1001
28SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 120 ORDER BY `Clinic`.`name` ASC LIMIT 1111
29SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 812 ORDER BY `Clinic`.`name` ASC LIMIT 1001
30SELECT `SpecialistClinic`.`id`, `SpecialistClinic`.`specialist_id`, `SpecialistClinic`.`clinic_id`, `SpecialistClinic`.`created`, `Clinic`.`id`, `Clinic`.`password`, `Clinic`.`is_specialist`, `Clinic`.`is_admin`, `Clinic`.`is_top_set`, `Clinic`.`is_adv`, `Clinic`.`region_id`, `Clinic`.`social_id`, `Clinic`.`parent_id`, `Clinic`.`rate`, `Clinic`.`coast_avg`, `Clinic`.`active`, `Clinic`.`specialist_service_count`, `Clinic`.`response_count`, `Clinic`.`review_count`, `Clinic`.`review_ex_count`, `Clinic`.`rate_manual`, `Clinic`.`name`, `Clinic`.`name_genitive`, `Clinic`.`name_dative`, `Clinic`.`profession`, `Clinic`.`phone`, `Clinic`.`address`, `Clinic`.`coor`, `Clinic`.`site`, `Clinic`.`social_page`, `Clinic`.`description`, `Clinic`.`specialist_request`, `Clinic`.`mail`, `Clinic`.`personal_mail`, `Clinic`.`birthday`, `Clinic`.`sex`, `Clinic`.`was`, `Clinic`.`send_notification`, `Clinic`.`updated`, `Clinic`.`created`, (DATE_FORMAT(FROM_DAYS(TO_DAYS(now()) - TO_DAYS(`Clinic`.`birthday`)), "%Y") + 0) AS `Clinic__age`, (`Clinic`.`response_count` + `Clinic`.`review_count`) AS `Clinic__popular`, (if(`Clinic`.`specialist_request` != "", true, false)) AS `Clinic__has_request`, (IF(`Clinic`.`is_top_set` OR (`Clinic`.`response_count` >= 40 AND `Clinic`.`review_ex_count` >= 1), true, false)) AS `Clinic__is_top` FROM `topestet_ru_db`.`specialist_clinics` AS `SpecialistClinic` LEFT JOIN `topestet_ru_db`.`users` AS `Clinic` ON (`SpecialistClinic`.`clinic_id` = `Clinic`.`id`) WHERE `specialist_id` = 5266 ORDER BY `Clinic`.`name` ASC LIMIT 1111
31SELECT `Specialization`.`id`, `Specialization`.`service_count`, `Specialization`.`alias`, `Specialization`.`title`, `Specialization`.`title_clinic`, `Specialization`.`title_clinic_one`, `Specialization`.`specialist`, `Specialization`.`specialist_plural`, `Specialization`.`order_title`, `Specialization`.`created` FROM `topestet_ru_db`.`specializations` AS `Specialization` WHERE 1 = 1 ORDER BY `title` ASC220