User:Asaf (WMF)/African women not on French Wikipedia
Appearance
here is a query for the top 100 (by # of other sitelinks) African women with articles on enwiki but not on frwiki. I am also pasting it here, for reference:
# top 100 (by # of other sitelinks) African women with articles on enwiki but not on frwiki SELECT ?item ?itemLabel ?badge ?badgeLabel ?links WHERE { ?item wdt:P31 wd:Q5 . # human ?item wdt:P21 wd:Q6581072 . # females VALUES ?country { wd:Q916 wd:Q912 wd:Q977 wd:Q1009 wd:Q1014 wd:Q1025 wd:Q1029 wd:Q1044 wd:Q1045 wd:Q1049 wd:Q657 wd:Q1019 wd:Q945 wd:Q115 wd:Q986 wd:Q1005 wd:Q1030 wd:Q117 wd:Q79 wd:Q1006 wd:Q262 wd:Q971 wd:Q1027 wd:Q1033 wd:Q258 wd:Q1036 wd:Q1032 wd:Q1037 wd:Q948 wd:Q929 wd:Q962 wd:Q967 wd:Q970 wd:Q974 wd:Q983 wd:Q1008 wd:Q1000 wd:Q1007 wd:Q924 wd:Q1013 wd:Q1016 wd:Q954 wd:Q40362 wd:Q114 wd:Q1028 wd:Q965 wd:Q1011 wd:Q1020 wd:Q1039 wd:Q1042 wd:Q963 wd:Q958 wd:Q953 wd:Q1041 wd:Q1050 } # all African countries ?item wdt:P27 ?country . # from one of those countries { ?wen schema:about ?item . ?wen schema:inLanguage "en" } # in English OPTIONAL { ?wfr schema:about ?item . ?wfr schema:inLanguage "fr" } # but not in French FILTER(!bound(?wfr)) # but not in French SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr" . } OPTIONAL { ?item wikibase:sitelinks ?links . } } ORDER BY DESC(?links) LIMIT 100
(as always, you can obtain results for other language pairs by modifying the lines mentioning "en" and "fr".)
Same, but only good/featured articles
[edit]here is a query for the top 100 (by # of other sitelinks) African women with good or featured articles on enwiki but not on frwiki. I am also pasting it here, for reference:
# top 100 (by # of other sitelinks) African women with good or featured articles on enwiki but not on frwiki (only a handful at the time of writing this) SELECT ?item ?itemLabel ?badge ?badgeLabel ?links WHERE { ?item wdt:P31 wd:Q5 . # human ?item wdt:P21 wd:Q6581072 . # females VALUES ?country { wd:Q916 wd:Q912 wd:Q977 wd:Q1009 wd:Q1014 wd:Q1025 wd:Q1029 wd:Q1044 wd:Q1045 wd:Q1049 wd:Q657 wd:Q1019 wd:Q945 wd:Q115 wd:Q986 wd:Q1005 wd:Q1030 wd:Q117 wd:Q79 wd:Q1006 wd:Q262 wd:Q971 wd:Q1027 wd:Q1033 wd:Q258 wd:Q1036 wd:Q1032 wd:Q1037 wd:Q948 wd:Q929 wd:Q962 wd:Q967 wd:Q970 wd:Q974 wd:Q983 wd:Q1008 wd:Q1000 wd:Q1007 wd:Q924 wd:Q1013 wd:Q1016 wd:Q954 wd:Q40362 wd:Q114 wd:Q1028 wd:Q965 wd:Q1011 wd:Q1020 wd:Q1039 wd:Q1042 wd:Q963 wd:Q958 wd:Q953 wd:Q1041 wd:Q1050 } # all African countries ?item wdt:P27 ?country . # from one of those countries { ?wen schema:about ?item . ?wen schema:inLanguage "en" } # in English OPTIONAL { ?wfr schema:about ?item . ?wfr schema:inLanguage "fr" } # but not in French FILTER(!bound(?wfr)) # but not in French ?wen wikibase:badge ?badge . # that have a badge (good/featured/etc.) on enwiki SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr" . } OPTIONAL { ?item wikibase:sitelinks ?links . } } ORDER BY DESC(?links) LIMIT 100
This is exactly it ! I can build on that. Thanks User:Asaf (WMF) Anthere (talk)