User with only 1edit in SBL talk page

Fork of User with only 1edit in SWL talk page by HenriqueCrang

This query is marked as a draft This query has been published by HenriqueCrang.

SQL

use ptwiki_p;

select * from (

select user_name, page_title, count(*) as edits
from revision r inner join page p on r.rev_page = p.page_id 
inner join actor a on rev_actor = a.actor_id
inner join user u on actor_user = u.user_id
where
p.page_namespace = 9
and page_title = 'Spam-blacklist' 
# and page_title = 'Spam-whitelist'
group by page_id, user_name
order by 3 desc
) x where edits = 1

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...