/image/user/avatar_no.png

dpeikc

с нами с 19.03.2018

Последние комментарии

/image/user/avatar_no_profile.png
dpeikc 19.03.2018

cheap viagra uk

buy real viagra http://canadan-pharmacy.com

На вопрос: По каким критериям определять качество имплантов?

(default) 35 queries took 173 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Config`.`name`, `Config`.`value` FROM `topestet_ru_db`.`configs` AS `Config` WHERE 1 = 110100
2SET SQL_BIG_SELECTS=1000
3SELECT `Show`.`id`, `Show`.`url`, `Show`.`count`, `Show`.`updated`, `Show`.`created` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`url` = '/user/page/96768/' LIMIT 11147
4BEGIN000
5SELECT COUNT(*) AS `count` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`id` = 204781110
6SELECT COUNT(*) AS `count` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`id` = 204781110
7SELECT COUNT(*) AS `count` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `Show`.`id` = 204781110
8UPDATE `topestet_ru_db`.`shows` SET `id` = 204781, `count` = 531, `url` = '/user/page/96768/', `updated` = '2019-07-23 05:09:02' WHERE `topestet_ru_db`.`shows`.`id` = '204781'110
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 33312
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 4440
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 33330
13SELECT `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` FROM `topestet_ru_db`.`users` AS `User` WHERE `id` = 96768 ORDER BY `User`.`created` DESC LIMIT 1112
14SELECT `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` FROM `topestet_ru_db`.`reviews` AS `Review` WHERE `Review`.`specialist_id` = (96768) ORDER BY `Review`.`created` DESC LIMIT 10004
15SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`user_id`, `Comment`.`belongs_id`, `Comment`.`url`, `Comment`.`belongs`, `Comment`.`content`, `Comment`.`ip`, `Comment`.`created`, (IF( belongs = "Question", CONCAT("/forum/answer/", `Comment`.`belongs_id`,"/"), IF ( belongs = "Review", CONCAT("/service/review/", `Comment`.`belongs_id`,"/"), IF ( belongs = "RegionService", "err2", "err1" ) ) )) AS `Comment__url_old` FROM `topestet_ru_db`.`comments` AS `Comment` WHERE `parent_id` IS NULL AND `Comment`.`user_id` = (96768) ORDER BY `Comment`.`created` DESC111
16SELECT `Question`.`id`, `Question`.`service_id`, `Question`.`user_id`, `Question`.`specialist_id`, `Question`.`response_count`, `Question`.`comment_count`, `Question`.`photo_count`, `Question`.`is_main`, `Question`.`service_title`, `Question`.`subject`, `Question`.`content`, `Question`.`updated`, `Question`.`created` FROM `topestet_ru_db`.`questions` AS `Question` WHERE `Question`.`id` = 5284 ORDER BY `Question`.`created` desc LIMIT 1114
17SELECT `Question`.`id`, `Question`.`service_id`, `Question`.`user_id`, `Question`.`specialist_id`, `Question`.`response_count`, `Question`.`comment_count`, `Question`.`photo_count`, `Question`.`is_main`, `Question`.`service_title`, `Question`.`subject`, `Question`.`content`, `Question`.`updated`, `Question`.`created` FROM `topestet_ru_db`.`questions` AS `Question` WHERE `user_id` = 96768 ORDER BY `created` DESC001
18SELECT `Page`.`alias`, `Page`.`title_short` FROM `topestet_ru_db`.`pages` AS `Page` WHERE `is_link` = '1' ORDER BY `order` desc, `title` desc110
19SELECT `Seo`.`id`, `Seo`.`url`, `Seo`.`title`, `Seo`.`description`, `Seo`.`keywords`, `Seo`.`updated`, `Seo`.`created` FROM `topestet_ru_db`.`seo` AS `Seo` WHERE `Seo`.`url` = '/user/page/96768/' ORDER BY `created` desc LIMIT 1000
20SELECT `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
21SELECT `Show`.`id`, `Show`.`url`, `Show`.`count`, `Show`.`updated`, `Show`.`created` FROM `topestet_ru_db`.`shows` AS `Show` WHERE `url` = '/user/page/96768/' LIMIT 11152
22SELECT `Block`.`id`, `Block`.`controller`, `Block`.`action`, `Block`.`title`, `Block`.`content`, `Block`.`updated`, `Block`.`created` FROM `topestet_ru_db`.`blocks` AS `Block` WHERE `controller` = 'user' AND `action` = 'page' LIMIT 1002
23SELECT `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 5551
24SELECT `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 1010102
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` = 4482 ORDER BY `Clinic`.`name` ASC LIMIT 1111
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` = 1103 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` = 964 ORDER BY `Clinic`.`name` ASC LIMIT 1112
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` = 125 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` = 1064 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` = 4483 ORDER BY `Clinic`.`name` ASC LIMIT 1112
31SELECT `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
32SELECT `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
33SELECT `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
34SELECT `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 1113
35SELECT `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