Special 1 - Quarry

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

Users < 400 edits that have registered in the last month that have edited common.js

SQL

SELECT user_name 
FROM   user 
WHERE  user_editcount < 401 
       AND user_registration > 20190302000000 
       AND (SELECT Count(rev_id) 
            FROM   revision_userindex 
                   JOIN page 
                     ON rev_page = page_id 
            WHERE  user_id = rev_user 
                   AND page_title like "%.js" 
                   AND page_namespace = 2) > 0 ;

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...