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 >= "2012-01-01T00:00:00.000+00:00"^^xsd:dateTime && ?date < "2012-01-01T00:00:00.000+00:00"^^xsd:dateTime + xsd:duration("P37D")) . ?post snvoc:isLocatedIn dbpedia:Papua_New_Guinea } group by ?fr } {select ?fr (count (*) as ?ct2) where { ?post2 snvoc:hasCreator ?fr . ?post2 snvoc:creationDate ?date2 . filter (?date2 >= "2012-01-01T00:00:00.000+00:00"^^xsd:dateTime && ?date2 < "2012-01-01T00:00:00.000+00:00"^^xsd:dateTime + xsd:duration("P37D")) . ?post2 snvoc:isLocatedIn dbpedia:Namibia } group by ?fr } {sn:pers00000021990232560330 snvoc:knows ?fr.} union {sn:pers00000021990232560330 snvoc:knows ?fr2. ?fr2 snvoc:knows ?fr. filter (?fr != sn:pers00000021990232560330)} . optional { ?fr snvoc:firstName ?first } . optional { ?fr snvoc:lastName ?last } . ?fr snvoc:isLocatedIn ?city . filter(!exists {?city snvoc:isPartOf dbpedia:Papua_New_Guinea}). filter(!exists {?city snvoc:isPartOf dbpedia:Namibia}). } }. filter (?ct1 > 0 && ?ct2 > 0) . } order by desc(?sum) ?fr limit 20