Untitled query #72691

SQL

select u.user_id, u.user_registration, u.user_name, u.user_editcount
#select *
from user u
where u.user_name in 
  (SELECT DISTINCT p2.page_title as username FROM templatelinks t
  INNER JOIN linktarget lt
  ON lt.lt_id = t.tl_target_id
  LEFT JOIN page p
  ON p.page_namespace = lt.lt_namespace AND p.page_title = lt.lt_title
  INNER JOIN page p2
  ON t.tl_from  = p2.page_id AND p2.page_namespace = 3 AND p2.page_title NOT like "%/%"
   WHERE p.page_title LIKE "Dashboard.wikiedu.org_talk_course_link" AND lt.lt_namespace = 10)
and u.user_registration is NOT NULL
limit 20
SQL

Checking query status...
