top 10 kurzistů + kurzy

SQL

use cswiki_p;

SELECT *
from 
(select user.user_id, 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
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
user_per_course.upc_role=0
;
SQL

Checking query status...
