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

From MetaBase
Jump to navigation Jump to search
No edit summary
Tag: Reverted
No edit summary
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
*{{Q|Q22840}}
WMSE things
*{{Q|Q22839}}
*{{Q|Q22838}}
*{{Q|Q22837}}
*{{Q|Q22836}}
*{{Q|Q22835}}
*{{Q|Q22834}}
*{{Q|Q22833}}
*{{Q|Q22832}}
*{{Q|Q22831}}
*{{Q|Q22830}}
*{{Q|Q22829}}
*{{Q|Q22828}}
*{{Q|Q22827}}




test






*{{Q|Q22856}}
*{{Q|Q22855}}
*{{Q|Q22854}}
*{{Q|Q22853}}
*{{Q|Q22852}}
*{{Q|Q22851}}
*{{Q|Q22850}}
*{{Q|Q22849}}
*{{Q|Q22848}}
*{{Q|Q22847}}
*{{Q|Q22846}}
*{{Q|Q22845}}
*{{Q|Q22844}}
*{{Q|Q22843}}
*{{Q|Q22842}}
*{{Q|Q22841}}


[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]]


[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}}
-------------------------------------------------------------------------------
-----------------------------------------------
* {{Q|Q22697}}
* {{Q|Q22699}}
* {{Q|Q22701}}
* {{Q|Q22705}}
* {{Q|Q22708}}
* {{Q|Q22713}}
* {{Q|Q22718}}
* {{Q|Q22722}}
* {{Q|Q22723}}
* {{Q|Q22727}}
* {{Q|Q22730}}
* {{Q|Q22733}}
* {{Q|Q22739}}
* {{Q|Q22741}}
* {{Q|Q22743}}
* {{Q|Q22745}}
* {{Q|Q22746}}
* {{Q|Q22749}}
* {{Q|Q22751}}
* {{Q|Q22755}}
* {{Q|Q22757}}
* {{Q|Q22761}}
* {{Q|Q22766}}
* {{Q|Q22769}}
* {{Q|Q22771}}
* {{Q|Q22774}}
* {{Q|Q22783}}
* {{Q|Q22794}}
* {{Q|Q22796}}
* {{Q|Q22804}}
* {{Q|Q22805}}
* {{Q|Q22807}}
* {{Q|Q22809}}
* {{Q|Q22810}}
* {{Q|Q22817}}
* {{Q|Q22822}}


.


.


<SPARQL tryit="1">
.
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
 
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
.
SELECT ?item ?itemLabel ?when ?wikipage (GROUP_CONCAT(DISTINCT ?speakerLabel; SEPARATOR = ", ") AS ?speakers) (GROUP_CONCAT(DISTINCT ?mainsubjectLabel; SEPARATOR = ", ") AS ?topics)
 
WHERE
.
{
 
?item wbt:P17 wb:Q22660.
[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]
OPTIONAL {?item wbt:P23 ?when}
</div>
OPTIONAL {?item wbt:P33 ?speaker}
OPTIONAL {?item wbt:P11 ?wikipage}
OPTIONAL {?item wbt:P15 ?mainsubject}
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en,sv,es".
    ?item rdfs:label ?itemLabel.
    ?speaker rdfs:label ?speakerLabel.
    ?mainsubject rdfs:label ?mainsubjectLabel.
  }
}
GROUP BY ?item ?itemLabel ?when ?wikipage
ORDER BY ?when
</SPARQL>

Latest revision as of 10:27, 25 November 2024