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;
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
    WHERE page_namespace IN (0, 100, 102, 104) AND rev_timestamp > '20170705' AND rev_user > 0
    GROUP BY user
    HAVING ilość >= 100
;
#SHOW tables;
SELECT * from user_groups limit 10;

SQL

Checking query status...