Admin: Created page with "Back to the overview of all query topics: back == List of productions and their voting methods and voting results == PREFIX wdt: PREFIX wd: PREFIX p: PREFIX ps: PREFIX pq: SELECT DISTINCT ?production ?productionLabel ?v..."

2025-12-03T21:32:20Z

Created page with "Back to the overview of all query topics: back == List of productions and their voting methods and voting results == <syntaxhighlight lang="sparql" line="1"> PREFIX wdt: <https://mtm.uni-trier.de/prop/direct/> PREFIX wd: <https://mtm.uni-trier.de/entity/> PREFIX p: <https://mtm.uni-trier.de/prop/> PREFIX ps: <https://mtm.uni-trier.de/prop/statement/> PREFIX pq: <https://mtm.uni-trier.de/prop/qualifier/> SELECT DISTINCT ?production ?productionLabel ?v..."

New page

Back to the overview of all query topics: [[SPARQL-Queries|back]]

== List of productions and their voting methods and voting results ==
<syntaxhighlight lang="sparql" line="1">
PREFIX wdt: <https://mtm.uni-trier.de/prop/direct/>
PREFIX wd: <https://mtm.uni-trier.de/entity/>
PREFIX p: <https://mtm.uni-trier.de/prop/>
PREFIX ps: <https://mtm.uni-trier.de/prop/statement/>
PREFIX pq: <https://mtm.uni-trier.de/prop/qualifier/>

SELECT DISTINCT ?production ?productionLabel ?venueLabel ?voteTypeLabel ?count ?verdictLabel WHERE {
?production wdt:P83 ?interactionElement.
?production wdt:P8 ?venue.
?interactionElement wdt:P84 ?voteType.

?interactionElement p:P93 ?statement.
?statement ps:P93 ?verdict.
?statement pq:P57 ?count.

SERVICE wikibase:label {
bd:serviceParam wikibase:language "en".
}
}
ORDER BY ?venue

</syntaxhighlight>Click here: [http://mtm.uni-trier.de/query/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fentity%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20DISTINCT%20%3Fproduction%20%3FproductionLabel%20%3FvenueLabel%20%3FvoteTypeLabel%20%3Fcount%20%3FverdictLabel%20WHERE%20%7B%0A%20%20%3Fproduction%20wdt%3AP83%20%3FinteractionElement.%0A%20%20%3Fproduction%20wdt%3AP8%20%3Fvenue.%0A%20%20%3FinteractionElement%20wdt%3AP84%20%3FvoteType.%0A%0A%20%20%3FinteractionElement%20p%3AP93%20%3Fstatement.%0A%20%20%3Fstatement%20ps%3AP93%20%3Fverdict.%0A%20%20%3Fstatement%20pq%3AP57%20%3Fcount.%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%0A%20%20%7D%0A%7D%0AORDER%20BY%20%3Fvenue%0A Test SPARQL query]

== Which is the most frequently chosen voting method in the productions listed here? ==
<syntaxhighlight lang="sparql" line="1">
PREFIX wdt: <https://mtm.uni-trier.de/prop/direct/>
PREFIX wd: <https://mtm.uni-trier.de/entity/>

SELECT ?production ?productionLabel ?voteTypeLabel (COUNT(?interactionElement) AS ?occurrences) WHERE {
?production wdt:P83 ?interactionElement.
?interactionElement wdt:P84 ?voteType.

SERVICE wikibase:label {
bd:serviceParam wikibase:language "en".
}
}
GROUP BY ?production ?productionLabel ?voteType ?voteTypeLabel
HAVING (COUNT(?interactionElement))

</syntaxhighlight>Click here: [http://mtm.uni-trier.de/query/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fentity%2F%3E%0A%0ASELECT%20%3Fproduction%20%3FproductionLabel%20%3FvoteTypeLabel%20%28COUNT%28%3FinteractionElement%29%20AS%20%3Foccurrences%29%20WHERE%20%7B%0A%20%20%3Fproduction%20wdt%3AP83%20%3FinteractionElement.%0A%20%20%3FinteractionElement%20wdt%3AP84%20%3FvoteType.%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fproduction%20%3FproductionLabel%20%3FvoteType%20%3FvoteTypeLabel%0AHAVING%20%28COUNT%28%3FinteractionElement%29%29%0A Test SPARQL query]

== How visible were the votes in the respective productions? And which voting method was chosen? ==
<syntaxhighlight lang="sparql" line="1">
PREFIX wdt: <https://mtm.uni-trier.de/prop/direct/>
PREFIX wd: <https://mtm.uni-trier.de/entity/>

SELECT ?production ?productionLabel ?voteTypeLabel ?visibilityLabel WHERE {
?production wdt:P83 ?interactionElement.
?interactionElement wdt:P85 ?visibility.
?interactionElement wdt:P84 ?voteType.

SERVICE wikibase:label {
bd:serviceParam wikibase:language "en".
}
}

</syntaxhighlight>Click here: [http://mtm.uni-trier.de/query/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fentity%2F%3E%0A%0ASELECT%20%3Fproduction%20%3FproductionLabel%20%3FvoteTypeLabel%20%3FvisibilityLabel%20WHERE%20%7B%0A%20%20%3Fproduction%20wdt%3AP83%20%3FinteractionElement.%0A%20%20%3FinteractionElement%20wdt%3AP85%20%3Fvisibility.%0A%20%20%3FinteractionElement%20wdt%3AP84%20%3FvoteType.%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%0A%20%20%7D%0A%7D%0A Test SPARQL query]

== Which productions had invisible voting? ==
<syntaxhighlight lang="sparql" line="1">
PREFIX wdt: <https://mtm.uni-trier.de/prop/direct/>
PREFIX wd: <https://mtm.uni-trier.de/entity/>

SELECT ?production ?productionLabel WHERE {
?production wdt:P83 ?interactionElement.
?interactionElement wdt:P85 wd:Q235. # not visible

SERVICE wikibase:label {
bd:serviceParam wikibase:language "en".
}
}

</syntaxhighlight>In line 6: for a '''non-visible vote: wd:Q235''', for a '''visible vote: wd:Q234''', and for a '''partially visible vote: wd:Q236'''.

Click here: [http://mtm.uni-trier.de/query/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fmtm.uni-trier.de%2Fentity%2F%3E%0A%0ASELECT%20%3Fproduction%20%3FproductionLabel%20WHERE%20%7B%0A%20%20%3Fproduction%20wdt%3AP83%20%3FinteractionElement.%0A%20%20%3FinteractionElement%20wdt%3AP85%20wd%3AQ235.%20%20%20%23%20not%20visible%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%0A%20%20%7D%0A%7D%0A Test SPARQL query]

Voting - Revision history

Admin: Created page with "Back to the overview of all query topics: back == List of productions and their voting methods and voting results == PREFIX wdt: PREFIX wd: PREFIX p: PREFIX ps: PREFIX pq: SELECT DISTINCT ?production ?productionLabel ?v..."