User:Johshh

Babel user information
nb-5 Denne brukeren behersker norsk bokmål på profesjonelt nivå. nn-5 Denne brukaren meistrar nynorsk på eit profesjonelt nivå. en-4 This user has near native speaker knowledge of English. da-3 Denne bruger har et avanceret kendskab til dansk. sv-2 Den här användaren har medelgoda kunskaper i svenska. de-0 Dieser Benutzer beherrscht Deutsch nicht (oder versteht es nur mit beträchtlichen Schwierigkeiten). he-0 משתמש זה אינו מבין עברית (או מבין אותה בקשיים ניכרים). is-0 Þessi notandi talar ekki íslensku (á erfitt með að skilja hana eða kýs að tala hana ekki). nrn-0 This user has no knowledge of Norn (or understands it with considerable difficulty). se-0 Dát geavaheaddji máhttá davvisámegiela hui veaháš dahje ii máhte dan ollege. sma-0 Den här användaren förstår inte åarjelsaemien (eller förstår det bara med stor svårighet). smj-0 This user has no knowledge of julevsámegiella (or understands it with considerable difficulty). smn-0 Taat kevttee máttá uáli jo uccáá teikkâ ij määti ollágin anarâškielâ. sms-0 This user has no knowledge of nuõrttsääʹmǩiõll (or understands it with considerable difficulty). fkv-0 This user has no knowledge of kvääni (or understands it with considerable difficulty).
Users by language

IDs

• login URL (P11903)
• registration page URL (P11904)
• official jobs URL (P10311)
• official shop URL (P10225)
• privacy policy URL (P7101)
• website account on (P553)
• official observer status in organisation (P10624)
• geoshape (P3896)

IDs

NO, EN

Forklaringstekst

ID	Overskriftstekst	nummer
nyheter	https://www.nrk.no/nyheter/1.16668508	1.16668508
i	https://www.aftenposten.no/i/zEpklq	zEpklq
i	https://www.vg.no/i/0QR0M0	0QR0M0

proff.no purehelp regnskapstall

Forklaringstekst

Overskriftstekst	Overskriftstekst	Wikidata property
Driftsinntekter	25050000	???
Driftsresultat	-239k	operating income (P3362)
Sum egenkapital	15608000	???

Show all members of parlament that dose not have twitter account.

SELECT ?item ?itemLabel ?party ?partyLabel ?gender WHERE {
   ?item p:P39 ?statement.
   ?statement ps:P39 wd:Q9045502.
   ?statement pq:P2937 wd:Q108535431
   MINUS {
   ?item wdt:P2002 ?username . # select best only
   ?item p:P2002 ?ts . ?ts ps:P2002 ?username . optional { ?ts pq:P3744 ?followers . }
   optional {   ?ts prov:wasDerivedFrom [ pr:P813 ?date ] . }
   }                       .        
   ?item wdt:P102 ?party.
   ?party rdfs:label ?partyLabel.
   FILTER (lang(?partyLabel) = 'en')
   ?item wdt:P21 ?gender.
   SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE],en'. }
 }

Try it!

Show all members of World Economic Forum

SELECT ?item ?itemLabel ?party ?partyLabel ?image WHERE {
   ?item wdt:P27  wd:Q20  .
   ?item wdt:P10347 ?username . # select best only
   optional { ?item wdt:P102 ?party . }
   optional { ?item wdt:P18 ?image . }
   SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE],en'. }
 }

Try it!

List every church in norway,map "Stolen from https://no.wikipedia.org/wiki/Mal:Kart_over_norske_fyr"

#title:Liste over kirker i Norge
#defaultView:Map
SELECT DISTINCT ?id ?idLabel ?loc ?incept ?sentry ?send WHERE {
  ?id wdt:P31 wd:Q16970;
  wdt:P17 wd:Q20.
  OPTIONAL { ?id wdt:P625 ?loc. }
  OPTIONAL { ?id wdt:P729 ?sentry. }
  OPTIONAL { ?id wdt:P730 ?send. }
  OPTIONAL { ?id wdt:P571 ?incept. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nb". } # Helps get the label in your language, if not, then en language
}
ORDER BY ASC(?loc)

Liste over kirker i Norge

SELECT ?periodical ?periodicalLabel ?inceptionDate
WHERE
{
  ?periodical wdt:P31/wdt:P279* wd:Q1002697; # Instances of periodicals or their subclasses
  #?periodical wdt:P279* wd:Q11032 ;
              wdt:P17 wd:Q20;            # Located in Norway
              wdt:P571 ?inceptionDate.      # Inception date of the periodical
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],no". }
}
ORDER BY ?inceptionDate

Try it!