Pages containing "Brudnopis goscinny" on plwiki

SQL

#Resultset_1 ---- all
SELECT CONCAT('# [[Wikipedysta:', page_title, ']]') AS page_title, page_len, page_is_redirect, rev_timestamp, rev_user_text
FROM revision INNER JOIN page
ON (revision.rev_page = page.page_id)
WHERE page_title LIKE 'Brudnopis_gościnny/%'
AND page_namespace = 2
AND page_latest = rev_id
/*AND rev_timestamp < 20170613000000*/
ORDER BY rev_timestamp DESC;

#Resultset_2 ---- if the last revision timestamp is less than 2017-01-01-00-00-00
USE plwiki_p;
SELECT COUNT(page_title) AS old_ones
FROM revision INNER JOIN page
ON (revision.rev_page = page.page_id)
WHERE page_title LIKE 'Brudnopis_gościnny/%'
AND page_namespace = 2
AND page_latest = rev_id
/*AND rev_timestamp < 20170613000000;*/
SQL

Checking query status...
