Untitled query #19384

SQL

use plwikisource_p;


SELECT * FROM
(SELECT
	page_title AS title,
    NZ.rev_page AS id,
    count(NZ.rev_id) AS edits,
    max(NZ.rev_timestamp) AS date
FROM
	(SELECT * FROM revision WHERE rev_comment LIKE '%Nieskorygowana%' OR rev_comment LIKE '%Skorygowan%' OR rev_comment LIKE '%Uwierzytelniona%' OR rev_comment LIKE '%Niesprawdzone%' OR rev_comment LIKE '%Bez korekty%') AS NZ JOIN page ON NZ.rev_page = page_id JOIN categorylinks ON NZ.rev_page = cl_from
WHERE
    cl_to = 'Uwierzytelniona'
GROUP by rev_page) AS A
WHERE
    edits = 2;
SQL

Checking query status...
