Fork of
All links from a page (incl. redirects)
by Doktor Wu
This query is marked as a draft
This query has been published
by Red Director.
SQL
x
set @id = 67591586;
SELECT page_title, MAX(rev_timestamp), COUNT(page_title) AS count,
SELECT pa_class
FROM page_assessments
WHERE pa_page_id = page_id
AND pa_class != 'Unknown'
LIMIT 1
) AS pa_class
FROM linktarget, pagelinks, page
JOIN revision_userindex ON page_id = rev_page
Where rev_actor = 100613
AND pl_from= @id
AND pl_target_id = lt_id
AND pl_from_namespace = 0
AND lt_namespace = 0
AND rev_timestamp BETWEEN 20240101000000 AND 20251231000000
ORDER BY count DESC
GROUP BY page_namespace, page_title, page_latest
Limit 300;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.