Number of photos by users

SQL

USE commonswiki_p;
SELECT
  actor_name, COUNT(rev_page)
FROM revision 
JOIN page ON page.page_id = revision.rev_page
JOIN actor ON actor.actor_id = revision.rev_actor
WHERE
   rev_timestamp >= 20180916180000 /* od konce FWS 2018 */
  AND
   rev_timestamp < 20200101000000 /* do začátku FWS 2019 */
  AND
      actor_name IN ("Frettie", "Aktron", "Anaj7", "Art Jarka", "Jklamo", "Juandev", "KKDAII", "Packa", "Pastorius", "Spock", "T.Bednarz")
  AND
   rev_parent_id=0   /* nově založené, tj. nemělo minulou revizi */
  AND
   page.page_namespace = 6   /* namespace 6 jsou File: */
GROUP BY actor_name
;
SQL

Checking query status...
