SQL
x
SELECT CONCAT(CASE page_namespace
WHEN 0 THEN ''
WHEN 1 THEN 'Talk:'
WHEN 2 THEN 'User:'
WHEN 10 THEN 'Template:'
WHEN 14 THEN 'Category:'
ELSE CONCAT('{{ns:', page_namespace, '}}:')
END,
page_title)
FROM page
JOIN categorylinks ON cl_from = page_id
WHERE cl_to = 'Artikel_anu_kudu_dihapus'
AND EXISTS (SELECT 1
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
WHERE rev_page = page_id
AND actor_name != 'AABot')
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.