| 4 |
SELECT `News`.`id`, `News`.`hospital_id`, `News`.`doctor_id`, `News`.`pharmaceutical_id`, `News`.`user_id`, `News`.`name`, `News`.`views`, `News`.`description`, `News`.`published`, `News`.`image`, `News`.`slug`, `News`.`is_article`, `News`.`author`, `News`.`is_featured`, `News`.`sub_headline`, `News`.`published_date`, `News`.`created`, `News`.`modified`, `News`.`category_flags`, `News`.`sort_order`, `News`.`is_public_forum`, `News`.`comment_count`, `News`.`is_bignews`, `News`.`is_mustread`, `News`.`summary`, `News`.`category_id`, `News`.`locale`, `News`.`reference`, `News`.`uploaded_by`, `News`.`source`, `News`.`pradesh_id`, `Hospital`.`id`, `Hospital`.`name`, `Hospital`.`image`, `Hospital`.`logo`, `Hospital`.`description`, `Hospital`.`slug`, `Hospital`.`type`, `Hospital`.`phone`, `Hospital`.`address`, `Hospital`.`fax`, `Hospital`.`email`, `Hospital`.`website`, `Hospital`.`lat`, `Hospital`.`long`, `Hospital`.`bed_icu`, `Hospital`.`bed_emergency`, `Hospital`.`bed_general`, `Hospital`.`has_appointment`, `Hospital`.`online_appointment_url`, `Hospital`.`published`, `Hospital`.`created`, `Hospital`.`modified`, `Hospital`.`district`, `Hospital`.`views`, `Hospital`.`sort_order`, `Hospital`.`speciality`, `Hospital`.`established_date`, `Hospital`.`featured`, `Hospital`.`verified`, `Hospital`.`recommendations`, `Hospital`.`is_home`, `Hospital`.`is_appointment`, `Hospital`.`is_landing`, `Hospital`.`is_lab`, `Hospital`.`notification_emails`, `Hospital`.`sponsored`, `Hospital`.`ratings`, `Hospital`.`country_id`, `Hospital`.`opd_rate`, `Hospital`.`state_id`, `Hospital`.`city_id`, `Hospital`.`opd_hd_rate`, `Hospital`.`appointment_graphics`, `Hospital`.`opd_hospital_rate`, `Hospital`.`hospital_category_id`, `Hospital`.`expiry_time`, `Hospital`.`boost_expiry_time`, `Doctor`.`id`, `Doctor`.`type`, `Doctor`.`salutation`, `Doctor`.`first_name`, `Doctor`.`last_name`, `Doctor`.`nmc_number`, `Doctor`.`slug`, `Doctor`.`description`, `Doctor`.`email`, `Doctor`.`phone`, `Doctor`.`website`, `Doctor`.`image`, `Doctor`.`speciality`, `Doctor`.`qualification`, `Doctor`.`published`, `Doctor`.`allow_email_contact`, `Doctor`.`views`, `Doctor`.`sort_order`, `Doctor`.`allow_online_appontments`, `Doctor`.`online_appointment_url`, `Doctor`.`created`, `Doctor`.`modified`, `Doctor`.`academy`, `Doctor`.`temp_address`, `Doctor`.`permanent_address`, `Doctor`.`trainings`, `Doctor`.`opd_timings`, `Doctor`.`gender`, `Doctor`.`education`, `Doctor`.`membership`, `Doctor`.`experience`, `Doctor`.`journal`, `Doctor`.`award`, `Doctor`.`socialmedia`, `Doctor`.`featured`, `Doctor`.`verified`, `Doctor`.`recommendations`, `Doctor`.`consult_online`, `Doctor`.`profile_published`, `Doctor`.`articles_journals`, `Doctor`.`years_practiced`, `Doctor`.`address`, `Doctor`.`nmc_verified`, `Doctor`.`nmc_not_found`, `Doctor`.`fees`, `Doctor`.`second_opinion`, `Doctor`.`pro`, `Doctor`.`medical_council_document`, `Doctor`.`is_dead`, `Doctor`.`consult_graphics`, `Doctor`.`appointment_graphics`, `Doctor`.`has_appointment`, `Doctor`.`is_specialist`, `Doctor`.`is_home`, `Doctor`.`is_appointment`, `Doctor`.`is_consult`, `Doctor`.`is_landing`, `Doctor`.`start_year`, `Doctor`.`register_online_consultant`, `Doctor`.`pan_number`, `Doctor`.`boost_expiry_time`, (CONCAT(`Doctor`.`salutation`," ", `Doctor`.`first_name`, " ", `Doctor`.`last_name`)) AS `Doctor__name`, (CONCAT(`Doctor`.`salutation`," ", `Doctor`.`first_name`, " ", `Doctor`.`last_name`, " - ",`Doctor`.`speciality`, " (NMC#",`Doctor`.`nmc_number`,")")) AS `Doctor__select_name`, `Pharmaceutical`.`id`, `Pharmaceutical`.`user_id`, `Pharmaceutical`.`name`, `Pharmaceutical`.`slug`, `Pharmaceutical`.`description`, `Pharmaceutical`.`image`, `Pharmaceutical`.`address`, `Pharmaceutical`.`phone`, `Pharmaceutical`.`email`, `Pharmaceutical`.`website`, `Pharmaceutical`.`published`, `Pharmaceutical`.`created`, `Pharmaceutical`.`modified`, `Pharmaceutical`.`views`, `Pharmaceutical`.`allow_brand_promotion`, `Pharmaceutical`.`sponsored`, `Pharmaceutical`.`verified`, `Pharmaceutical`.`notification_emails`, `Pharmaceutical`.`expiry_time`, `Pharmaceutical`.`boost_expiry_time`, `Pharmaceutical`.`unlimited_brands_promotion`, `User`.`id`, `User`.`role_id`, `User`.`name`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`activation_code`, `User`.`active`, `User`.`blood_group`, `User`.`weight`, `User`.`gender`, `User`.`height`, `User`.`phone`, `User`.`session_token`, `User`.`address`, `User`.`oauth`, `User`.`oauth_id`, `User`.`deviceID`, `User`.`created`, `User`.`modified`, `User`.`dob`, `User`.`deviceName`, `User`.`contact_email`, `User`.`image`, `User`.`description`, `User`.`hospital_id`, `User`.`pharmaceutical_id`, `User`.`doctor_id`, `User`.`phone_verified`, `User`.`country_id`, `User`.`email_verified`, `User`.`social_fb`, `User`.`social_twitter`, `User`.`show_news_bio`, `User`.`force_pwd_change`, `User`.`last_logged_in`, `User`.`signup_device`, `User`.`firebase_token`, `User`.`surgical_distributor_id`, `User`.`forum_likes`, `User`.`login_device`, `User`.`login_date`, `User`.`login_version`, `User`.`oauth_facebook`, `User`.`oauth_google`, `User`.`verification_code`, `User`.`geo_lt`, `User`.`geo_lng`, `Uploader`.`id`, `Uploader`.`role_id`, `Uploader`.`name`, `Uploader`.`username`, `Uploader`.`email`, `Uploader`.`password`, `Uploader`.`activation_code`, `Uploader`.`active`, `Uploader`.`blood_group`, `Uploader`.`weight`, `Uploader`.`gender`, `Uploader`.`height`, `Uploader`.`phone`, `Uploader`.`session_token`, `Uploader`.`address`, `Uploader`.`oauth`, `Uploader`.`oauth_id`, `Uploader`.`deviceID`, `Uploader`.`created`, `Uploader`.`modified`, `Uploader`.`dob`, `Uploader`.`deviceName`, `Uploader`.`contact_email`, `Uploader`.`image`, `Uploader`.`description`, `Uploader`.`hospital_id`, `Uploader`.`pharmaceutical_id`, `Uploader`.`doctor_id`, `Uploader`.`phone_verified`, `Uploader`.`country_id`, `Uploader`.`email_verified`, `Uploader`.`social_fb`, `Uploader`.`social_twitter`, `Uploader`.`show_news_bio`, `Uploader`.`force_pwd_change`, `Uploader`.`last_logged_in`, `Uploader`.`signup_device`, `Uploader`.`firebase_token`, `Uploader`.`surgical_distributor_id`, `Uploader`.`forum_likes`, `Uploader`.`login_device`, `Uploader`.`login_date`, `Uploader`.`login_version`, `Uploader`.`oauth_facebook`, `Uploader`.`oauth_google`, `Uploader`.`verification_code`, `Uploader`.`geo_lt`, `Uploader`.`geo_lng`, `Category`.`id`, `Category`.`name`, `Category`.`image`, `Category`.`locale`, `Category`.`published`, `Category`.`show_in_menu`, `Category`.`created`, `Category`.`weight`, `Pradesh`.`id`, `Pradesh`.`name`, `Pradesh`.`slug`, `Pradesh`.`image`, `Pradesh`.`published`, `Seo`.`id`, `Seo`.`model`, `Seo`.`model_id`, `Seo`.`meta_title`, `Seo`.`meta_description`, `Seo`.`meta_keyword`, `Seo`.`image`, `Seo`.`created`, `Seo`.`modified` FROM `hamrodoctor_db`.`news` AS `News` LEFT JOIN `hamrodoctor_db`.`hospitals` AS `Hospital` ON (`News`.`hospital_id` = `Hospital`.`id`) LEFT JOIN `hamrodoctor_db`.`doctors` AS `Doctor` ON (`News`.`doctor_id` = `Doctor`.`id`) LEFT JOIN `hamrodoctor_db`.`pharmaceuticals` AS `Pharmaceutical` ON (`News`.`pharmaceutical_id` = `Pharmaceutical`.`id`) LEFT JOIN `hamrodoctor_db`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `hamrodoctor_db`.`users` AS `Uploader` ON (`News`.`uploaded_by` = `Uploader`.`id`) LEFT JOIN `hamrodoctor_db`.`categories` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `hamrodoctor_db`.`pradeshes` AS `Pradesh` ON (`News`.`pradesh_id` = `Pradesh`.`id`) LEFT JOIN `hamrodoctor_db`.`seos` AS `Seo` ON (`Seo`.`model_id` = `News`.`id` AND `Seo`.`model` = 'News') WHERE `News`.`id` = 20956 LIMIT 1 |
|
1 |
1 |
0 |