Pages edited – hembygdsföreningar

SQL

SELECT 
  COUNT(
    DISTINCT(r.rev_page)
  ) as num_pages 
FROM 
  wikidatawiki_p.revision r 
  JOIN wikidatawiki_p.comment c ON r.rev_comment_id = c.comment_id 
WHERE 
  r.rev_timestamp > '20190101000001' 
  AND r.rev_timestamp < '20191216000001' 
  AND r.rev_user_text = 'Alicia Fagerving (WMSE)' 
  AND (
    c.comment_text LIKE '%batch #8574%' # 1
    OR c.comment_text LIKE '%batch #8575%' # 2
    OR c.comment_text LIKE '%batch #8579%' # 3
    OR c.comment_text LIKE '%batch #8585%' # 4
    OR c.comment_text LIKE '%batch #8609%' # 5
    OR c.comment_text LIKE '%batch #8610%' # 6
    OR c.comment_text LIKE '%batch #8611%' # 7 
    OR c.comment_text LIKE '%batch #8612%' # enrich existing föreningar
    OR c.comment_text LIKE '%batch #8614%' # enrich existing förbund
  )
SQL

Checking query status...
