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
Hey Michael,
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
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