Hi Alex,

Sorry, I’m not entirely sure as I simply copied & slightly modified the SQL that someone else had written. Maybe you could edit it for the cats you want to use, run it, and see what you get back?

Michael 

On 18 Sep 2019, at 20:49, Alex Stinson <astinson@wikimedia.org> wrote:

Hey Michael, 

I see that you added documentation at: https://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments/Documentation/Send_a_mass_message#A_simple_worked_example,_sending_messages_to_Commons_users 

Does the query do subcategories or only the parent categories? (Sorry I don't speak SQL, so not sure where I would look for that). 

Cheers, 

Alex 

On Fri, Sep 6, 2019 at 5:46 AM Michael Maggs <michael@maggs.name> wrote:
If you had time to do a Quarry query pulling out editors for those 53 articles that would be great to use as an example we could document.  People could use that as a basis for all sorts of focussed WP targeting.

Michael

> On 5 Sep 2019, at 23:59, Federico Leva (Nemo) <nemowiki@gmail.com> wrote:
>
> Michael Maggs, 05/09/19 22:49:
>> I wonder whether you'd be able to construct a sample Quarry query based on https://quarry.wmflabs.org/query/38807 that could be used on the English Wikipedia?
>
> I could, but such things tend to become more difficult at the scale of the English Wikipedia. Already on the Italian Wikipedia some queries need to be simplified or they time out. So it's important to have in mind what audience is a priority and can have the most impact.
>
> For a list of just 53 places, as you shared, it should be doable.
>
> Federico


_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org


--
Alex Stinson 
Senior Program Strategist
Wikimedia Foundation
Twitter:@glamwiki/@sadads

Learn more about how the communities behind Wikipedia, Wikidata and other Wikimedia projects partner with cultural heritage organizations: https://outreach.wikimedia.org/wiki/GLAM 
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org