Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CONCAT("[[User:", pl_title, "]]"), CONCAT("[[Wikipedia:", page_title, "]]"), COUNT(*) AS "Classes"
- FROM categorylinks
- JOIN page ON page_id=cl_from
- JOIN pagelinks ON pl_from=page_id
- WHERE cl_to="United_States_Education_Program_courses,_2011_Q3"
- AND page_namespace=4 /* Wikipedia: */
- AND page.page_title NOT IN (
- "Wikipedia:United_States_Education_Program/Courses",
- "Wikipedia:United_States_Education_Program/Courses/2011_Q3")
- /* links to user pages */
- AND pl_namespace=2 /* User: */
- AND pl_title NOT LIKE "%/%"
- AND pl_title!="Example_User"
- GROUP BY page_title;
Add Comment
Please, Sign In to add comment