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 = '20170705';
SET @START_1 = CONCAT(SUBSTR(@START,1,4)-1,SUBSTR(@START,5));
SELECT @START_1;
/*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 OUTER 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>'20170705' AND rev_user>0 AND ug_user IS NULL
    GROUP BY user
    HAVING ilość>=100
;*/

SQL

Checking query status...