Wikipedie:Seznam rozcestníků

SQL

USE wikidatawiki_p;
SELECT rev_id, rev_page, page_title, page_namespace, comment_text, ctd_name
FROM change_tag
JOIN change_tag_def ON ctd_id = ct_tag_id
JOIN revision ON rev_id = ct_rev_id
JOIN page ON rev_page = page_id
JOIN comment ON rev_comment_id = comment_id
WHERE ctd_name IN ('WE-Framework gadget', 'InfoboxExport gadget', 'wikimedia-commons-app', 'distributed-game', 'dataDrainer')
AND page_namespace <> 0
AND NOT (ctd_name = 'WE-Framework gadget' AND comment_text LIKE '%WE-Framework gadget%');

SQL

Checking query status...