query-1fc9c918e667a0ea1e51246b9d84a5f6

rq turtle/ttl

title:Translations relevant to the Khalili Collections partnership SELECT ?item1Label ?langname ?sitelink ?articleCreationDate WHERE { VALUES ?item1 {wd:Q3336241 wd:Q66455644 wd:Q66458747 wd:Q63160499 wd:Q66454754 wd:Q66456991 wd:Q66457023 wd:Q66458773 wd:Q66455051 wd:Q27763745 wd:Q92731365 wd:Q95639662 wd:Q11481067 wd:Q2982930 wd:Q46103484 wd:Q21664940 wd:Q11362747 wd:Q11566135 wd:Q106372429 wd:Q66455355 wd:Q6735263 wd:Q107060104 wd:Q13142198 wd:Q110621552 wd:Q3042743 wd:Q21074703 wd:Q113673240 wd:Q6735866 wd:Q107663626 wd:Q64746992 wd:Q16641327 wd:Q12810868 wd:Q2827531 wd:Q115048320 wd:Q4480950 wd:Q109811416 wd:Q122258635 wd:Q122067620} ?sitelink schema:about ?item1 . # get Wikimedia pages FILTER(CONTAINS(str(?sitelink), ".wikipedia.org/")) # only Wikipedia articles ?sitelink schema:inLanguage ?langcode; schema:name ?title ; schema:isPartOf ?site. OPTIONAL { ?language wdt:P218 ?langcode; rdfs:label ?langlabel FILTER(lang(?langlabel) = "en") } # Convert short code to full language name BIND(COALESCE(?langlabel, ?langcode) AS ?langname) BIND(REPLACE(SUBSTR(STR(?site), 9), '/', '') AS ?endpoint) OPTIONAL{ SERVICE wikibase:mwapi { bd:serviceParam wikibase:api "Generator" ; wikibase:endpoint ?endpoint ; mwapi:generator "allpages" ; mwapi:gapfrom ?title ; mwapi:gapto ?title ; mwapi:prop "revisions" ; mwapi:rvdir "newer" ; wikibase:limit "once" . ?t wikibase:apiOutput "revisions/rev/@timestamp" . ?o wikibase:apiOrdinal true } FILTER (?o = 0) BIND (xsd:dateTime(?t) AS ?articleCreationDate) }

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } ORDER BY DESC(?articleCreationDate) ?item1Label

Use at

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Translations relevant to the Khalili Collections partnership
SELECT ?item1Label ?langname ?sitelink ?articleCreationDate
WHERE {
VALUES ?item1 {wd:Q3336241 wd:Q66455644 wd:Q66458747 wd:Q63160499 wd:Q66454754 wd:Q66456991 wd:Q66457023 wd:Q66458773 wd:Q66455051 wd:Q27763745 wd:Q92731365 wd:Q95639662 wd:Q11481067 wd:Q2982930 wd:Q46103484 wd:Q21664940 wd:Q11362747 wd:Q11566135 wd:Q106372429 wd:Q66455355 wd:Q6735263 wd:Q107060104 wd:Q13142198 wd:Q110621552 wd:Q3042743 wd:Q21074703 wd:Q113673240 wd:Q6735866 wd:Q107663626 wd:Q64746992 wd:Q16641327 wd:Q12810868 wd:Q2827531 wd:Q115048320 wd:Q4480950 wd:Q109811416 wd:Q122258635 wd:Q122067620}
?sitelink schema:about ?item1 . # get Wikimedia pages
FILTER(CONTAINS(str(?sitelink), ".wikipedia.org/")) # only Wikipedia articles
?sitelink schema:inLanguage ?langcode; schema:name ?title ; schema:isPartOf ?site.
OPTIONAL { ?language wdt:P218 ?langcode; rdfs:label ?langlabel FILTER(lang(?langlabel) = "en") } # Convert short code to full language name
BIND(COALESCE(?langlabel, ?langcode) AS ?langname)
BIND(REPLACE(SUBSTR(STR(?site), 9), '/', '') AS ?endpoint)
OPTIONAL{
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Generator" ; 
    wikibase:endpoint ?endpoint ;
    mwapi:generator "allpages" ;
    mwapi:gapfrom ?title ;
    mwapi:gapto ?title ;
    mwapi:prop "revisions" ;
    mwapi:rvdir "newer" ;
    wikibase:limit "once" .
    ?t wikibase:apiOutput "revisions/rev/@timestamp" .
    ?o wikibase:apiOrdinal true
  } 
FILTER (?o = 0)
BIND (xsd:dateTime(?t) AS ?articleCreationDate)
}

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY DESC(?articleCreationDate) ?item1Label

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v14("?articleCreationDate"):::projected v12("?endpoint") v6("?item1") v2("?item1Label"):::projected v7("?langcode") v5("?langlabel") v11("?langname"):::projected v10("?language") v3("?o") v9("?site") v4("?sitelink"):::projected v13("?t") v8("?title") c11(["bd:serviceParam"]):::iri c16(["allpages"]):::literal c20(["revisions"]):::literal c22(["newer"]):::literal c24(["once"]):::literal c28(["true^^xsd:boolean"]):::literal c26(["revisions/rev/@timestamp"]):::literal c31(["#91;AUTO_LANGUAGE#93;,en"]):::literal c13(["Generator"]):::literal f0[["contains(str(?sitelink),'.wikipedia.org/')"]] f0 --> v4 bind1[/VALUES ?item1/] bind1-->v6 bind10(["wd:Q3336241"]) bind10 --> bind1 bind11(["wd:Q66455644"]) bind11 --> bind1 bind12(["wd:Q66458747"]) bind12 --> bind1 bind13(["wd:Q63160499"]) bind13 --> bind1 bind14(["wd:Q66454754"]) bind14 --> bind1 bind15(["wd:Q66456991"]) bind15 --> bind1 bind16(["wd:Q66457023"]) bind16 --> bind1 bind17(["wd:Q66458773"]) bind17 --> bind1 bind18(["wd:Q66455051"]) bind18 --> bind1 bind19(["wd:Q27763745"]) bind19 --> bind1 bind110(["wd:Q92731365"]) bind110 --> bind1 bind111(["wd:Q95639662"]) bind111 --> bind1 bind112(["wd:Q11481067"]) bind112 --> bind1 bind113(["wd:Q2982930"]) bind113 --> bind1 bind114(["wd:Q46103484"]) bind114 --> bind1 bind115(["wd:Q21664940"]) bind115 --> bind1 bind116(["wd:Q11362747"]) bind116 --> bind1 bind117(["wd:Q11566135"]) bind117 --> bind1 bind118(["wd:Q106372429"]) bind118 --> bind1 bind119(["wd:Q66455355"]) bind119 --> bind1 bind120(["wd:Q6735263"]) bind120 --> bind1 bind121(["wd:Q107060104"]) bind121 --> bind1 bind122(["wd:Q13142198"]) bind122 --> bind1 bind123(["wd:Q110621552"]) bind123 --> bind1 bind124(["wd:Q3042743"]) bind124 --> bind1 bind125(["wd:Q21074703"]) bind125 --> bind1 bind126(["wd:Q113673240"]) bind126 --> bind1 bind127(["wd:Q6735866"]) bind127 --> bind1 bind128(["wd:Q107663626"]) bind128 --> bind1 bind129(["wd:Q64746992"]) bind129 --> bind1 bind130(["wd:Q16641327"]) bind130 --> bind1 bind131(["wd:Q12810868"]) bind131 --> bind1 bind132(["wd:Q2827531"]) bind132 --> bind1 bind133(["wd:Q115048320"]) bind133 --> bind1 bind134(["wd:Q4480950"]) bind134 --> bind1 bind135(["wd:Q109811416"]) bind135 --> bind1 bind136(["wd:Q122258635"]) bind136 --> bind1 bind137(["wd:Q122067620"]) bind137 --> bind1 v4 --"schema:about"--> v6 v4 --"schema:inLanguage"--> v7 v4 --"schema:name"--> v8 v4 --"schema:isPartOf"--> v9 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v10 -."wdt:P218".-> v7 v10 --"rdfs:label"--> v5 end bind2[/"?langlabel?langcode"/] v5 --o bind2 v7 --o bind2 bind2 --as--o v11 bind3[/"replace(substring(str(?site),'9^^xsd:integer'),'/','')"/] v9 --o bind3 bind3 --as--o v12 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c11 -."mwapi:api".-> c13 c11 --"mwapi:endpoint"--> v12 c11 --"mwapi:generator"--> c16 c11 --"mwapi:gapfrom"--> v8 c11 --"mwapi:gapto"--> v8 c11 --"mwapi:prop"--> c20 c11 --"mwapi:rvdir"--> c22 c11 --"mwapi:limit"--> c24 v13 --"mwapi:apiOutput"--> c26 v3 --"mwapi:apiOrdinal"--> c28 end bind4[/"http://www.w3.org/2001/XMLSchema#dateTime(?t)"/] v13 --o bind4 bind4 --as--o v14 end subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c11 --"mwapi:language"--> c31 end