85285 - All links from a page

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

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;

SQL

Checking query status...