User:Alicia Fagerving (WMSE)/Sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 6: | Line 6: | ||
[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/#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}} | SESSION: {{q|Q23072}} | ||
</div> | </div> |