Recently active user sandboxes on cswiki

This query generates a wikitext list of all user sandboxes that were last changed less than 2 weeks ago, along with a direct link to the user's contributions, link to the user's talk page (which might be a red link so far), and an asterisk if the sandbox is new (i.e. was created within the last 2 weeks). The list is ordered by descending date of the sandbox's last modification, which is also shown.

SQL

select concat('# [[Speciální:Příspěvky/', replace(substring_index(page_title, '/', 1), '_', ' '), '|', replace(substring_index(page_title, '/', 1), '_', ' '), ']] ([[Wikipedista:', replace(page_title, '_', ' '), '|', (select date_format(rev_timestamp, '%Y-%m-%d') from cswiki_p.revision where rev_id = page_latest), ']] ', (select date_format(min(rev_timestamp), '%Y-%m-%d') from cswiki_p.revision where rev_page = page_id and rev_parent_id = 0), ')') 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

SQL

Checking query status...