Error: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'emcedubd_oldsite'@'localhost' for table `irfhrimy_emc_teacher_en`.`users`
SQL Query: SELECT `users`.`id`, `users`.`username`, `users`.`email`, `users`.`cell`,`teachers`.`id` AS TeacherId,`teachers`.`status` AS TeacherStatus, `teacher_personals`.`id` AS PerosnalId,`teacher_personals`.`first_name`,`teacher_personals`.`first_name_bn`,`department_heads`.`is_current_head`,`teacher_personals`.`department`,`teacher_personals`.`designation`,`teacher_personals`.`blood_group_id`,`teacher_personals`.`image`,`teacher_personals`.`joining_date` FROM `irfhrimy_emc_teacher_en`.`users`INNER JOIN `irfhrimy_emc_teacher_en`.`teachers` ON (`irfhrimy_emc_teacher_en`.`users`.`id` = `irfhrimy_emc_teacher_en`.`teachers`.`user_id`) INNER JOIN `irfhrimy_emc_teacher_en`.`teacher_personals` ON (`irfhrimy_emc_teacher_en`.`users`.`id` = `irfhrimy_emc_teacher_en`.`teacher_personals`.`user_id`) LEFT JOIN `irfhrimy_emc_teacher_en`.`department_heads` ON(`irfhrimy_emc_teacher_en`.`teachers`.`id` = `irfhrimy_emc_teacher_en`.`department_heads`.`teacher_id`) WHERE `irfhrimy_emc_teacher_en`.`users`.`status` != 0 AND `irfhrimy_emc_teacher_en`.`teachers`.`status` = 1 AND `irfhrimy_emc_teacher_en`.`teacher_personals`.`status` = 1 AND `irfhrimy_emc_teacher_en`.`users`.`type` = 5 AND `irfhrimy_emc_teacher_en`.`teacher_personals`.`department` = 8 ORDER BY `irfhrimy_emc_teacher_en`.`department_heads`.`is_current_head` DESC,`irfhrimy_emc_teacher_en`.`teacher_personals`.`designation` ASC, `irfhrimy_emc_teacher_en`.`teacher_personals`.`joining_date` ASC, `irfhrimy_emc_teacher_en`.`teacher_personals`.`first_name` ASC
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp