| 1 | SELECT `Teacher`.`id`, `Teacher`.`name`, `Teacher`.`name_bn`, `Teacher`.`user_id`, `Teacher`.`index_number`, `Teacher`.`salary_scale_code`, `Teacher`.`father_name`, `Teacher`.`mother_name`, `Teacher`.`spouse_name`, `Teacher`.`no_of_son`, `Teacher`.`no_of_daughter`, `Teacher`.`email`, `Teacher`.`present_address`, `Teacher`.`present_address_thana`, `Teacher`.`present_address_district`, `Teacher`.`permanent_address`, `Teacher`.`permanent_address_thana`, `Teacher`.`permanent_address_district`, `Teacher`.`national_id_no`, `Teacher`.`passport_number`, `Teacher`.`date_of_birth`, `Teacher`.`nationality`, `Teacher`.`religion`, `Teacher`.`gender`, `Teacher`.`blood_group`, `Teacher`.`marital_status`, `Teacher`.`contact_number`, `Teacher`.`teaching_designation`, `Teacher`.`teaching_subject`, `Teacher`.`joining_date`, `Teacher`.`mpo_code`, `Teacher`.`mpo_date`, `Teacher`.`current_salary_code`, `Teacher`.`bank_ac`, `Teacher`.`bank_name`, `Teacher`.`bank_branch_name`, `Teacher`.`institute_id`, `Teacher`.`photo_id`, `Teacher`.`is_deleted`, `Teacher`.`is_published`, `Teacher`.`sort_order`, `Teacher`.`created_user_id`, `Teacher`.`modified_user_id`, `Teacher`.`created`, `Teacher`.`modified`, `Media`.`id`, `Media`.`name`, `Media`.`caption`, `Media`.`url`, `Media`.`thumbnail_url`, `Media`.`image_url`, `Media`.`alt`, `User`.`id`, `User`.`name`, `User`.`institute_id`, `User`.`username`, `User`.`password`, `User`.`user_type`, `User`.`group_id`, `User`.`user_status`, `User`.`created`, `User`.`modified` FROM `dumoorco_biddaloy_sandbox`.`teachers` AS `Teacher` LEFT JOIN `dumoorco_biddaloy_sandbox`.`media` AS `Media` ON (`Teacher`.`photo_id` = `Media`.`id`) LEFT JOIN `dumoorco_biddaloy_sandbox`.`users` AS `User` ON (`Teacher`.`user_id` = `User`.`id`) WHERE `Teacher`.`is_published` = '1' AND `Teacher`.`institute_id` = 6 AND `Teacher`.`is_deleted` = '0' ORDER BY `Teacher`.`sort_order` ASC | | 27 | 27 | 14 |
| 2 | SELECT `Privacy`.`id`, `Privacy`.`name`, `Privacy`.`description`, `Privacy`.`default_value`, `Privacy`.`category`, `Privacy`.`privacy_for`, `Privacy`.`created`, `PrivacyDetail`.`id`, `PrivacyDetail`.`privacy_id`, `PrivacyDetail`.`institute_id`, `PrivacyDetail`.`user_id`, `PrivacyDetail`.`value`, `PrivacyDetail`.`created` FROM `dumoorco_biddaloy_sandbox`.`privacies` AS `Privacy` LEFT JOIN `dumoorco_biddaloy_sandbox`.`privacy_details` AS `PrivacyDetail` ON (`PrivacyDetail`.`privacy_id` = `Privacy`.`id` AND `PrivacyDetail`.`institute_id` = 6) WHERE 1 = 1 | | 5 | 5 | 19 |