Pages containing "Brudnopis goscinny" on plwiki

SQL

#Resultset_1 ---- all
USE plwiki_p;
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
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 < 20170101000000

#Resultset_3 ---- 
USE plwiki_p;
SELECT CONCAT('[[Wikipedysta:', page_title, ']]') AS page_title
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 EXISTS
(SELECT * FROM page AS p1
WHERE page_title = p1.page_title
AND p1.page_namespace = 0)
SQL

Checking query status...
