select concat('# [[Speciální:Příspěvky/', replace(substring_index(page_title, '/', 1), '_', ' '), '|', replace(substring_index(page_title, '/', 1), '_', ' '), ']] ([[Diskuse s wikipedistou:', replace(substring_index(page_title, '/', 1), '_', ' '), '|d]] [[Wikipedista:', replace(page_title, '_', ' '), '|', (select date_format(rev_timestamp, '%Y-%m-%d') from cswiki_p.revision where rev_id = page_latest), ']]', if((select min(rev_timestamp) from cswiki_p.revision where rev_page = page_id and rev_parent_id = 0) > timestamp(date_sub(now(), interval 2 week)), ' *', ''), ')') as wikitext from cswiki_p.page where page_namespace = 2 and page_title LIKE '%/Pískoviště' and page_latest >= (select min(rev_id) from cswiki_p.revision where rev_timestamp > timestamp(date_sub(now(), interval 2 week))) order by page_latest desc