Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F4509185
crosswiki.sql
matmarex (Bartosz Dziewoński)
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
matmarex
Sep 21 2016, 4:24 PM
2016-09-21 16:24:26 (UTC+0)
Size
450 B
Referenced Files
None
Subscribers
None
crosswiki.sql
View Options
use
commonswiki
;
select
date
(
left
(
log_timestamp
,
8
))
as
date
,
count
(
*
)
as
crosswikiupload
from
(
select
logging
.
log_title
,
logging
.
log_user
,
logging
.
log_timestamp
,
logging
.
log_comment
,
ct_tag
from
logging
inner
join
change_tag
on
ct_log_id
=
log_id
and
ct_tag
=
'cross-wiki-upload'
where
logging
.
log_type
=
'upload'
and
logging
.
log_action
=
'upload'
and
logging
.
log_timestamp
between
'20150101'
and
'20160920'
)
t
group
by
left
(
log_timestamp
,
8
);
File Metadata
Details
Attached
Mime Type
text/plain
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4004327
Default Alt Text
crosswiki.sql (450 B)
Attached To
Mode
T144992: Find out how new anti-copyvio abusefilters are affecting uploads
Attached
Detach File
Event Timeline
Log In to Comment