SQL
AخA
USE plwiki_p;
#SELECT page_namespace, CONCAT('[[User:',page_title,']]') AS page_title, page_len, page_is_redirect
SELECT CONCAT('# [[User:',page_title,']]') AS page_title#, rev_user_text
FROM page
LEFT JOIN `user` ON user_name = REPLACE(page_title, '_', ' ')
#LEFT JOIN revision ON page_id = rev_page
WHERE page_namespace = 2
#AND rev_parent_id = 0
AND page_is_redirect = 0
#AND page_len = 0
AND page_title NOT LIKE '%/%'
AND page_title NOT LIKE 'Śmigiel'
AND page_title NOT LIKE 'Gsn'
AND page_title NOT LIKE 'EOF'
AND page_title NOT LIKE 'Clermont'
AND page_title NOT LIKE 'Marta_Nowak'
AND page_title NOT RLIKE '(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)'
AND user_name IS NULL
#AND EXISTS (SELECT * FROM page AS p1 WHERE p1.page_namespace = 0 AND REPLACE(p1.page_title, '_', ' ') = REPLACE(user_name, '_', ' '))
ORDER BY page_len DESC;
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.