{"id":2696,"date":"2022-08-18T16:23:21","date_gmt":"2022-08-18T16:23:21","guid":{"rendered":"https:\/\/wdqs-tutorial.toolforge.org\/?p=2696"},"modified":"2023-04-06T17:21:43","modified_gmt":"2023-04-06T17:21:43","slug":"esercizio-2","status":"publish","type":"post","link":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries-it\/data-linked-to-values-it\/esercizio-2\/?lang=it","title":{"rendered":"Esercizio"},"content":{"rendered":"\n<h4>| Esercizio: quali film sono stati girati in Nuova Zelanda (Q664)?<\/h4>\n\n\n\n<p>Hint:  Make sure that your query retrieves films for which filming location (P915) is in the administrative territorial entity (P131) of New Zealand.  <\/p>\n\n\n\n<iframe style=\"width:100%;max-width:100%;height:450px\" src=\"https:\/\/query.wikidata.org\/\" class=\"\" frameborder=\"0\"><\/iframe>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">show solution<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<p>The following solution shows the filming locations:<\/p>\n\n\n\n<iframe style=\"width:100%;max-width:100%;height:450px\" src=\"https:\/\/query.wikidata.org\/#%23%20Movies%20filmed%20in%20New%20Zealand%0A%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3Flocation%20%3FlocationLabel%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ11424.%20%20%20%23%20item%20is%20an%20instance%20of%20film%2C%20or%20an%20instance%20of%20a%20subclass%20thereof%0A%20%20%3Fitem%20wdt%3AP915%20%3Flocation.%20%20%20%20%20%20%20%20%20%20%20%20%23%20item%E2%80%99s%20filming%20location%20is%20collected%20by%20the%20%3Flocation%20variable%0A%20%20%3Flocation%20wdt%3AP131%2a%20wd%3AQ664.%20%20%20%20%20%20%20%20%20%23%20location%20is%20in%20the%20administrative%20territory%20of%20New%20Zealand%20%28directly%20or%20through%20one%20or%20more%20property%20paths%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D%0A\" class=\"\" frameborder=\"0\"><\/iframe>\n\n\n\n<p>Or, using <a href=\"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries\/data-linked-to-values\/retrieving-data-linked-to-values\/#syntax\">abbreviated syntax<\/a> (filming locations not listed):<\/p>\n\n\n\n<iframe style=\"width:100%;max-width:100%;height:450px\" src=\"https:\/\/query.wikidata.org\/#%23%20Movies%20filmed%20in%20New%20Zealand%0A%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ11424.%20%20%20%23%20item%20is%20an%20instance%20of%20film%2C%20or%20an%20instance%20of%20a%20subclass%20thereof%0A%20%20%3Fitem%20wdt%3AP915%20%5Bwdt%3AP131%2a%20wd%3AQ664%5D.%20%20%23%20item%27s%20filming%20location%20is%20in%20the%20administrative%20territory%20of%20New%20Zealand%20%28directly%20or%20indirectly%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D%0A\" class=\"\" frameborder=\"0\"><\/iframe>\n\n\n\n<p> Note that duplicates are removed from the results using the <a href=\"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries\/instances-and-classes\/distinct\/\">DISTINCT <\/a>modifier.  <\/p>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>| Esercizio: quali film sono stati girati in Nuova Zelanda (Q664)? Hint: Make sure that your query retrieves films for which filming location (P915) is in the administrative territorial entity (P131) of New Zealand.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":""},"categories":[14],"tags":[],"_links":{"self":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2696"}],"collection":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/comments?post=2696"}],"version-history":[{"count":1,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2696\/revisions"}],"predecessor-version":[{"id":2697,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2696\/revisions\/2697"}],"wp:attachment":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/media?parent=2696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/categories?post=2696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/tags?post=2696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}