4,467
edits
Main Page: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 31: | Line 31: | ||
Here are some examples of the types of items Metabase works with ([[Modelling/Example_items|'''Find more''']]) | Here are some examples of the types of items Metabase works with ([[Modelling/Example_items|'''Find more''']]) | ||
*'''[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%3Finstance_of%20%3Finstance_ofLabel%20%3Fpublished%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Finstance_of.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Fpublished.%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D [QUERY]] | *'''[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%3Finstance_of%20%3Finstance_ofLabel%20%3Fpublished%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Finstance_of.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Fpublished.%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D [QUERY]] {{Q|Q21}}''' | ||
** {{Q|Q43}}: {{Q|74}} | ** {{Q|Q43}}: {{Q|74}} | ||
** {{Q|Q76}}: {{Q|Q21951}} | ** {{Q|Q76}}: {{Q|Q21951}} | ||
** {{Q|Q62}}: {{Q|Q21958}} | ** {{Q|Q62}}: {{Q|Q21958}} | ||
*'''[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%3Fwhere%20%3FwhereLabel%20%3Fwhen%20%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ40%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP27%20%3Fwhere%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D [QUERY]] | *'''[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%3Fwhere%20%3FwhereLabel%20%3Fwhen%20%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ40%20.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP23%20%3Fwhen%7D%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP27%20%3Fwhere%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%2Cen%22.%20%7D%0A%7D [QUERY]] {{Q|40}}''' | ||
**{{Q|Q42}}: {{Q|Q21956}} | **{{Q|Q42}}: {{Q|Q21956}} | ||
**{{Q|Q48}}: {{Q|Q21980}} | **{{Q|Q48}}: {{Q|Q21980}} | ||
**{{Q|Q41}}: {{Q|Q82}} | **{{Q|Q41}}: {{Q|Q82}} | ||
* '''[https://metabase.wikibase.cloud/query/#PREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%20%28GROUP_CONCAT%28DISTINCT%20%3ForganizerLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Forganizers%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP5%20wd%3AQ2%20.%0A%20%20OPTIONAL%20%7B%20%20%3Fitem%20wdt%3AP6%20%3Fstart.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP7%20%3Fend.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP15%20%3Fmainsubject.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP14%20%3Forganizer.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Forganizer%20rdfs%3Alabel%20%3ForganizerLabel%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%0AORDER%20BY%20%3FitemLabel [QUERY]] | * '''[https://metabase.wikibase.cloud/query/#PREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%20%28GROUP_CONCAT%28DISTINCT%20%3FmainsubjectLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Ftopics%29%20%28GROUP_CONCAT%28DISTINCT%20%3ForganizerLabel%3B%20SEPARATOR%20%3D%20%22%2C%20%22%29%20AS%20%3Forganizers%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP5%20wd%3AQ2%20.%0A%20%20OPTIONAL%20%7B%20%20%3Fitem%20wdt%3AP6%20%3Fstart.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP7%20%3Fend.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP15%20%3Fmainsubject.%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP14%20%3Forganizer.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sv%22.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel.%0A%20%20%20%20%3Fmainsubject%20rdfs%3Alabel%20%3FmainsubjectLabel.%0A%20%20%20%20%3Forganizer%20rdfs%3Alabel%20%3ForganizerLabel%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Fend%0AORDER%20BY%20%3FitemLabel [QUERY]] {{Q|Q2}}''' | ||
** {{Q|Q21932}} | ** {{Q|Q21932}} | ||
** {{Q|Q1}} | ** {{Q|Q1}} | ||