Fork of
未使用のカテゴリ 年を含まない
by FlatLanguage
This query is marked as a draft
This query has been published
by FlatLanguage.
SQL
AخA
SELECT
P.page_title,
P.page_id
FROM categorylinks
RIGHT JOIN page P ON cl_to = P.page_title
INNER JOIN (
SELECT rev_page, MIN(rev_id) AS first_rev_id
FROM revision
GROUP BY rev_page) rev_group
ON P.page_id = rev_group.rev_page
INNER JOIN revision first_rev
ON rev_group.rev_page = first_rev.rev_page
AND rev_group.first_rev_id = first_rev.rev_id
WHERE P.page_namespace = 14
AND P.page_is_redirect = 0
AND cl_to IS NULL
AND first_rev.rev_actor = 210075;
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.