query-545e49f50251c998e5a07ede02dccfd2

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:Recently edited articles relevant to the Khalili Collections partnership
SELECT ?item1Label ?langname ?sitelink ?size ?lastEdited
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:rvprop "timestamp|size" .
    ?t wikibase:apiOutput "revisions/rev/@timestamp" .
    ?bytes wikibase:apiOutput "revisions/rev/@size" .
  }
BIND (xsd:dateTime(?t) AS ?lastEdited)
BIND (xsd:integer(?bytes) AS ?size)
}

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

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v13("?bytes") v11("?endpoint") v5("?item1") v2("?item1Label"):::projected v6("?langcode") v4("?langlabel") v10("?langname"):::projected v9("?language") v14("?lastEdited"):::projected v8("?site") v3("?sitelink"):::projected v14("?size"):::projected v12("?t") v7("?title") c10(["bd:serviceParam"]):::iri c15(["allpages"]):::literal c19(["revisions"]):::literal c24(["revisions/rev/@size"]):::literal c23(["revisions/rev/@timestamp"]):::literal c27(["#91;AUTO_LANGUAGE#93;,en"]):::literal c21(["timestamp|size"]):::literal c12(["Generator"]):::literal f0[["contains(str(?sitelink),'.wikipedia.org/')"]] f0 --> v3 bind1[/VALUES ?item1/] bind1-->v5 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 v3 --"schema:about"--> v5 v3 --"schema:inLanguage"--> v6 v3 --"schema:name"--> v7 v3 --"schema:isPartOf"--> v8 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v9 -."wdt:P218".-> v6 v9 --"rdfs:label"--> v4 end bind2[/"?langlabel?langcode"/] v4 --o bind2 v6 --o bind2 bind2 --as--o v10 bind3[/"replace(substring(str(?site),'9^^xsd:integer'),'/','')"/] v8 --o bind3 bind3 --as--o v11 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c10 -."mwapi:api".-> c12 c10 --"mwapi:endpoint"--> v11 c10 --"mwapi:generator"--> c15 c10 --"mwapi:gapfrom"--> v7 c10 --"mwapi:gapto"--> v7 c10 --"mwapi:prop"--> c19 c10 --"mwapi:rvprop"--> c21 v12 --"mwapi:apiOutput"--> c23 v13 --"mwapi:apiOutput"--> c24 end bind4[/"http://www.w3.org/2001/XMLSchema#dateTime(?t)"/] v12 --o bind4 bind4 --as--o v14 bind5[/"http://www.w3.org/2001/XMLSchema#integer(?bytes)"/] v13 --o bind5 bind5 --as--o v14 end subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c10 --"mwapi:language"--> c27 end