Wikimania2019 book icon.svg

Want to learn more about Metabase, share your ideas or get help? You're welcome to the Metabase Office Hours and chat with the Wikimedia Sverige team!

Friday, August 23, 9am Swedish time (convert time zone) – join in Google Meet

Friday, August 23, 4pm Swedish time (convert time zone) – join in Google Meet

User:Alicia Fagerving (WMSE)/Sandbox: Difference between revisions

From MetaBase
Jump to navigation Jump to search
No edit summary
No edit summary
 
(36 intermediate revisions by the same user not shown)
Line 1: Line 1:
[https://metabase.wikibase.cloud/query/#%23Items%20with%20non-unique%20Wikidata%20ID%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20DISTINCT%20%3Fitem1%20%3Fitem1Label%20%3Fitem2%20%3Fitem2Label%20%3Fvalue%20WHERE%20%7B%0A%20%20%3Fitem1%20wbt%3AP1%20%3Fvalue.%0A%20%20%3Fitem2%20wbt%3AP1%20%3Fvalue.%0A%0A%20%20FILTER%28%28%3Fitem1%20%21%3D%20%3Fitem2%29%20%26%26%20%28%28STR%28%3Fitem1%29%29%20%3C%20%28STR%28%3Fitem2%29%29%29%29%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%22.%20%7D%0A%7D not unique wdq]
<div style="background-color: #F5EBFF; padding: 1em 0.5em">
* [[Special:AllPages]]
* [[Special:ListProperties]]
* [https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FwhereLabel%20%3FlangLabel%20%28GROUP_CONCAT%28DISTINCT%20%3FtypeLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftypes%29%20%3Fwhen%20%3Fduration%20%3Fwikipage%20%28GROUP_CONCAT%28DISTINCT%20%3FpersonLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Fpersons%29%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP17%2a%20wb%3AQ22904.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP27%20%3Fwhere%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP52%20%3Flang%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP61%20%3Fduration%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP32%20%3Fperson%7D%20%23%20leader%2C%20eg%20in%20a%20workshop%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP33%20%3Fperson%7D%20%23%20speaker%2C%20eg%20in%20a%20presentation%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP19%20%3Fperson%7D%20%23%20author%2C%20eg%20of%20a%20video%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP11%20%3Fwikipage%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP15%20%3Fmainsubject%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%2Ces%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fperson%20rdfs%3Alabel%20%3FpersonLabel.%0A%20%20%20%20%3Fwhere%20rdfs%3Alabel%20%3FwhereLabel.%0A%20%20%20%20%3Flang%20rdfs%3Alabel%20%3FlangLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Ftype%20rdfs%3Alabel%20%3FtypeLabel.%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fduration%20%3FlangLabel%20%3FwhereLabel%20%3Ftypes%20%3Fwhen%20%3Fwikipage%0AORDER%20BY%20%3FitemLabel Glam wiki israel]


[[File:Pallas cat.JPG|thumb]]


Describing what was uploaded
[https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3FtypeLabel%20%3Fitem%20%3FitemLabel%20%3Ftime%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0A%3Fitem%20wbt%3AP15%20wb%3AQ21961.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Ftime%20%7D%20%23%20publication%20date%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D%0AORDER%20BY%20%3Ftype Published on OR]


Multiple in one upload
[https://metabase.wikibase.cloud/query/#%23defaultView%3AGraph%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Ftopic1%20%3Ftopic1Label%20%3Ftopic2%20%3Ftopic2Label%0A%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%20%20%28COUNT%28DISTINCT%20%3Fitem%29%20AS%20%3Fcount%29%20%3Ftopic1%20%3Ftopic2%0A%20%20WHERE%20%7B%0A%20%20%20%20%0A%20%20%20%20%3Fitem%20wbt%3AP15%20wb%3AQ21961.%20%23%20OPENREFINE%0A%20%20%20%20%3Fitem%20wbt%3AP15%20%3Ftopic1%2C%20%3Ftopic2%20.%20%0A%20%20%20%20FILTER%20%28wb%3AQ21961%20%21%3D%20%3Ftopic1%20%26%26%20wb%3AQ21961%20%21%3D%20%3Ftopic2%20%26%26%20%3Ftopic1%20%21%3D%20%3Ftopic2%29%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Ftopic1%20%3Ftopic2%0A%20%20ORDER%20BY%20DESC%28%3Fcount%29%0A%0A%7D%20AS%20%25results%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25results%0A%20%20%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D%0A CO-OCCURING TOPICS]




SESSION: {{q|Q23072}}


==SPARQL==
.
All resource types:
<SPARQL tryit="1">
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>


SELECT ?item ?itemLabel
.
WHERE
{
?item wbt:P5 wb:Q22211 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,[AUTO_LANGUAGE]". }
}
</SPARQL>


.


.


.


 
[https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3FlocationLabel%20%28GROUP_CONCAT%28DISTINCT%20%3ForgLabel%20%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Forganizers%29%20%3Fcoord%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ42.%0A%3Fitem%20wbt%3AP14%20%3Forg.%0A%3Fitem%20wbt%3AP27%20%3Flocation.%0A%3Flocation%20wbt%3AP1%20%3FlocationQ.%0A%3Forg%20wbt%3AP5%20wb%3AQ13%20.%0A%3Forg%20wbt%3AP1%20%3FwikidataQ.%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FwikidataQ%29%29%20AS%20%3Fwikidata_iri%29%0ABIND%28URI%28concat%28%22http%3A%2F%2Fwww.wikidata.org%2Fentity%2F%22%2C%20%3FlocationQ%29%29%20AS%20%3Flocation_wikidata_iri%29%0ASERVICE%20%3Chttps%3A%2F%2Fquery.wikidata.org%2Fsparql%3E%20%7B%0A%3Fwikidata_iri%20wdt%3AP361%20wd%3AQ3568028.%0A%3Flocation_wikidata_iri%20wdt%3AP625%20%3Fcoord%0A%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%2Ces%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Forg%20rdfs%3Alabel%20%3ForgLabel.%0A%20%20%20%20%3Flocation%20rdfs%3Alabel%20%3FlocationLabel%0A%20%20%7D%0A%7D%0A%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3FlocationLabel%20%3Fcoord conferences organized by wikimedia orgs]
[https://metabase.wikibase.cloud/query/#%23All%20resource%20types%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fitem%20%3FitemLabel%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%20wb%3AQ22211%20.%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2C%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D all res]
</div>
 
{| class="wikitable"
|-
! Required !! Property !! Example value !! Notes
|-
| r|| {{P|P5}} || {{Q|Q22186}}|| .notes
|-
| required|| <!-- part of --> {{P|P17}} || {{Q|Q38}} || .notes
|-
| required|| <!-- affected platforms --> .{{P|P13}}... || {{Q|Q84}} || .notes
|-
| required|| <!-- number of pages --> {{P|P53}} ||val || .notes
|-
| required||<!-- start time --> {{P|P6}} ||  ''2020-06''|| .notes
|-
| required||<!-- end time --> {{P|P7}} || ''2020-08''|| .notes
|-
| required||<!-- file source --> {{P|P58}} || {{Q|Q21929}}|| .notes
|-
| required||<!--resource type --> {{P|P57}} || {{Q|Q22190}} || .notes
|-
| required|| .property... || value || .notes
|-
| required|| .property... || value || .notes
|-
| required|| .property... || value || .notes
|-
| required|| .property... || value || .notes
|-
| required|| <!-- described att wikimedia page --> {{P|P11}} || ''wmse:Projekt:Fri musik på Wikipedia 2019/Global Metrics#Statens musikverk''|| .notes
|-
| required||<!-- commonscat --> {{P|P37}} || ''Media contributed by the Museum of Gothenburg: 2021-10''|| .notes
|-
| required||<!-- phabricator --> {{P|P47}} || ''T2212112'' || .notes
|-
| required||<!-- . -->property... || value || .notes
|-
| required||<!--main subject -->{{P|P15}} ||  {{Q|Q22119}} || .notes
|}
----------------
 
 
 
 
 
 
* ??????????? hotat kulturarv
* ??? :D Uppladdning
* ????? Metadatastädning
* ????Kameralån
* ?????? Wikifika
* ??? Uppsatser
* F2F denna? Q285582
* ?? Insamling
* ?? Testamentering
* Teknikpool ‒ endast objekt för den svenska dito finns på WD
* ? Konsultarbete
* ? Gemenskapsstöd
* ! Massuppladdning
------
* {{Q|Q19}} GLAM
* {{Q|Q17}} Auktoritetsdata
* {{Q|Q22134}} Länkade data
* {{Q|Q22135}} Öppna data
* {{Q|Q21909}} HBTQI
* {{Q|Q22117}} Upphovsrätt
* {{Q|Q22123}} Artificiell intelligens
* {{Q|Q22124}} Jämställdhet
* {{Q|Q22125}} Gender gap
* {{Q|Q22119}} arkeologi
* {{Q|Q22126}} musikhistoria
* {{Q|Q22116}} konsthistoria
* {{Q|Q22175}} hållbarhet
* {{Q|Q22128}} läromedel
* {{Q|Q22118}} öppen källkod
* {{Q|Q22131}} Fria licenser
* {{Q|Q22129}} karta
* {{Q|Q22130}} digitalisering
* {{Q|Q22121}} Bibliotek
* {{Q|Q22120}} skolbibliotek
* {{Q|Q22137}} arkiv
* {{Q|Q22138}} skola
* {{Q|Q22139}} äldre
* {{Q|Q22141}} utbildning
* {{Q|Q22142}} natur
* {{Q|Q22145}} Klimat
* {{Q|Q22147}} hembygdsrörelsen
* {{Q|Q22148}} översättning
* {{Q|Q22150}} EU
* {{Q|Q22151}} FN
* {{Q|Q22154}} OECD
* {{Q|Q22155}} openAccess
* {{Q|Q22156}} Kulturarv
* {{Q|Q22157}} Fornminnen
* {{Q|Q41}} Skrivstuga
* {{Q|Q142}} Fototävling
* {{Q|Q22159}} API
* {{Q|Q48}} Presentationer
* {{Q|Q65}} Föreläsningar
* {{Q|Q22160}} Referenslitteratur
* {{Q|Q22158}} Länsstyrelser
* {{Q|Q22161}} Runstenar
* {{Q|Q22162}} Flygfoto
* {{Q|Q22163}} Photowalk
* {{Q|22170}} Inspiration
* {{Q|22171}} Ackreditering
* {{Q|22169}} kyrkligt kulturminne (endast Sverige)
* {{Q|22168}} Fotografering
* {{Q|22167}} Skrivtävling
* {{Q|22166}} forskning
* {{Q|22165}} studieförbund / bildningsförbund
* {{Q|22164}} gräsrotsfinansiering
* {{Q|22153}} HR
* {{Q|22152}} digital marketing
* {{Q|22149}} fundraising
* {{Q|22146}} fiscal sponsorship
* {{Q|22144}} konst
* {{Q|22143}} folkhögskola
* {{Q|22140}} universitet
* {{Q|22136}} fallstudie
* {{Q|22133}} panoramafrihet
* {{Q|22122}} religionshistoria
* {{Q|22127}} lokalhistoria
* {{Q|22132}} regionalhistoria

Latest revision as of 12:11, 26 June 2024

not unique wdq

Pallas cat.JPG

Published on OR

CO-OCCURING TOPICS


SESSION: The National Library of Israel: a home for Wikimedians (Q23072)

.

.

.

.

.

conferences organized by wikimedia orgs

Retrieved from "https://metabase.wikibase.cloud/w/index.php?title=User:Alicia_Fagerving_(WMSE)/Sandbox&oldid=26259"