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 * FROM
( SELECT COUNT(rev_id) AS ilość, rev_user AS uid, rev_user_text AS user
	FROM revision JOIN page ON rev_page = page_id 
    WHERE page_namespace IN (0, 100, 102, 104) AND rev_timestamp > '20170705'
    GROUP BY uid
    HAVING ilość >= 100
);
#A JOIN
SELECT * FROM
( SELECT COUNT(rev_id) AS ilość, rev_user AS uid, rev_user_text AS user
	FROM revision JOIN page ON rev_page = page_id 
    WHERE page_namespace IN (0, 100, 102, 104)
    GROUP BY uid
    HAVING ilość >= 500
);
#B
#ON A.user = B.user
#;

SQL

Checking query status...