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
AND rev_timestamp < 20160128235959
ORDER BY rev_timestamp DESC;

#Resultset_2 ---- if the last revision timestamp is less than 2015-07-27-23-59-59
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 < 20150727235959;

#Resultset_3 ---- if the page lenght is 0
USE plwiki_p;
SELECT COUNT(page_title) AS empty_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 page_len = 0;

#Resultset_4 ---- if the page is a redirect
USE plwiki_p;
SELECT COUNT(page_title) AS redirect_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 page_is_redirect = 1;

#Resultset_5 ---- average page length
USE plwiki_p;
SELECT cast(AVG(page_len) as DECIMAL(10)) AS avg_page_len, cast(SUM(page_len) as DECIMAL(10)) AS sum_page_len
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;
SQL

Checking query status...
