WLE 2019 Files by date

SQL

USE commonswiki_p;
--SELECT
--       COUNT(*) count,
--       DATE( (
--          SELECT   rev_timestamp
--          FROM     revision r
--          WHERE    rev_page = page_ID
--          ORDER BY rev_timestamp ASC
--          LIMIT    1
--       ) ) as creation_date
--FROM   page          p
--JOIN   categorylinks cl ON (page_id = cl_from)
--WHERE  cl_to = 'Images_from_Wiki_Loves_Earth_2019_in_Italy'
--OR     cl_to IN (
  			SELECT clsub.cl_to
            FROM   categorylinks clsub
  			WHERE  clsub.cl_from = 76980556 -- Images from stacippa
            AND    clsub.cl_type = 'subcat'
--       )
--AND    page_namespace = 6
--GROUP BY creation_date
--ORDER BY creation_date ASC;
SQL

Checking query status...
