PREFIX xsd: PREFIX snvoc: PREFIX sn: PREFIX dbpedia-owl: PREFIX dbpedia: PREFIX foaf: PREFIX rdfs: select ?fr ?first ?last ?post ?content #Q9 ((?date - xsd:dateTime("1970-01-01T00:00:00.000+00:00")) * 1000 as ?creationDate) where { {select distinct ?fr where { {sn:pers00000000000000005106 snvoc:knows ?fr.} union {sn:pers00000000000000005106 snvoc:knows ?fr2. ?fr2 snvoc:knows ?fr. filter (?fr != sn:pers00000000000000005106)} } } optional { ?fr snvoc:firstName ?first } . optional { ?fr snvoc:lastName ?last } . ?post snvoc:hasCreator ?fr . ?post snvoc:creationDate ?date. filter (?date < "2012-06-23T00:00:00.000+00:00"^^xsd:dateTime). {{?post snvoc:content ?content} union {?post snvoc:imageFile ?content} union {?post snvoc:gifFile ?content}} . } order by desc(?creationDate) ?post limit 20