User:SQL/RFU/StatsQuery

SELECT user_name, 
       ipb_by_text, 
       cl_timestamp,
       ipb_reason
FROM   categorylinks 
       JOIN page 
         ON ( page_id = cl_from ) 
       JOIN user 
         ON ( user_name = page_title ) 
       JOIN ipblocks 
         ON ( ipb_user = user_id ) 
WHERE  cl_to = 'Requests_for_unblock' 
       AND cl_type = 'page' 
       AND page_namespace = '3';

SQLite3 (Display) Queries

SQLite3 Reason Query

SELECT Count(reason), 
       reason 
FROM   stats 
GROUP  BY reason 
ORDER  BY Count(reason) ASC;

SQLite3 Admin Query

SELECT Count(admin), 
       admin 
FROM   stats 
GROUP  BY admin 
ORDER  BY Count(admin) ASC;