top 10 kurzistů + kurzy

SQL

use cswiki_p;

select user_id, user_name, course_taken_count, upc_course_id, course_name
from 
(select user.user_id, user.user_name, courses.course_name, count(user.user_id) as course_taken_count
from ep_users_per_course as user_per_course
join user as user
on user.user_id=user_per_course.upc_user_id
join ep_courses as courses
on user_per_course.upc_course_id=courses.course_id
join ep_orgs as orgs
on course_org_id=org_id
where user_per_course.upc_role=0
group by user.user_id
order by course_taken_count desc
limit 10) AS top_10
inner join ep_users_per_course as user_per_course
on top_10.user_id=user_per_course.upc_user_id
WHERE user_per_course.upc_role=0
;
SQL

Checking query status...
