SQL
x
SELECT CONCAT("[[Dyskusja:",page_title,"]]") AS page_title, page_len
FROM page
WHERE page_namespace = 1
AND page_is_redirect = 0
ORDER BY page_len DESC
LIMIT 100;
SELECT CONCAT("# [[Dyskusja wikipedysty:",page_title,"]]") AS page_title, page_len, rev_timestamp
FROM page, revision
WHERE page_latest = rev_id
AND page_title RLIKE '^([0-9A-F]{1,4}:){7,7}[0-9A-F]{1,4}'
AND page_namespace = 3
/*AND rev_timestamp < DATE_ADD(NOW(), INTERVAL -90 DAY)
AND page_len < 1000*/
ORDER by page_len;
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.