Untitled query #6569

This query is marked as a draft This query has been published by MusikAnimal.

SQL

SELECT af_id, af_user_text, af_timestamp, af_public_comments, af_hidden, af_actions
	FROM enwiki_p.abuse_filter
    JOIN enwiki_p.abuse_filter_log
    ON afl_filter = (
      SELECT afl_id FROM enwiki_p.abuse_filter_log
      WHERE afl_timestamp < 20151200000000
      ORDER BY afl_timestamp DESC
      LIMIT 1
    )
    WHERE af_enabled = 1
	AND af_deleted = 0;

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.

SQL

Checking query status...