Untitled query #27867

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

SQL

USE fiwiki_p;
SELECT 
  page_id, 
  il_to, 
  i1.img_timestamp 
FROM 
  page, 
  categorylinks, 
  imagelinks LEFT JOIN commonswiki_p.image as i1 ON i1.img_name=il_to LEFT JOIN image as i2 ON i2.img_name=il_to
WHERE 
  page_id=cl_from 
  AND page_namespace=0 
  AND cl_to IN ("Luettelot_patsaista_ja_muistomerkeistä", "Luettelot_Suomen_julkisista_taideteoksista_ja_muistomerkeistä")
  AND il_from=cl_from 
  AND (i1.img_timestamp > 20180029203328 OR i2.img_timestamp > 20180029203328) 
GROUP BY il_to;

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