Untitled query #86322

SQL

SET @username := "Buruneng";

SELECT REPLACE(lt_title, "_", " ") AS Title, COUNT(*) AS Items FROM revision_userindex
JOIN actor_revision ON rev_actor = actor_id
JOIN user ON user_id = actor_user
JOIN page ON rev_page = page_id
JOIN pagelinks ON page_id = pl_from
JOIN linktarget ON pl_target_id = lt_id
WHERE actor_name = @username AND page_namespace = 0 AND rev_parent_id = 0 AND lt_namespace = 0
AND NOT EXISTS (SELECT page_id FROM page WHERE page_title = lt_title)
GROUP BY Title
ORDER BY Items DESC
SQL

Checking query status...
