Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
FoBe
.
Toggle Highlighting
SQL
SELECT CONCAT('[[',page1.page_title,']]') AS 'Cím', CONCAT(af.afl_user_text, IF(COUNT(DISTINCT actor.actor_name)>1, CONCAT(' + ', COUNT(DISTINCT actor.actor_name)-1,' további'), '') ) AS 'Szerkesztő', GROUP_CONCAT(DISTINCT actor.actor_name SEPARATOR ', ') FROM page as page1 INNER JOIN revision AS revision1 ON page1.page_id = revision1.rev_page INNER JOIN flaggedpage_pending AS flaggedpage_pending1 ON page1.page_id = flaggedpage_pending1.fpp_page_id INNER JOIN abuse_filter_log AS af ON af.afl_rev_id = revision1.rev_id INNER JOIN revision AS revision2 ON page1.page_id = revision2.rev_page INNER JOIN actor ON actor.actor_id = revision2.rev_actor WHERE revision1.rev_timestamp >= flaggedpage_pending1.fpp_pending_since AND af.afl_filter_id = 64 AND revision2.rev_timestamp >= flaggedpage_pending1.fpp_pending_since AND page1.page_namespace = 0 GROUP BY page1.page_title ORDER BY revision1.rev_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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...