Notice: Undefined variable: session_school_token in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 28
Notice: Undefined variable: session_school_token in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 38
Notice: Undefined variable: session_school_token in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 50
Notice: Undefined variable: session_school_token in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 60
select SEC_TO_TIME(SUM(TIME_TO_SEC(k.duration))) as total_duration,g.total_book_count,count(k.series_mstr_token) as number_of_lesson,h.name as sub_subject_name,a.create_date as last_login_date,a.student_name,
a.student_id,d.name as class_name,c.name as section_name,g.name as subject_name from student a,class b,section c,all_classes d,series e,subject f,all_subjects g,all_sub_subjects h,sub_subject i,
lesson_series_master j,lesson_master k where a.school_token='' and b.school_token=a.school_token and c.class_token=b.token and d.token=b.class_name and a.school_token=b.school_token and c.school_token=b.school_token and a.class_token=b.token and a.section_token=c.token and c.class_token=b.token and a.status='1' and b.status='1' and c.status='1' and a.firebase_token is not null and e.school_token=a.school_token and e.class_token=b.token and e.status='1' and e.token=f.series_token and a.school_token=f.school_token and a.class_token=f.class_token and f.name=g.token and g.sub_subject_status='Y' and f.token=i.subject_token and i.name=h.token and i.series_token=e.token and a.school_token=i.school_token and i.class_token=a.class_token and g.sub_subject_status='Y'
and j.class_tkn_cmn=b.class_name and
j.series_tkn_cmn=e.name and
j.subject_tkn_cmn=f.name and
j.sub_subject_tkn_cmn=i.name
and k.series_mstr_token=j.token
group by g.name,a.create_date,a.student_name,a.student_id,d.name,c.name,k.series_mstr_token,h.name,g.total_book_count
union all
select SEC_TO_TIME(SUM(TIME_TO_SEC(k.duration))) as total_duration,g.total_book_count,count(k.series_mstr_token) as number_of_lesson,'NA' as sub_subject_name,a.create_date as last_login_date,a.student_name,a.student_id,d.name as class_name,
c.name as section_name,g.name as subject_name from student a,class b,section c,all_classes d,series e,subject f,all_subjects g,lesson_series_master j,
lesson_master k where a.school_token='' and b.school_token=a.school_token and c.class_token=b.token and d.token=b.class_name and a.school_token=b.school_token and
c.school_token=b.school_token and a.class_token=b.token and a.section_token=c.token and c.class_token=b.token and a.status='1' and b.status='1' and c.status='1' and a.firebase_token is not null and e.school_token=a.school_token and e.class_token=b.token and e.status='1' and e.token=f.series_token and a.school_token=f.school_token and a.class_token=f.class_token and f.name=g.token and g.sub_subject_status='N'
and j.class_tkn_cmn=b.class_name and
j.series_tkn_cmn=e.name and
j.subject_tkn_cmn=f.name and
j.sub_subject_tkn_cmn='NULL' and
k.series_mstr_token=j.token
group by g.name,a.create_date,a.student_name,a.student_id,d.name,c.name,k.series_mstr_token,g.total_book_count
order by subject_name Notice: Undefined variable: session_school_token in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 70 Report OLS
LBF Publication Pvt.Ltd
OLS/OTT APP Utilization Chart(Subject Wise)
Notice: Undefined variable: current_session in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 151
08-12-2025
Notice: Undefined variable: school_name in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 162
Notice: Undefined variable: state_name in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 166
Notice: Undefined variable: post in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 175
Notice: Undefined variable: school_number in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 178
Notice: Undefined variable: whatsapp in /home4/otslbf/public_html/SuperAdmin/report-ots-ols-subjectwise.php on line 182