SET SQL_AUTO_IS_NULL = 0
        

        
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` = 'gastroenterolog' LIMIT 21
        

        
SELECT COUNT(*) 
FROM (SELECT `medic_medic`.`id` AS `id`, `medic_medic`.`meta_title` AS `meta_title`, `medic_medic`.`meta_keywords` AS `meta_keywords`,
     `medic_medic`.`meta_description` AS `meta_description`, `medic_medic`.`active` AS `active`, `medic_medic`.`date` AS `date`,
     `medic_medic`.`lastname` AS `lastname`, `medic_medic`.`firstname` AS `firstname`, `medic_medic`.`middlename` AS `middlename`,
     `medic_medic`.`image` AS `image`, `medic_medic`.`description` AS `description`, `medic_medic`.`stage` AS `stage`,
     `medic_medic`.`rating_avg` AS `rating_avg`, `medic_medic`.`specialization_id` AS `specialization_id`, `medic_medic`.`testimonial_count` AS `testimonial_count`,
     COUNT(`medic_medic_clinics`.`clinic_id`) AS `clinics__count`, T4.`id` AS Col15, T4.`slug`,
     T4.`name`, T4.`name_mn`, T4.`name_rod`,
     T4.`name_im2`, T4.`description` AS Col21 
FROM `medic_medic` INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T4 ON ( `medic_medic`.`specialization_id` = T4.`id` ) LEFT OUTER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) 
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_specializations`.`specialization_id` = 6) GROUP BY `medic_medic`.`id` ORDER BY NULL) subquery
        

        
SELECT `medic_medic`.`id` 
FROM `medic_medic` INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) LEFT OUTER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) 
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_specializations`.`specialization_id` = 6) GROUP BY `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
     `medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
     `medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
     `medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
     `medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count` ORDER BY `medic_medic`.`rating_avg` DESC LIMIT 5
        

        
SELECT `medic_medic_specializations`.`medic_id`, `core_specialization`.`name` 
FROM `core_specialization` INNER JOIN `medic_medic_specializations` ON ( `core_specialization`.`id` = `medic_medic_specializations`.`specialization_id` ) 
WHERE `medic_medic_specializations`.`medic_id` IN (16, 17,
     18, 89, 106) ORDER BY `core_specialization`.`name` ASC
        

        
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
        

        
SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
     `medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
     `medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
     `medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
     `medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
     COUNT(`medic_medic_clinics`.`clinic_id`) AS `clinics__count`, T4.`id`, T4.`slug`,
     T4.`name`, T4.`name_mn`, T4.`name_rod`,
     T4.`name_im2`, T4.`description` 
FROM `medic_medic` INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T4 ON ( `medic_medic`.`specialization_id` = T4.`id` ) LEFT OUTER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) 
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_specializations`.`specialization_id` = 6) GROUP BY `medic_medic`.`id` ORDER BY `medic_medic`.`rating_avg` DESC LIMIT 5