{"id":804,"date":"2020-01-27T16:58:07","date_gmt":"2020-01-27T16:58:07","guid":{"rendered":"http:\/\/wikidata.wwwnlsrc4.supercp.com\/?p=804"},"modified":"2020-07-29T14:49:29","modified_gmt":"2020-07-29T14:49:29","slug":"exercise-qualifiers-2","status":"publish","type":"post","link":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries\/qualifiers\/exercise-qualifiers-2\/","title":{"rendered":"Another exercise"},"content":{"rendered":"\n<h4>| Exercise: For each of the movies in the original Star Wars trilogy (Q25540859) list the cast members (P161) and the character role (P453) they played <\/h4>\n\n\n\n<iframe class=\"\" src=\"https:\/\/query.wikidata.org\/\" style=\"width:100%;max-width:100%;height:450px\" frameborder=\"0\"><\/iframe>\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<iframe class=\"\" src=\"https:\/\/query.wikidata.org\/#%23%20Cast%20members%20and%20their%20character%20roles%20in%20the%20original%20Star%20Wars%20trilogy%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fcast_memberLabel%20%3FroleLabel%20%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP179%20wd%3AQ25540859.%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20item%20is%20part%20of%20the%20original%20Star%20Wars%20trilogy%0A%20%20%3Fitem%20p%3AP161%20%3Fcast_statement.%20%20%20%20%20%20%20%20%20%20%20%20%23%20item%20has%20a%20property%20P161%20%28cast%20member%29%20linking%20a%20statement%20node%0A%20%20%3Fcast_statement%20ps%3AP161%20%3Fcast_member.%20%20%20%20%23%20the%20property%20statement%27s%20value%20is%20collected%20by%20%3Fcast_member%20and%20%0A%20%20%3Fcast_statement%20pq%3AP453%20%3Frole.%20%20%20%20%20%20%20%20%20%20%20%23%20the%20statement%20has%20a%20P453%20property%20qualifier%20and%20its%20value%20is%20collected%20by%20%3Frole%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D%0A\" style=\"width:100%;max-width:100%;height:475px\" frameborder=\"0\"><\/iframe>\n\n\n\n<p> <\/p>\n\n\n\n<p>If you&#8217;ve learned to remove duplicates using the <a href=\"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries\/instances-and-classes\/distinct\/\">DISTINCT <\/a>modifier, edit the query to list the unique character roles in the original Star Wars trilogy and the actors that played them. <\/p>\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><\/p>\n\n\n\n<iframe class=\"\" src=\"https:\/\/query.wikidata.org\/#%23Original%20Star%20Wars%20trilogy%20character%20roles%20and%20actors%20%0A%0ASELECT%20DISTINCT%20%3FroleLabel%20%20%3Fcast_memberLabel%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP179%20wd%3AQ25540859.%20%20%20%20%20%20%20%20%20%20%20%23%20item%20is%20part%20of%20the%20original%20Star%20Wars%20trilogy%0A%20%20%3Fitem%20p%3AP161%20%3Fcast_statement.%20%20%20%20%20%20%20%20%20%20%23%20item%20has%20a%20property%20P161%20%28cast%20member%29%20linking%20a%20statement%20node%0A%20%20%3Fcast_statement%20ps%3AP161%20%3Fcast_member.%20%20%23%20the%20property%20statement%27s%20value%20is%20collected%20by%20%3Fcast_member%20and%20%0A%20%20%3Fcast_statement%20pq%3AP453%20%3Frole.%20%20%20%20%20%20%20%20%20%23%20the%20statement%20has%20a%20P453%20property%20qualifier%20and%20its%20value%20is%20collected%20by%20%3Frole%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D%0A\" style=\"width:100%;max-width:100%;height:475px\" frameborder=\"0\"><\/iframe>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><\/div>\n<\/div>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>| Exercise: For each of the movies in the original Star Wars trilogy (Q25540859) list the cast members (P161) and the character role (P453) they played<\/p>\n","protected":false},"author":1,"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":[15],"tags":[],"_links":{"self":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/804"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/comments?post=804"}],"version-history":[{"count":15,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/804\/revisions"}],"predecessor-version":[{"id":2586,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/804\/revisions\/2586"}],"wp:attachment":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/media?parent=804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/categories?post=804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/tags?post=804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}