You can’t directly query for the size as far as I know, but you can use
the longpages query page generator to get a list of the longest enwiki
pages, then filter the associated items for male authors. But this will
only get you about a hundred results until the longpages list is
exhausted (most of its results are linked to items we don’t care about),
and it won’t get you the actual size (and therefore the order of results
isn’t necessarily meaningful either, you just know they’re among the
longest pages).
SELECT ?item ?titleEn WHERE {
hint:Query hint:optimizer "None".
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "en.wikipedia.org";
wikibase:api "Generator";
mwapi:generator "querypage";
mwapi:gqppage "Longpages";
mwapi:gqplimit "max".
?title wikibase:apiOutput mwapi:title.
}
BIND(STRLANG(?title, "en") AS ?titleEn)
?sitelink schema:name ?titleEn;
schema:isPartOf <https://en.wikipedia.org/>;
schema:about ?item.
?item wdt:P31 wd:Q5;
wdt:P106 wd:Q36180;
wdt:P21 wd:Q6581097.
}
Try it! <https://query.wikidata.org/embed.html#SELECT %3Fitem %3FtitleEn
WHERE {%0A%20 hint%3AQuery hint%3Aoptimizer "None".%0A%20 SERVICE
wikibase%3Amwapi {%0A%20%20%20 bd%3AserviceParam wikibase%3Aendpoint
"en.wikipedia.org"%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20
wikibase%3Aapi
"Generator"%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20
mwapi%3Agenerator
"querypage"%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20
mwapi%3Agqppage
"Longpages"%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20
mwapi%3Agqplimit "max".%0A%20%20%20 %3Ftitle wikibase%3AapiOutput
mwapi%3Atitle.%0A%20 }%0A%20 BIND(STRLANG(%3Ftitle%2C "en") AS
%3FtitleEn)%0A%20 %3Fsitelink schema%3Aname
%3FtitleEn%3B%0A%20%20%20%20%20%20%20%20%20%20%20 schema%3AisPartOf
<https%3A%2F%2Fen.wikipedia.org%2F>%3B%0A%20%20%20%20%20%20%20%20%20%20%20
schema%3Aabout %3Fitem.%0A%20 %3Fitem wdt%3AP31
wd%3AQ5%3B%0A%20%20%20%20%20%20%20 wdt%3AP106
wd%3AQ36180%3B%0A%20%20%20%20%20%20%20 wdt%3AP21 wd%3AQ6581097.%0A}>
Cheers, Lucas
On 12.01.19 12:56, Nicolas VIGNERON wrote:
> Hi Reem,
>
> If this page
> https://www.mediawiki.org/wiki/Wikidata_Query_Service/User_Manual/MWAPI
> is up-o-date it's does not seem possible to get the article size of a
> wikipedia article (but I must I don't use and know "|wikibase:mwapi|"
> a lot, maybe it has or will changed).
>
> Cheers,
> Nicolas
>
> Le sam. 12 janv. 2019 à 12:16, Reem Al-Kashif <[email protected]
> <mailto:[email protected]>> a écrit :
>
> Hello!
>
> Hope this finds you well. I put together a query
>
> <https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FsitelinkEn%0A%0AWHERE%20%7B%0A%20%3Fitem%20wdt%3AP31%20wd%3AQ5.%0A%20%3Fitem%20wdt%3AP106%20wd%3AQ36180.%0A%20%3Fitem%20wdt%3AP21%20wd%3AQ6581097.%0A%20%3FsitelinkEn%20schema%3Aabout%20%3Fitem%3B%0A%20%20%09%09%09%20%20%20%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fen.wikipedia.org%2F%3E.%0A%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20%7D>
> to create a list of English Wikipedia articles about male writers.
> Is it possible to filter the results by size? For example,
> articles that are larger than or equal to 10k bytes?
>
> I understand that this is better done by PetScan, but my PetScan
> query
>
> <https://petscan.wmflabs.org/?language=en&project=wikipedia&depth=50&categories=Male%20writers&ns%5B0%5D=1&larger=10000&search_max_results=500&interface_language=en&&doit=>
> refuses to cooperate for a reason I don't know yet.. :/
>
> Thanks in advance.
>
> Best,
> Reem
>
> --
> *Kind regards,
> Reem Al-Kashif*
>
>
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> Virus-free. www.avg.com
>
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>
>
> _______________________________________________
> Wikidata mailing list
> [email protected] <mailto:[email protected]>
> https://lists.wikimedia.org/mailman/listinfo/wikidata
>
>
> _______________________________________________
> Wikidata mailing list
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata
