Danh sách khóa học
Sắp xếp theo:
Từ khoá gợi ý: #TOPIK #Tiếng Hàn #Hội thoại #Tiếng Hàn Visang #Đề thi
Đăng ký nhận thông tin
Hãy để lại thông tin, chúng tôi sẽ gửi những thông tin mới nhất về khóa học và giáo trình đến bạn
AI Speak
AI Speak sẽ hỗ trợ bạn trong quá trình học tiếng Hàn cùng với hệ sinh thái Visang Education
1 x Application (96.59%) | 285ms |
1 x Booting (3.4%) | 10.05ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
select `ca`.*, `cal`.`ko_name`, `cal`.`vi_name`, `cal`.`en_name` from `m_course_categories` as `ca` inner join `m_course_categories_lang` as `cal` on `ca`.`id` = `cal`.`categoryid` where `ca`.`depth` = 1 and `ca`.`visible` = 1 and `ca`.`type` = 1 order by `ca`.`sortorder` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT distinct b.teacherid, a.firstname, b.courseid FROM m_user AS a inner join m_lmsdata_course_professor as b on a.id = b.teacherid
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM
(select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 1 AND lco.isused = 0 and lc.deleted = 0
UNION
select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_lmsdata_textbook lt ON lc.bookid = lt.id
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 3 AND lt.isused = 0 AND lco.isused = 0
) a WHERE a.learningstart <= 1745879504 AND 1745879504 <= a.learningend AND a.isused = 0 order by a.id desc
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 711 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 784 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 783 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 782 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 781 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 780 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 779 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 766 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 765 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 763 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 761 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 760 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 759 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 758 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 757 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 752 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 749 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 745 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 744 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 743 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 742 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 741 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 700 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 691 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 690 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 689 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 688 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 687 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 686 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 154 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 684 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 681 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 110 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 672 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 670 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 632 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 645 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 644 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 643 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 642 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 641 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 640 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 639 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 638 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 637 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 636 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 635 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 634 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 624 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 604 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 584 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 199 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 197 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 182 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 181 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 178 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 167 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 160 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 159 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 157 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 156 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 108 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 136 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT count(*) as total_student
FROM m_lmsdata_payment lp
JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1
JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50
JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid
JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5
JOIN m_course c ON c.id = ctx.instanceid
JOIN m_user u ON lp.userid = u.id
JOIN m_lmsdata_user lu ON u.id = lu.userid
WHERE c.id = 135 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM
(select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 1 AND lco.isused = 0 and lc.deleted = 0
UNION
select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_lmsdata_textbook lt ON lc.bookid = lt.id
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 3 AND lt.isused = 0 AND lco.isused = 0
) a WHERE a.learningstart <= 1745879504 AND 1745879504 <= a.learningend AND a.isused = 0 order by a.id desc
Metadata | |
---|---|
Backtrace |
|
select `vkl`.`sort_level` from `m_vi_korean_levels` as `vkl` inner join `m_vi_user_korean_levels` as `ukl` on `ukl`.`korean_level_id` = `vkl`.`id` where `ukl`.`user_id` is null limit 1
Metadata | |
---|---|
Backtrace |
|
(select `lc`.*, `lco`.`courseid` as `img_course_id`, `lco`.`price` as `root_price`, `lco`.`lecturecnt`, `u`.`firstname` from `m_lmsdata_class` as `lc` inner join `m_chatbot_suggest_course_mk` as `msc` on `msc`.`course_id` = `lc`.`id` and `msc`.`user_id` is null inner join `m_course` as `co` on `lc`.`courseid` = `co`.`id` inner join `m_lmsdata_course` as `lco` on `lc`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co2` on `lco`.`courseid` = `co2`.`id` inner join `m_course_categories` as `ca` on `ca`.`id` = `co2`.`category` left join `m_course_categories` as `ca2` on `ca2`.`parent` = `ca2`.`id` left join `m_lmsdata_course_professor` as `lcp` on `lcp`.`courseid` = `lco`.`id` inner join `m_user` as `u` on `u`.`id` = `lcp`.`teacherid` where `lc`.`type` = 1 and `lco`.`isused` = 0 and `lc`.`isused` = 0 and `lc`.`deleted` = 0 and `lc`.`learningstart` <= 1745879505 and `lc`.`learningend` >= 1745879505 and not exists (select 1 from `m_lmsdata_class` as `lc_inner` inner join `m_lmsdata_course` as `lco` on `lc_inner`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co` on `co`.`id` = `lc_inner`.`courseid` inner join `m_enrol` as `e` on `e`.`courseid` = `co`.`id` inner join `m_user_enrolments` as `ue` on `ue`.`enrolid` = `e`.`id` inner join `m_context` as `ctx` on `ctx`.`instanceid` = `co`.`id` inner join `m_role_assignments` as `ra` on `ra`.`contextid` = `ctx`.`id` and `ra`.`userid` = `ue`.`userid` inner join `m_role` as `ro` on `ra`.`roleid` = `ro`.`id` where `ro`.`id` = 5 and `ue`.`status` = 0 and `ctx`.`contextlevel` = 50 and `ra`.`userid` is null and (ue.timeend - (86400*lc_inner.reviewperiod)) > 1745879505 and `lc_inner`.`courseid` = `lc`.`courseid`) group by `lc`.`id` order by `lc`.`id` desc, `lc`.`timecreated` desc) union (select `lc`.*, `lco`.`courseid` as `img_course_id`, `lco`.`price` as `root_price`, `lco`.`lecturecnt`, `u`.`firstname` from `m_lmsdata_class` as `lc` inner join `m_course` as `co` on `lc`.`courseid` = `co`.`id` inner join `m_lmsdata_course` as `lco` on `lc`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co2` on `lco`.`courseid` = `co2`.`id` inner join `m_course_categories` as `ca` on `ca`.`id` = `co2`.`category` left join `m_course_categories` as `ca2` on `ca2`.`parent` = `ca2`.`id` left join `m_lmsdata_course_professor` as `lcp` on `lcp`.`courseid` = `lco`.`id` inner join `m_user` as `u` on `u`.`id` = `lcp`.`teacherid` where 0 = 1 and `lc`.`type` = 1 and `lco`.`isused` = 0 and `lc`.`isused` = 0 and `lc`.`deleted` = 0 and `lc`.`learningstart` <= 1745879505 and `lc`.`learningend` >= 1745879505 and not exists (select 1 from `m_lmsdata_class` as `lc_inner` inner join `m_lmsdata_course` as `lco` on `lc_inner`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co` on `co`.`id` = `lc_inner`.`courseid` inner join `m_enrol` as `e` on `e`.`courseid` = `co`.`id` inner join `m_user_enrolments` as `ue` on `ue`.`enrolid` = `e`.`id` inner join `m_context` as `ctx` on `ctx`.`instanceid` = `co`.`id` inner join `m_role_assignments` as `ra` on `ra`.`contextid` = `ctx`.`id` and `ra`.`userid` = `ue`.`userid` inner join `m_role` as `ro` on `ra`.`roleid` = `ro`.`id` where `ro`.`id` = 5 and `ue`.`status` = 0 and `ctx`.`contextlevel` = 50 and `ra`.`userid` is null and (ue.timeend - (86400*lc_inner.reviewperiod)) > 1745879505 and `lc_inner`.`courseid` = `lc`.`courseid`) group by `lc`.`id` order by `lc`.`id` desc, `lc`.`timecreated` desc) order by RAND()
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `cm`.`id` as `id`, `lcf`.`duration`, `cs`.`id` as `section_id`, `cs`.`name`, `lcf`.`id` as `contentId`, `cs`.`note_of_ai_speak`, `cs`.`visible`, `lcf`.`filepath` from `m_course_sections` as `cs` inner join `m_course_modules` as `cm` on `cs`.`id` = `cm`.`section` inner join `m_okmedia` as `o` on `cs`.`course` = `o`.`course` inner join `m_lcms_contents_file` as `lcf` on `o`.`contents` = `lcf`.`con_seq` where `cs`.`course` = 763 and `cs`.`section` != 0 and `cs`.`visible` = 1 and `cm`.`module` = 22 and `cm`.`instance` = o.id group by `id` order by `cs`.`section` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT cm.*, m.name as modname
FROM m_modules as m, m_course_modules as cm
WHERE cm.course = 763 AND cm.module = m.id AND m.visible = 1
Metadata | |
---|---|
Backtrace |
|
select distinct id, section, sequence from m_course_sections where course = 763 order by section ASC
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8063
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8064
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8065
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8066
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8067
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8068
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8069
Metadata | |
---|---|
Backtrace |
|
SELECT * FROM m_okmedia where id = 8070
Metadata | |
---|---|
Backtrace |
|
select a.id as mqs_id, a.course_id, a.section_id, a.exam_id, a.exam_score_min, a.exam_business_id, b.name as exam_name, b.score from m_question_section as a
inner join exams as b on a.exam_id = b.id
where a.course_id = 763 and (a.exam_business_id LIKE '-1,%' OR a.exam_business_id LIKE '%,-1,%' OR a.exam_business_id LIKE '%,-1' OR a.exam_business_id = '-1')
Metadata | |
---|---|
Backtrace |
|
select distinct percent_course from m_b2b_course_certificate where branch_id = -1
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1282
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1283
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1284
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1285
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1286
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1287
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1288
Metadata | |
---|---|
Backtrace |
|
select b.id as file_id, b.filepath, a.con_name, c.tags_id
from m_lcms_contents as a
inner join m_lcms_contents_file as b on a.id = b.con_seq
inner join m_tags_video_course as c on c.lcms_contents_id = a.id
where b.id = 1289
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 763 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 38095
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 763
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 670 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 34515
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 670
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 170 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 14305
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 170
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 160 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 13152
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 160
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 159 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 13146
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 159
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 161 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 13158
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 161
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 176 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 16132
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 176
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM m_context where instanceid = 645 and contextlevel = 50
Metadata | |
---|---|
Backtrace |
|
SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license
FROM m_files as f
LEFT JOIN m_files_reference as r ON f.referencefileid = r.id
WHERE f.contextid = 33807
AND f.component = 'local_courselist'
AND f.filearea = 'thumbnailimg'
AND f.itemid = 645
ORDER BY f.itemid, f.filepath, f.filename
Metadata | |
---|---|
Backtrace |
|
select `ca`.*, `cal`.`ko_name`, `cal`.`vi_name`, `cal`.`en_name` from `m_course_categories` as `ca` inner join `m_course_categories_lang` as `cal` on `ca`.`id` = `cal`.`categoryid` where `ca`.`depth` = 1 and `ca`.`visible` = 1 and `ca`.`type` = 3 order by `ca`.`sortorder` desc, `ca`.`id` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT distinct * FROM
(select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0
) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 95 order by a.id desc
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM
(select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0
) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 96 order by a.id desc
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM
(select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0
) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 92 order by a.id desc
Metadata | |
---|---|
Backtrace |
|
SELECT distinct * FROM
(select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category
from m_lmsdata_class lc
JOIN m_course mc ON lc.courseid = mc.id
JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id
JOIN m_course mc2 ON lco.courseid = mc2.id
JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3
left JOIN m_course_categories ca2 ON ca.parent = ca2.id
WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0
) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 93 order by a.id desc
Metadata | |
---|---|
Backtrace |
|
select `ca`.*, `cal`.`ko_name`, `cal`.`vi_name`, `cal`.`en_name` from `m_course_categories` as `ca` inner join `m_course_categories_lang` as `cal` on `ca`.`id` = `cal`.`categoryid` where `ca`.`depth` = 1 and `ca`.`visible` = 1 and `ca`.`type` = 1 order by `ca`.`sortorder` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▼ "page" => "4" ]
0 of 0array:1 [▼ "page" => "4" ]
0 of 0array:19 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [▶ 0 => "Root=1-681001d0-088cd6415152c7230c1c68b7" ] "host" => array:1 [▶ 0 => "www.masterkorean.vn" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-for" => array:1 [▶ 0 => "3.139.99.145" ] ]
0 of 0array:44 [▼ "USER" => "www-data" "HOME" => "/var/www" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_X_AMZN_TRACE_ID" => "Root=1-681001d0-088cd6415152c7230c1c68b7" "HTTP_HOST" => "www.masterkorean.vn" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_FOR" => "3.139.99.145" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "www.masterkorean.vn" "SERVER_PORT" => "80" "SERVER_ADDR" => "10.0.10.198" "REMOTE_PORT" => "13496" "REMOTE_ADDR" => "10.0.1.34" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REQUEST_SCHEME" => "http" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/usr/share/nginx/html/masterkorean.vn/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/course-all?page=4" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "page=4" "SCRIPT_FILENAME" => "/usr/share/nginx/html/masterkorean.vn/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745879504.9634 "REQUEST_TIME" => 1745879504 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 28 Apr 2025 22:31:45 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK2J0TkJsNHlXSlV4Z04ySlBHTWRWd1d5OXVOb0s3bGY5SEpjUGwwakl5cWUvc2pERGxsZldZOVRPVmgiLCJtYWMiOiIwOTkyMWI1NGUxZjgyODlmYWY4NTgzZTQwNjUyZGQxYTU5Yzc3OTkzYzZjYjAzM2M2YWJhODYzYzVjNjc4NTUxIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK ▶" 1 => "laravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2dEorZVFyQWtIYkFBZGZKZDJGZFFQZ3lxN0ozR2VYZ3J1b29yUzVOd2Q2TjdJR281eXRXUHlFSXpDRng4RSsiLCJtYWMiOiI1NTNhNTdjZjRhYmZlNTZhMGMzYTZhMzZhNDFiNGYxMmIzYzI5NGE3ZTA2YTY3MzI5ZGE4MGZhZjIwNTNhZDNhIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK2J0TkJsNHlXSlV4Z04ySlBHTWRWd1d5OXVOb0s3bGY5SEpjUGwwakl5cWUvc2pERGxsZldZOVRPVmgiLCJtYWMiOiIwOTkyMWI1NGUxZjgyODlmYWY4NTgzZTQwNjUyZGQxYTU5Yzc3OTkzYzZjYjAzM2M2YWJhODYzYzVjNjc4NTUxIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK ▶" 1 => "laravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2dEorZVFyQWtIYkFBZGZKZDJGZFFQZ3lxN0ozR2VYZ3J1b29yUzVOd2Q2TjdJR281eXRXUHlFSXpDRng4RSsiLCJtYWMiOiI1NTNhNTdjZjRhYmZlNTZhMGMzYTZhMzZhNDFiNGYxMmIzYzI5NGE3ZTA2YTY3MzI5ZGE4MGZhZjIwNTNhZDNhIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2 ▶" ] ]
0 of 0array:4 [▼ "_token" => "zzpqWfnY0ZrhXlLL52g2xB0AkioLeewUxlcVfPh9" "_previous" => array:1 [▶ "url" => "http://www.masterkorean.vn/course-all?page=4" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]