Fork of
https://quarry.wmflabs.org/
by Count Count
This query is marked as a draft
This query has been published
by Count Count.
SQL
AخA
USE dewiki_p;
select
actor_name,
rc_timestamp as CreationTime,
rc_title as Title,
rc_comment.comment_text
from recentchanges
inner join comment as rc_comment on rc_comment_id = rc_comment.comment_id
inner join actor on actor_id = rc_actor
where
rc_new = 1
and rc_namespace = 0
and rc_comment.comment_text like '%gemäß Belegen%'
order by rc_timestamp desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.