uprawnieni pl.ws

Fork of interfaceadmin in userspace edits for pl.ws & mul.ws by Ankry

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

SQL

USE plwikisource_p;
SET @START = '20180705';
SET @START_1 = CONCAT(SUBSTR(@START,1,4)-1,SUBSTR(@START,5));
SELECT COUNT(rev_id) AS ilość, rocznie, rev_user_text AS user
	FROM revision JOIN page ON rev_page=page_id JOIN (
      SELECT COUNT(rev_id) AS rocznie, rev_user AS uid
		FROM revision JOIN page ON rev_page=page_id 
    	WHERE page_namespace IN (0,100,102,104) AND rev_user>0
    	GROUP BY uid
    	HAVING rocznie>=500
    ) A ON rev_user=uid LEFT JOIN (SELECT ug_user FROM user_groups WHERE ug_group='bot') B ON uid=ug_user
    WHERE page_namespace IN (0,100,102,104) AND rev_timestamp>@START_1 AND rev_timestamp<@START AND rev_user>0 AND ug_user IS NULL
    GROUP BY user
    HAVING ilość>=100
;

SQL

Checking query status...