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

From MetaBase
Jump to navigation Jump to search
No edit summary
Tag: Reverted
No edit summary
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
* statistics for types of documents we have
WMSE things
<SPARQL tryit="1">
 
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
 
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
 
SELECT ?item ?itemLabel
 
WHERE
 
{
 
?item wbt:P17 wb:Q22660.
 
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,es,sv". }
[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">
</SPARQL>
* [[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]]
 
[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]
 
[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}}
 
.
 
.
 
.
 
.
 
.
 
[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]
</div>

Latest revision as of 13:26, 28 August 2024