Page MenuHomePhabricator
Paste P9737

(An Untitled Masterwork)
ActivePublic

Authored by matmarex on Mon, Nov 25, 7:07 PM.
-- Note: the translation changed in 2016
use bgwiki;
select left(log_timestamp, 4), count(*),
sum(comment_text like 'текст:%' or comment_text like 'съдържанието беше:%')
from logging
left join comment on log_comment_id=comment_id
where log_type='delete' and log_action='delete'
group by left(log_timestamp, 4)
use cswiki;
select left(log_timestamp, 4), count(*), sum(comment_text like 'obsah byl:%')
from logging
left join comment on log_comment_id=comment_id
where log_type='delete' and log_action='delete'
group by left(log_timestamp, 4)
use nlwiki;
select left(log_timestamp, 4), count(*), sum(comment_text like 'De inhoud was:%')
from logging
left join comment on log_comment_id=comment_id
where log_type='delete' and log_action='delete'
group by left(log_timestamp, 4)
use plwiki;
select left(log_timestamp, 4), count(*), sum(comment_text like 'treść:%')
from logging
left join comment on log_comment_id=comment_id
where log_type='delete' and log_action='delete'
group by left(log_timestamp, 4)
use ptwiki;
select left(log_timestamp, 4), count(*), sum(comment_text like 'o conteúdo era:%')
from logging
left join comment on log_comment_id=comment_id
where log_type='delete' and log_action='delete'
group by left(log_timestamp, 4)
use thwiki;
select left(log_timestamp, 4), count(*), sum(comment_text like 'เนื้อหาเดิม:%')
from logging
left join comment on log_comment_id=comment_id
where log_type='delete' and log_action='delete'
group by left(log_timestamp, 4)