Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P10177
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Addshore
on Jan 16 2020, 12:55 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F31514312: raw.txt
Jan 16 2020, 12:55 PM
2020-01-16 12:55:08 (UTC+0)
Subscribers
None
SELECT
/* SpecialRecentChanges::doMainQuery */
rc_id
,
rc_timestamp
,
rc_namespace
,
rc_title
,
rc_minor
,
rc_bot
,
rc_new
,
rc_cur_id
,
rc_this_oldid
,
rc_last_oldid
,
rc_type
,
rc_source
,
rc_patrolled
,
rc_ip
,
rc_old_len
,
rc_new_len
,
rc_deleted
,
rc_logid
,
rc_log_type
,
rc_log_action
,
rc_params
,
comment_rc_comment
.
comment_text
AS
`
rc_comment_text
`
,
comment_rc_comment
.
comment_data
AS
`
rc_comment_data
`
,
comment_rc_comment
.
comment_id
AS
`
rc_comment_cid
`
,
actor_rc_user
.
actor_user
AS
`
rc_user
`
,
actor_rc_user
.
actor_name
AS
`
rc_user_text
`
,
rc_actor
,
wl_user
,
wl_notificationtimestamp
,
page_latest
,
(
SELECT
Group_concat
(
ctd_name
SEPARATOR
', '
)
FROM
`
change_tag
`
JOIN
`
change_tag_def
`
ON
((
ct_tag_id
=
ctd_id
))
WHERE
ct_rc_id
=
rc_id
)
AS
`
ts_tags
`
,
ores_damaging_cls
.
oresc_probability
AS
`
ores_damaging_score
`
,
ores_goodfaith_cls
.
oresc_probability
AS
`
ores_goodfaith_score
`
FROM
`
recentchanges
`
JOIN
`
comment
`
`
comment_rc_comment
`
ON
((
comment_rc_comment
.
comment_id
=
rc_comment_id
))
JOIN
`
actor
`
`
actor_rc_user
`
ON
((
actor_rc_user
.
actor_id
=
rc_actor
))
LEFT
JOIN
`
watchlist
`
ON
(
wl_user
=
28859
AND
(
wl_title
=
rc_title
)
AND
(
wl_namespace
=
rc_namespace
)
)
LEFT
JOIN
`
page
`
ON
((
rc_cur_id
=
page_id
))
LEFT
JOIN
`
ores_classification
`
`
ores_damaging_cls
`
ON
(
ores_damaging_cls
.
oresc_model
=
11
AND
(
ores_damaging_cls
.
oresc_rev
=
rc_this_oldid
)
AND
ores_damaging_cls
.
oresc_class
=
1
)
LEFT
JOIN
`
ores_classification
`
`
ores_goodfaith_cls
`
ON
(
ores_goodfaith_cls
.
oresc_model
=
12
AND
(
ores_goodfaith_cls
.
oresc_rev
=
rc_this_oldid
)
AND
ores_goodfaith_cls
.
oresc_class
=
1
)
WHERE
rc_bot
=
0
AND
(
(
rc_this_oldid
=
page_latest
)
OR
rc_type
IN
(
3
,
142
)
)
AND
(
rc_type
!=
6
)
AND
rc_patrolled
=
0
AND
(
rc_namespace
IN
(
'12'
,
'120'
,
'146'
,
'640'
,
'828'
)
)
AND
(
rc_timestamp
>=
'20191216180112'
)
AND
(
rc_source
!=
'wb'
)
AND
rc_new
IN
(
0
,
1
)
ORDER
BY
rc_timestamp
DESC
LIMIT
500
;
Event Timeline
Addshore
created this paste.
Jan 16 2020, 12:55 PM
2020-01-16 12:55:08 (UTC+0)
Addshore
mentioned this in
T239192: WMFTimeoutException in Wikidata recentchanges
.
Log In to Comment