[Impossible?] Statements created during Wiki Loves Monuments

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

Wikidata statements created during Wiki Loves Monuments CH

Task requested by Dario Crespi
https://it.wikipedia.org/wiki/Utente:Dario_Crespi_(WMIT)

But... WHERE THE F**** ARE THE STATEMENTS. Or just... WHERE THE F**** IS THE CONTENT? asd

Please improve this documentation:
https://www.mediawiki.org/wiki/Wikibase/Schema

SQL

# What I have to do with the content_address?
USE wikidatawiki_p;
SELECT
	revision.*,
	content.*
FROM
	revision,
    slots,
    content
WHERE
	rev_page = 534 # free software
    AND slot_revision_id = rev_id
    AND slot_content_id  = content_id
    AND slot_timestamp BETWEEN 1534795091 AND 1535759999
LIMIT 100;

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...