query-8f836a07477775201d7ab15135885f03
IDs EN, NO0QR0M0 https://www.vg.no/i/0QR0M0 i zEpklq https://www.aftenposten.no/i/zEpklq i https://www.nrk.no/serum/api/content/json/1.16668508 1.16668508 https://www.nrk.no/nyheter/1.16668508 nyheter API nummer Overskriftstekst ID Forklaringstekst regnskapstall purehelp proff.no??? 15608000 Sum egenkapital (P3362)operating income -239k Driftsresultat ??? 25050000 Driftsinntekter Wikidata property Overskriftstekst Overskriftstekst Forklaringstekst
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel (MAX(?members) AS ?latestMembers) (MAX(?time) AS ?latestTime) (MAX(?vedtekter) AS ?latestVedtekter) (MAX(?vedtektertime) AS ?latestVedtekterTime) WHERE {
?item wdt:P31 wd:Q43229; wdt:P17 wd:Q20.
MINUS { ?item wdt:P576 ?itemLabel. }
OPTIONAL { ?item p:P2124 ?statement. ?statement ps:P2124 ?members; pq:P585 ?time. }
OPTIONAL { ?item p:P6378 ?statement2. ?statement2 ps:P6378 ?vedtekter; pq:P585 ?vedtektertime. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,nb". }
}
GROUP BY ?item ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
v2("?itemLabel"):::projected
v9("?latestMembers")
v10("?latestTime")
v11("?latestVedtekter")
v12("?latestVedtekterTime")
v4("?members"):::projected
v3("?statement")
v6("?statement2")
v5("?time"):::projected
v7("?vedtekter"):::projected
v8("?vedtektertime"):::projected
c4(["wd:Q20"]):::iri
c2(["wd:Q43229"]):::iri
c12(["bd:serviceParam"]):::iri
c14(["#91;AUTO_LANGUAGE#93;,mul,nb"]):::literal
v1 --"p:direct/P31"--> c2
v1 --"p:direct/P17"--> c4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"p:direct/P576"--> v2
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."p:P2124".-> v3
v3 --"p:statement/P2124"--> v4
v3 --"p:qualifier/P585"--> v5
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."p:P6378".-> v6
v6 --"p:statement/P6378"--> v7
v6 --"p:qualifier/P585"--> v8
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c12 --"wikibase:language"--> c14
end
bind5[/"max(?members)"/]
v4 --o bind5
bind5 --as--o v9
bind6[/"max(?time)"/]
v5 --o bind6
bind6 --as--o v10
bind7[/"max(?vedtekter)"/]
v7 --o bind7
bind7 --as--o v11
bind8[/"max(?vedtektertime)"/]
v8 --o bind8
bind8 --as--o v12