User:Alicia Fagerving (WMSE)/Sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 22: | Line 22: | ||
. | . | ||
[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% | [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> | </div> | ||