Hi all, 

There are 2000 editors who have received access to 20 different online databases. We know the usernames of these editors and the url prefixes of the websites they were given access to.

We need to know:
- from July 18th 2014 to January 11th 2014
- on English Wikipedia
- for the cohort of 2000 TWL editors
- ...how many times did they add links to any of the 20 partner websites

I have my fingers crossed that Quarry can solve this but I need some help to write a query.  

Bonus queries:
1) In that date range, how many links did these editors add using partner websites on *all Wikipedias* (any language)
2) What is the baseline change in all external links on English Wikipedia in that date range

3) What is the baseline change in all external links on *all Wikipedias* since July 18th 2014

Thanks so much for any guidance on this!

Jake (Ocaasi)

The Wikipedia Library