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

        
SELECT COUNT(*) 
FROM `core_metro`
        

        
SELECT COUNT(*) 
FROM `core_city`
        

        
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_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 `banner_banner`.`id`, `banner_banner`.`position`, `banner_banner`.`active`,
     `banner_banner`.`name`, `banner_banner`.`short`, `banner_banner`.`url`,
     `banner_banner`.`image`, `banner_banner`.`image_url`, `banner_banner`.`side`,
     `banner_banner`.`content_type_id`, `banner_banner`.`object_id` 
FROM `banner_banner` 
WHERE (`banner_banner`.`object_id` = 1 AND `banner_banner`.`content_type_id` = 12) ORDER BY `banner_banner`.`position` ASC LIMIT 4
        

        
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_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` ORDER BY `core_metro`.`name` ASC
        

        
SELECT `core_city`.`id`, `core_city`.`position`, `core_city`.`slug`,
     `core_city`.`name`, `core_city`.`region`, `core_city`.`latitude`,
     `core_city`.`longitude` 
FROM `core_city` ORDER BY `core_city`.`name` ASC
        

        
SELECT `clinic_clinic`.`id`, `clinic_clinic`.`meta_title`, `clinic_clinic`.`meta_keywords`,
     `clinic_clinic`.`meta_description`, `clinic_clinic`.`active`, `clinic_clinic`.`date`,
     `clinic_clinic`.`name`, `clinic_clinic`.`address`, `clinic_clinic`.`description`,
     `clinic_clinic`.`image`, `clinic_clinic`.`rating_avg`, `clinic_clinic`.`testimonial_count`,
     `clinic_clinic`.`latitude`, `clinic_clinic`.`longitude` 
FROM `clinic_clinic` ORDER BY `clinic_clinic`.`rating_avg` DESC, `clinic_clinic`.`date` DESC LIMIT 3