PREFIX xsd: PREFIX snvoc: PREFIX sn: PREFIX dbpedia-owl: PREFIX dbpedia: PREFIX foaf: PREFIX rdfs: select ?fr ?first ?last ?ct1 ?ct2 ((?ct1 + ?ct2) as ?sum) #Q3 where { {select distinct ?fr ?first ?last ?ct1 ?ct2 where { {select ?fr (count(*) as ?ct1) where { ?post snvoc:hasCreator ?fr . ?post snvoc:creationDate ?date . filter (?date >= "2010-12-01T00:00:00.000+00:00"^^xsd:dateTime && ?date < "2010-12-01T00:00:00.000+00:00"^^xsd:dateTime + xsd:duration("P31D")) . ?post snvoc:isLocatedIn dbpedia:Honduras } group by ?fr } {select ?fr (count (*) as ?ct2) where { ?post2 snvoc:hasCreator ?fr . ?post2 snvoc:creationDate ?date2 . filter (?date2 >= "2010-12-01T00:00:00.000+00:00"^^xsd:dateTime && ?date2 < "2010-12-01T00:00:00.000+00:00"^^xsd:dateTime + xsd:duration("P31D")) . ?post2 snvoc:isLocatedIn dbpedia:Norway } group by ?fr } {sn:pers00000002199023258791 snvoc:knows ?fr.} union {sn:pers00000002199023258791 snvoc:knows ?fr2. ?fr2 snvoc:knows ?fr. filter (?fr != sn:pers00000002199023258791)} . optional { ?fr snvoc:firstName ?first } . optional { ?fr snvoc:lastName ?last } . ?fr snvoc:isLocatedIn ?city . filter(!exists {?city snvoc:isPartOf dbpedia:Honduras}). filter(!exists {?city snvoc:isPartOf dbpedia:Norway}). } }. filter (?ct1 > 0 && ?ct2 > 0) . } order by desc(?sum) ?fr limit 20