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 page1.page_title AS 'Cím', af.afl_id, af.afl_user_text, af.afl_filter_id 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 WHERE revision1.rev_timestamp >= flaggedpage_pending1.fpp_pending_since #AND af.afl_filter = 64 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...