select a.*,spell1 from (
select employeeid ,tdate,mntime,mxtime,eb_no,dept_id,desg_id,worker_name,last_name from
(
SELECT employeeid,SUBSTR(transaction_time,1,10) tdate,MIN(transaction_time) mntime,MAX(transaction_time) mxtime from tbl_alm_attendance_log taal 
WHERE SUBSTR(transaction_time,1,10)>'2023-03-25' 
and SUBSTR(transaction_time,1,10)<='2023-04-26' and reader_id in (1,2) and pending=1
group by employeeid,SUBSTR(transaction_time,1,10) order by employeeid 
) a,worker_master b where a.employeeid=b.eb_id and b.company_id=1
 order by employeeid ,tdate
) a,
(
select a.eb_id,spell1 from (
select eb_id,max(emp_shift_map_id) mxid from employee_shift_mapping where active_status=1
group by eb_id
) a,employee_shift_mapping b where  mxid=emp_shift_map_id order by a.eb_id
) b where employeeid =eb_id 
order by employeeid ,tdateTF0962023-03-27 insert into daily_attendance (attendance_date,attendance_mark,attendance_source,attendance_type,company_id,device_id,eb_code,
eb_id,eb_no,entry_time,exit_time,is_active,remarks,spell,spell_hours,status_id,worked_department_id,worked_designation_id,working_hours)
values ('2023-03-27','HD','B','R',1,4,'TF096',39,'TF096','2023-03-27 11:44:43','2023-03-27 19:07:14',1,
'Check','A-SHIFT',8,1,15,11,8)<br />
<b>Fatal error</b>:  Uncaught mysqli_sql_exception: INSERT command denied to user 'tarun'@'13.126.47.172' for table 'daily_attendance' in C:\xampp\htdocs\TALBOTMAIN\updatetime.php:79
Stack trace:
#0 C:\xampp\htdocs\TALBOTMAIN\updatetime.php(79): mysqli_query(Object(mysqli), ' insert into da...')
#1 {main}
  thrown in <b>C:\xampp\htdocs\TALBOTMAIN\updatetime.php</b> on line <b>79</b><br />