Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P9737
(An Untitled Masterwork)
Active
Public
Actions
Authored by
matmarex
on Nov 25 2019, 7:07 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F31254533: raw.txt
Nov 25 2019, 7:07 PM
2019-11-25 19:07:03 (UTC+0)
Subscribers
None
-- 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
)
Event Timeline
matmarex
created this paste.
Nov 25 2019, 7:07 PM
2019-11-25 19:07:03 (UTC+0)
matmarex
mentioned this in
T239012: Remove autogeneration of Deletion summary.
.
Nov 25 2019, 7:15 PM
2019-11-25 19:15:12 (UTC+0)
Log In to Comment