Reviewed uncategoried templates by Perohanych

SQL

select concat('{{tl|', p.page_title, '}}'), p_cl.page_title, fr.*
from flaggedrevs fr
join user on fr_user = user_id
join page p on fr_page_id = p.page_id and p.page_namespace = 10 and p.page_is_redirect = 0
join revision_userindex on fr_rev_id = rev_id and rev_parent_id = 0
left join categorylinks on fr_page_id = cl_from
left join page p_cl on cl_to = p_cl.page_title
where user_name = 'Perohanych'
and p.page_title not like '%/документація'
and fr_flags = 'auto,dynamic'
group by fr_rev_id
order by fr_timestamp desc
having page_title = ''
limit 100

SQL

Checking query status...