query-4e20615194dc4143c1988ae9cdf78877
Items I created
Use at
- https://query.wikidata.org/sparql
PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemAltLabel ?itemDescription ?familynameLabel ?givennameLabel ?nativename ?titleLabel ?subtitleLabel
WHERE
{
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:endpoint "www.wikidata.org" .
bd:serviceParam wikibase:limitContinuations "199". # change to limit total
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam mwapi:generator "allpages" .
bd:serviceParam mwapi:gaplimit "1" .
bd:serviceParam mwapi:list "usercontribs" .
bd:serviceParam mwapi:ucuser "Mzajac" .
bd:serviceParam mwapi:ucshow "new" .
bd:serviceParam mwapi:ucnamespace "0" .
bd:serviceParam mwapi:uclimit "1" .
bd:serviceParam mwapi:ucprop "title|timestamp|comment|size" .
?item wikibase:apiOutputItem "//api/query/usercontribs/item/@title" .
?timestamp wikibase:apiOutput "//api/query/usercontribs/item/@timestamp" .
?comment wikibase:apiOutput "//api/query/usercontribs/item/@comment" .
?size wikibase:apiOutput "//api/query/usercontribs/item/@size" .
}
FILTER BOUND(?item)
OPTIONAL { ?item wdt:P734 ?familyname. }
OPTIONAL { ?item wdt:P735 ?givenname. }
OPTIONAL { ?item wdt:P1476 ?title. }
OPTIONAL { ?item wdt:P1680 ?subtitle. }
OPTIONAL { ?item wdt:P1705 ?nativename. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
ORDER BY ?titleLabel ?nativename ?familynameLabel ?givennameLabel ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?comment")
v10("?familyname")
v3("?familynameLabel"):::projected
v11("?givenname")
v4("?givennameLabel"):::projected
v6("?item"):::projected
v5("?itemLabel"):::projected
v2("?nativename"):::projected
v9("?size")
v13("?subtitle")
v7("?timestamp")
v12("?title")
v1("?titleLabel"):::projected
c27(["//api/query/usercontribs/item/@timestamp"]):::literal
c14(["usercontribs"]):::literal
c6(["199"]):::literal
c16(["Mzajac"]):::literal
c2(["bd:serviceParam"]):::iri
c28(["//api/query/usercontribs/item/@comment"]):::literal
c10(["allpages"]):::literal
c37(["#91;AUTO_LANGUAGE#93;"]):::literal
c4(["www.wikidata.org"]):::literal
c18(["new"]):::literal
c23(["title|timestamp|comment|size"]):::literal
c25(["//api/query/usercontribs/item/@title"]):::literal
c20(["0"]):::literal
c12(["1"]):::literal
c29(["//api/query/usercontribs/item/@size"]):::literal
c8(["Generator"]):::literal
f0[["bound(?item)"]]
f0 --> v6
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c2 --"mwapi:endpoint"--> c4
c2 --"mwapi:limitContinuations"--> c6
c2 --"mwapi:api"--> c8
c2 --"mwapi:generator"--> c10
c2 --"mwapi:gaplimit"--> c12
c2 --"mwapi:list"--> c14
c2 --"mwapi:ucuser"--> c16
c2 --"mwapi:ucshow"--> c18
c2 --"mwapi:ucnamespace"--> c20
c2 --"mwapi:uclimit"--> c12
c2 --"mwapi:ucprop"--> c23
v6 --"mwapi:apiOutputItem"--> c25
v7 --"mwapi:apiOutput"--> c27
v8 --"mwapi:apiOutput"--> c28
v9 --"mwapi:apiOutput"--> c29
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P734".-> v10
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P735".-> v11
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P1476".-> v12
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P1680".-> v13
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P1705".-> v2
end
subgraph s2["http://wikiba.se/ontology#label"]
style s2 stroke-width:4px;
c2 --"mwapi:language"--> c37
end