Untitled query #24943

SQL

select concat( "[[User:" , log_title, "]] - [https://en.wikipedia.org/wiki/Special:Special:Log/block&page=", log_title, " block log]  - [[Special:Blockuser/", log_title, "|block]]") user23, user_editcount, log_timestamp from logging join user on (log_title = user_name) where log_action = 'create' and length(log_title) > 30 and user_id not in (select ipb_user from ipblocks where ipb_user = user_id) and user_name not like "%~%" AND ( log_timestamp like "2018%" OR log_timestamp like "2017%") AND user_name not in (select gu_name from centralauth_p.globaluser where gu_name = user_name AND gu_locked = 1);
SQL

Checking query status...
