string(1341) "SELECT `user`.`id`, `slug`, `first_name`, `middle_name`, `last_name`, `featured_doctor_id`, `website`, `zip_code`, `telephone`, `gender`, `user`.`country_id`, `email`, `state_id`, `fax`, `profile_image`, `address_first`, `address_second`, `city`, `user`.`is_deleted`, `user`.`status`, `medical_school_id`, `speciality_id`, `hospital_affiliation`, `sub_speciality_id`, `major_activity`, `residency_training`, `fellowship`, `profile_rating`, `overall_rating`, `board_certified`, `language`, `group_practice`, `is_featured`, `is_top_featured`, `video_file_name`, `insurance_company_id`, `accept_new_patients`, `state`.`state_name`, `state`.`state_code`, `country`.`name` AS `country_name`, `speciality`.`speciality_name`, `company_name`, `school_name`, `embed_code` FROM `user` LEFT JOIN `dentist_profile` ON dentist_profile.user_id = user.id LEFT JOIN `state` ON state.id = user.state_id LEFT JOIN `profile_video` ON profile_video.user_id = user.id LEFT JOIN `country` ON country.id = user.country_id LEFT JOIN `speciality` ON speciality.id = dentist_profile.speciality_id LEFT JOIN `insurance_company` ON insurance_company.id = dentist_profile.insurance_company_id LEFT JOIN `medical_school` ON medical_school.id = dentist_profile.medical_school_id WHERE (`slug`='Brett-Williams-16692') AND (`user`.`is_deleted`='0') AND (`user`.`status`='1')"