Add 'DISTINCT' to fix BI Q14 SPARQL implementation
@@ -8,7 +8,7 @@ PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dbpedia: <http://dbpedia.org/resource/>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
-SELECT ?personId ?personFirstName ?personLastName (COUNT(?post) AS ?threadCount) (COUNT(?reply) AS ?messageCount)
+SELECT ?personId ?personFirstName ?personLastName (COUNT(DISTINCT ?post) AS ?threadCount) (COUNT(?reply) AS ?messageCount)
WHERE
{
VALUES (?type) {(snvoc:Comment) (snvoc:Post)}
