{"id":2305,"date":"2021-07-19T16:07:09","date_gmt":"2021-07-19T16:07:09","guid":{"rendered":"https:\/\/wdqs-tutorial.toolforge.org\/?p=2305"},"modified":"2021-07-21T16:41:22","modified_gmt":"2021-07-21T16:41:22","slug":"exercise-location-2","status":"publish","type":"post","link":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/where-queries-pt-br\/exercise-location-2\/?lang=pt-br","title":{"rendered":"Outro exerc\u00edcio"},"content":{"rendered":"\n<h4>| Exerc\u00edcio: Escreva uma consulta que mostre onde nasceram os atores de cada filme da saga Star Wars.<\/h4>\n\n\n\n<p>Dica: use <a href=\"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries-pt-br\/instances-and-classes-pt-br\/distinct\/?lang=pt-br\">DISTINCT<\/a> para remover duplicatas dos resultados.<\/p>\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\">ver a resposta<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<p><\/p>\n\n\n\n<iframe class=\"\" src=\"https:\/\/query.wikidata.org\/#%23%20Local%20de%20nascimento%20dos%20atores%20de%20Star%20Wars%0A%23defaultView%3AMap%0A%0ASELECT%20DISTINCT%20%3Fator%20%3FatorLabel%20%3FlocalLabel%20%3Fcoordenadas%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP179%20wd%3AQ22092344.%20%20%23%20item%20faz%20parte%20da%20saga%20de%20filmes%20Star%20Wars%0A%20%20%3Fitem%20wdt%3AP161%20%3Fator.%20%20%20%20%20%20%20%20%20%23%20a%20propriedade%20%22elenco%22%20de%20%3Fitem%20ser%C3%A1%20armazenada%20na%20vari%C3%A1vel%20%3Fator%0A%20%20%3Fator%20wdt%3AP19%20%3Flocal.%20%20%20%20%20%20%20%20%20%23%20o%20local%20de%20nascimento%20de%20%3Fator%20ser%C3%A1%20armazenado%20na%20vari%C3%A1vel%20%3Flocal%0A%20%20%3Flocal%20wdt%3AP625%20%3Fcoordenadas.%20%23%20as%20coordenadas%20do%20local%20de%20nascimento%20ser%C3%A3o%20armazenadas%20na%20vari%C3%A1vel%20%3Fcoordenadas%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D\" style=\"width:100%;max-width:100%;height:450px\" frameborder=\"0\"><\/iframe>\n\n\n\n<p><\/p>\n\n\n\n<p>Edite a consulta para adicionar uma imagem (P18) de cada ator aos resultados.<\/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\">ver a resposta<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<p><\/p>\n\n\n\n<iframe class=\"\" src=\"https:\/\/query.wikidata.org\/#%23%20local%20de%20nascimento%20dos%20atores%20de%20Star%20Wars%0A%23defaultView%3AMap%0A%0ASELECT%20DISTINCT%20%3Fator%20%3FatorLabel%20%3FlocalLabel%20%3Fcoordenadas%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP179%20wd%3AQ22092344.%20%20%23%20item%20faz%20parte%20da%20saga%20de%20filmes%20Star%20Wars%0A%20%20%3Fitem%20wdt%3AP161%20%3Fator.%20%20%20%20%20%20%20%20%20%23%20a%20propriedade%20%22elenco%22%20de%20%3Fitem%20ser%C3%A1%20armazenada%20na%20vari%C3%A1vel%20%3Fator%0A%20%20%3Fator%20wdt%3AP18%20%3Fimagem.%20%20%20%20%20%20%20%20%23%20a%20imagem%20do%20ator%20%C3%A9%20armazenada%20na%20vari%C3%A1vel%20%3Fimagem%0A%20%20%3Fator%20wdt%3AP19%20%3Flocal.%20%20%20%20%20%20%20%20%20%23%20o%20local%20de%20nascimento%20de%20%3Fator%20ser%C3%A1%20armazenado%20na%20vari%C3%A1vel%20%3Flocal%0A%20%20%3Flocal%20wdt%3AP625%20%3Fcoordenadas.%20%23%20as%20coordenadas%20do%20local%20de%20nascimento%20ser%C3%A3o%20armazenados%20na%20vari%C3%A1vel%20%3Fcoordenadas%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D\" style=\"width:100%;max-width:100%;height:475px\" frameborder=\"0\"><\/iframe>\n\n\n\n<p>Se voc\u00ea est\u00e1 se perguntando o porqu\u00ea desta segunda consulta ter menos resultados que a anterior, releia a se\u00e7\u00e3o sobre a <a href=\"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries-pt-br\/adding-variables-pt-br\/optional-clause\/?lang=pt-br\">cl\u00e1usula OPTIONAL<\/a>.<\/p>\n<\/div><\/details><\/div>\n<\/div>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>| Exerc\u00edcio: Escreva uma consulta que mostre onde nasceram os atores de cada filme da saga Star Wars. Dica: use DISTINCT para remover duplicatas dos resultados.<\/p>\n","protected":false},"author":3,"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":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2305"}],"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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/comments?post=2305"}],"version-history":[{"count":3,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2305\/revisions"}],"predecessor-version":[{"id":2441,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2305\/revisions\/2441"}],"wp:attachment":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/media?parent=2305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/categories?post=2305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/tags?post=2305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}