Untitled query #34589

SQL

USE enwiki_p;
SELECT DISTINCT pp_value,page_id,page_namespace,page_title,rev_id,rev_timestamp FROM page_props JOIN page ON pp_page = page_id JOIN revision ON page_id = rev_page
  WHERE pp_propname = 'score' AND (rev_timestamp BETWEEN '20190313185600' AND '20190320113000') GROUP BY page_title ORDER BY rev_timestamp;
USE enwikisource_p;
SELECT DISTINCT pp_value,page_id,page_namespace,page_title,rev_id,rev_timestamp FROM page_props JOIN page ON pp_page = page_id JOIN revision ON page_id = rev_page
  WHERE pp_propname = 'score' AND (rev_timestamp BETWEEN '20190313185600' AND '20190320113000') ORDER BY rev_timestamp;
USE plwikisource_p;
SELECT DISTINCT pp_value,page_id,page_namespace,page_title,rev_id,rev_timestamp FROM page_props JOIN page ON pp_page = page_id JOIN revision ON page_id = rev_page
  WHERE pp_propname = 'score' AND (rev_timestamp BETWEEN '20190313185600' AND '20190320113000') ORDER BY rev_timestamp;
SQL

Checking query status...
