Adott napon módosított sablonok, modulok

SQL

select concat('# {{cikkszt|', case page_namespace when 10 then 'Sablon' when 828 then 'Modul' end,
':', replace(page_title, '_', ' '), '}} [https://pageviews.wmcloud.org/?project=hu.wikipedia.org&platform=all-access&agent=user&redirects=0&start=2024-08-01&end=2025-01-01&pages=', 
case page_namespace when 10 then 'Sablon' when 828 then 'Modul' end, ':', page_title, ' pageviews]') as res_row
from revision, page
where rev_page = page_id
and rev_timestamp like '20240826%'
and page_title not like '%/doc'
and page_title not like '19%'
and page_title not like '20%'
and page_namespace in (10, 828)
group by page_namespace, page_title
order by page_namespace, page_title
SQL

Checking query status...
