PREFIX xsd: PREFIX snvoc: PREFIX sn: PREFIX dbpedia-owl: PREFIX dbpedia: PREFIX foaf: PREFIX rdfs: select ?first ?last ((coalesce(?s1, 0) - coalesce(?s2,0)) as ?score) ?fof ?gender ?locationname #Q10 where { {select distinct ?fof where { sn:pers00000028587302327404 snvoc:knows ?fr . ?fr snvoc:knows ?fof . filter (?fof != sn:pers00000028587302327404) . minus { sn:pers00000028587302327404 snvoc:knows ?fof } . } } . optional { ?fof snvoc:firstName ?first } . optional { ?fof snvoc:lastName ?last } . ?fof snvoc:gender ?gender . ?fof snvoc:birthday ?bday . ?fof snvoc:isLocatedIn ?based . ?based foaf:name ?locationname . filter (1 = if (month (?bday) = 11, if (day(?bday) >= 21, 1, 0), if (month (?bday) = 12, if (day(?bday) < 22, 1, 0), 0))) . optional { {select ?fof (count (distinct ?post) as ?s1) where { ?post a snvoc:Post . ?post snvoc:hasCreator ?fof . ?post snvoc:hasTag ?tag . sn:pers00000028587302327404 snvoc:hasInterest ?tag } group by ?fof } }. optional { {select ?fof (count (distinct ?post) as ?s2) where { ?post a snvoc:Post . ?post snvoc:hasCreator ?fof . filter (!exists {sn:pers00000028587302327404 snvoc:hasInterest ?tag. ?post snvoc:hasTag ?tag .}) } group by ?fof } }. } order by desc(?score) ?fof limit 10