{"id":2626,"date":"2022-08-16T17:52:58","date_gmt":"2022-08-16T17:52:58","guid":{"rendered":"https:\/\/wdqs-tutorial.toolforge.org\/?p=2626"},"modified":"2023-04-06T17:26:40","modified_gmt":"2023-04-06T17:26:40","slug":"interrogazione-con-piu-di-una-variabile","status":"publish","type":"post","link":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/simple-queries-it\/adding-variables-it\/interrogazione-con-piu-di-una-variabile\/?lang=it","title":{"rendered":"Interrogazione con pi\u00f9 di una variabile"},"content":{"rendered":"\n<h2> Query con pi\u00f9 di una variabile <\/h2>\n\n\n\n<p> Until now our queries essentially had just one variable, even if additional variables were declared for the label and\/or description of the item. Now we will look at queries with more variables. <br>The following query retrieves items that are part of the Star Wars film series, and the director of each film.<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror cm-s-eclipse\" data-setting=\"{&quot;mode&quot;:&quot;sparql&quot;,&quot;mime&quot;:&quot;application\/sparql-query&quot;,&quot;theme&quot;:&quot;eclipse&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true}\">#Film della serie Guerre stellari\n\nSELECT ?item  ?itemLabel ?director\nWHERE \n{ \n  ?item wdt:P179 wd:Q22092344.  # l'elemento (item) fa parte di Guerre stellari (serie televisiva)\n  ?item wdt:P57 ?director.      # il valore della propriet\u00e0 regista dell'item viene raccolto dalla variabile regista\n  SERVICE wikibase:label { bd:serviceParam wikibase:language &quot;[AUTO_LANGUAGE]&quot;. }\n}<\/pre><\/div>\n\n\n\n<h3>Spiegazione della query<\/h3>\n\n\n\n<p>Nella sezione SELECT abbiamo le variabili ?item e ?director, cos\u00ec come ?itemLabel che recupera l&#8217;etichetta per ?item.<\/p>\n\n\n\n<p>Nella sezione WHERE, alle righe 6 e 7, vediamo le condizioni di pattern matching:<br>?item wdt: P179 wd: Q22092344.<br>?item wdt:P57 ?director.<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p>SPARQL ricerca elementi Wikidata con istruzioni che corrispondono allo schema definito nella sezione WHERE. Quindi, come prima, la prima riga della nostra sezione WHERE dice: &#8220;Trovami oggetti che hanno una dichiarazione con una propriet\u00e0 P179 (parte di una serie) con il valore Q22092344 (Star Wars (serie di film))&#8221;.<br>La seconda riga dice: &#8220;Quindi per ciascuno di questi elementi, trovami la loro propriet\u00e0 P57 (director) e inserisci il suo valore nella variabile ?director&#8221;.<br>Come abbiamo visto, c&#8217;\u00e8 un AND implicito tra ogni istruzione nella sezione WHERE, ovvero solo i modelli che corrispondono a tutte le istruzioni verranno restituiti da questa query.<\/p>\n\n\n\n<p> <\/p>\n\n\n\n<p>Ora eseguiamo la query:<\/p>\n\n\n\n<iframe style=\"width:100%;max-width:100%;height:450px\" src=\"https:\/\/query.wikidata.org\/#%23Star%20Wars%20films%0A%0ASELECT%20%3Fitem%20%20%3FitemLabel%20%3Fdirector%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP179%20wd%3AQ22092344.%20%23%20item%20is%20part%20of%20the%20series%20Star%20Wars%20%28film%20series%29%0A%20%20%3Fitem%20wdt%3AP57%20%3Fdirector.%20%20%20%20%20%23%20item%E2%80%99s%20director%20property%E2%80%99s%20value%20is%20collected%20by%20the%20director%20variable%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D\" class=\"\" frameborder=\"0\"><\/iframe>\n\n\n\n<h4><strong>Cosa bisogna aggiungere per vedere i nomi dei direttori? Aggiungilo ed esegui di nuovo la query.<\/strong><\/h4>\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\">Mostra la soluzione<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<iframe style=\"width:100%;max-width:100%;height:450px\" src=\"https:\/\/query.wikidata.org\/#%23Star%20Wars%20films%0A%0ASELECT%20%3Fitem%20%20%3FitemLabel%20%3Fdirector%20%3FdirectorLabel%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP179%20wd%3AQ22092344.%20%23%20item%20is%20part%20of%20the%20series%20Star%20Wars%20%28film%20series%29%0A%20%20%3Fitem%20wdt%3AP57%20%3Fdirector.%20%20%20%20%20%23%20item%E2%80%99s%20director%20property%E2%80%99s%20value%20is%20collected%20by%20the%20director%20variable%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D\" class=\"\" frameborder=\"0\"><\/iframe>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p> #Un po&#8217; di sintassi<\/p>\n\n\n\n<p> If we wanted the query to show the name of each director, but not the Q number, we could omit the ?director from the SELECT section and only declare ?directorLabel. This implies there is a ?director variable (which we see in the WHERE section) but it isn\u2019t presented in the query results.<\/p>\n\n\n\n<p> <\/p>\n\n\n\n<p><\/p>\n\n\n\n<iframe style=\"width:100%;max-width:100%;height:450px\" src=\"https:\/\/query.wikidata.org\/#%23Star%20Wars%20films%0A%0ASELECT%20%3Fitem%20%20%3FitemLabel%20%3FdirectorLabel%0AWHERE%20%0A%7B%20%0A%20%20%3Fitem%20wdt%3AP179%20wd%3AQ22092344.%20%23%20item%20is%20part%20of%20the%20series%20Star%20Wars%20%28film%20series%29%0A%20%20%3Fitem%20wdt%3AP57%20%3Fdirector.%20%20%20%20%20%23%20item%E2%80%99s%20director%20property%E2%80%99s%20value%20is%20collected%20by%20the%20director%20variable%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%7D\" class=\"\" frameborder=\"0\"><\/iframe>\n<\/div><\/details><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Query con pi\u00f9 di una variabile Until now our queries essentially had just one variable, even if additional variables were declared for the label and\/or description of the item. Now we will look at queries with more variables. The following query retrieves items that are part of the Star Wars film series, and the director [&hellip;]<\/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":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2626"}],"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=2626"}],"version-history":[{"count":3,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2626\/revisions"}],"predecessor-version":[{"id":2678,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/posts\/2626\/revisions\/2678"}],"wp:attachment":[{"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/media?parent=2626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/categories?post=2626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdqs-tutorial.toolforge.org\/index.php\/wp-json\/wp\/v2\/tags?post=2626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}