G8able - Quarry

SQL

select * from page where page_namespace=2 
and not exists (select 1 from user where user_name=replace(SUBSTRING_INDEX(page.page_title,"/",1),"_"," "))
and not exists (select 1 from logging_logindex where log_namespace=2 and log_page=replace(SUBSTRING_INDEX(page.page_title,"/",1),"_"," ") and log_type="renameuser")
limit 100;
select * from logging_userindex where log_actor=(select actor_id from actor where actor_name="Céréales Killer") and log_timestamp like "20170102%" and log_page="0030520dv";
SQL

Checking query status...
