Find all images that are using the WLM2010 template uploaded after 2017-05-31

SQL

USE commonswiki_p;
SELECT 
  page_title AS filename,
  page_id AS page_id,
  img_timestamp AS timestamp,
  img_actor AS uploader
FROM 
  page,                         /* for host page, primary is page_id */
  templatelinks,                /* to identify where template is used, primary is tl_from which equals page_id */
  image                         /* to find upload date, primary is img_name which equals page_title */
WHERE  
  page_id = tl_from AND       /* host page includes the template */
  tl_namespace = 10 AND       /* template is in the template namespace */
  tl_from_namespace = 6 AND   /* host page is in the file namespace */
  tl_title in ('Wiki_Loves_Monuments_2010') AND /* template in use */
  page_title = img_name 
  
  /* AND   /* to find the files in the image table */
  /*(img_timestamp < 20170430140000 OR /* uploaded before first country started, 14:00 UTC 30 April */
  /*  img_timestamp > 20170701070000); /* or uploaded after the last country finished, 07:00 UTC 1 July */
SQL

Checking query status...
