PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?firstName ?lastName ?birthday ?locationIP ?browserUsed ?cityId ?gender ?creationDate WHERE { BIND( "00000032985348833679"^^xsd:long AS ?personId ) ?person a snvoc:Person . ?person snvoc:id ?personId . ?person snvoc:firstName ?firstName . ?person snvoc:lastName ?lastName . ?person snvoc:gender ?gender . ?person snvoc:birthday ?birthday . ?person snvoc:creationDate ?creationDate . ?person snvoc:locationIP ?locationIP . ?person snvoc:isLocatedIn ?city . ?city snvoc:id ?cityId . ?person snvoc:browserUsed ?browserUsed . } #LdbcShortQuery1PersonProfile PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?messageId ?messageContent ?messageCreationDate ?originalPostId ?originalPostAuthorId ?originalPostAuthorFirstName ?originalPostAuthorLastName WHERE { BIND( "00000032985348833679"^^xsd:long AS ?personId ) ?person a snvoc:Person . ?person snvoc:id ?personId . ?message snvoc:hasCreator ?person . ?message snvoc:content|snvoc:imageFile ?messageContent . ?message snvoc:creationDate ?messageCreationDate . ?message snvoc:id ?messageId . OPTIONAL { ?message snvoc:replyOf* ?originalPostInner . ?originalPostInner a snvoc:Post . } . BIND( COALESCE(?originalPostInner, ?message) AS ?originalPost ) . ?originalPost snvoc:id ?originalPostId . ?originalPost snvoc:hasCreator ?creator . ?creator snvoc:firstName ?originalPostAuthorFirstName . ?creator snvoc:lastName ?originalPostAuthorLastName . ?creator snvoc:id ?originalPostAuthorId . } ORDER BY DESC(?messageCreationDate) DESC(?messageId) LIMIT 10 #LdbcShortQuery2PersonPosts PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?personId ?firstName ?lastName ?friendshipCreationDate WHERE { BIND( "00000032985348833679"^^xsd:long AS ?rootId ) ?rootPerson a snvoc:Person . ?rootPerson snvoc:id ?rootId . { ?rootPerson snvoc:knows ?knows . ?knows snvoc:hasPerson ?person . } UNION { ?person snvoc:knows ?knows . ?knows snvoc:hasPerson ?rootPerson . } ?knows snvoc:creationDate ?friendshipCreationDate . ?person snvoc:firstName ?firstName . ?person snvoc:lastName ?lastName . ?person snvoc:id ?personId . } ORDER BY DESC(?friendshipCreationDate) ?personId #LdbcShortQuery3PersonFriends PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?messageCreationDate ?messageContent WHERE { BIND( "00000002061584476422"^^xsd:long AS ?messageId ) ?message snvoc:id ?messageId . ?message snvoc:creationDate ?messageCreationDate . ?message snvoc:content|snvoc:imageFile ?messageContent . } #LdbcShortQuery4MessageContent PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?personId ?firstName ?lastName WHERE { BIND( "00000002061584476422"^^xsd:long AS ?messageId ) ?message snvoc:id ?messageId . ?message snvoc:hasCreator ?creator . ?creator snvoc:id ?personId . ?creator snvoc:firstName ?firstName . ?creator snvoc:lastName ?lastName . } #LdbcShortQuery5MessageCreator PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?forumId ?forumTitle ?moderatorId ?moderatorFirstName ?moderatorLastName WHERE { BIND( "00000002061584476422"^^xsd:long AS ?messageId ) ?message snvoc:id ?messageId . OPTIONAL { ?message snvoc:replyOf* ?originalPostInner . ?originalPostInner a snvoc:Post . } . BIND( COALESCE(?originalPostInner, ?message) AS ?originalPost ) . ?forum snvoc:containerOf ?originalPost . ?forum snvoc:id ?forumId . ?forum snvoc:title ?forumTitle . ?forum snvoc:hasModerator ?moderator . ?moderator snvoc:id ?moderatorId . ?moderator snvoc:firstName ?moderatorFirstName . ?moderator snvoc:lastName ?moderatorLastName . } #LdbcShortQuery6MessageForum PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?commentId ?commentContent ?commentCreationDate ?replyAuthorId ?replyAuthorFirstName ?replyAuthorLastName ?replyAuthorKnowsOriginalMessageAuthor WHERE { BIND( "00000002061584476422"^^xsd:long AS ?messageId ) ?message snvoc:id ?messageId . ?message snvoc:hasCreator ?messageCreator . ?messageCreator snvoc:id ?messageCreatorId . ?comment snvoc:replyOf ?message . ?comment a snvoc:Comment . ?comment snvoc:id ?commentId . ?comment snvoc:content ?commentContent . ?comment snvoc:creationDate ?commentCreationDate . ?comment snvoc:hasCreator ?replyAuthor . ?replyAuthor snvoc:id ?replyAuthorId . ?replyAuthor snvoc:firstName ?replyAuthorFirstName . ?replyAuthor snvoc:lastName ?replyAuthorLastName . OPTIONAL { ?messageCreator ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?replyAuthor . BIND( "true"^^xsd:boolean AS ?replyAuthorKnowsOriginalMessageAuthorInner ) . } BIND( COALESCE(?replyAuthorKnowsOriginalMessageAuthorInner, "false"^^xsd:boolean) AS ?replyAuthorKnowsOriginalMessageAuthor ) . } ORDER BY DESC(?commentCreationDate) ?replyAuthorId #LdbcShortQuery7MessageReplies PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?frId AS ?personId) (?first AS ?personFirstName) (?last AS ?personLastName) (?commonScore AS ?commonInterestScore) (?gender AS ?personGender) (?locationName AS ?personCityName) WHERE { BIND(7 AS ?month) BIND(IF(?month = 12, 1, ?month + 1) AS ?nextMonth) { SELECT DISTINCT ?fr ?frId WHERE { BIND( "00000030786325579101"^^xsd:long AS ?rootId ) . ?rootPerson a snvoc:Person . ?rootPerson snvoc:id ?rootId . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?fr snvoc:id ?frId . FILTER(?frId != ?rootId) . FILTER NOT EXISTS { ?rootPerson (snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson) ?fr . } } } . ?fr snvoc:firstName ?first . ?fr snvoc:lastName ?last . ?fr snvoc:gender ?gender . ?fr snvoc:birthday ?bday . ?fr snvoc:isLocatedIn ?based . ?based foaf:name ?locationName . FILTER ( (MONTH(?bday) = ?month && DAY(?bday) >= 21) || (MONTH(?bday) = (?nextMonth) && DAY(?bday) < 22) ) . OPTIONAL { { SELECT ?frCommonInner ?frCommonInnerId (COUNT(?post) AS ?commonScoreInner) WHERE { SELECT DISTINCT ?frCommonInner ?frCommonInnerId ?post WHERE { ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000030786325579101"^^xsd:long . ?post a snvoc:Post . ?post snvoc:hasCreator ?frCommonInner . ?frCommonInner snvoc:id ?frCommonInnerId . ?post snvoc:hasTag ?tag . ?rootPerson snvoc:hasInterest ?tag } } GROUP BY ?frCommonInner ?frCommonInnerId } FILTER(?frCommonInnerId = ?frId) } . OPTIONAL { { SELECT DISTINCT ?frTotalInner ?frTotalInnerId (COUNT(?post) AS ?totalPostCountInner) WHERE { ?post a snvoc:Post . ?post snvoc:hasCreator ?frTotalInner . ?frTotalInner a snvoc:Person . ?frTotalInner snvoc:id ?frTotalInnerId . } GROUP BY ?frTotalInner ?frTotalInnerId } FILTER(?frTotalInnerId = ?frId) } BIND( 2 * COALESCE(?commonScoreInner, 0) - COALESCE(?totalPostCountInner, 0) AS ?commonScore ) } ORDER BY DESC(?commonScore) ?frId LIMIT 10 #LdbcQuery10 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?frId AS ?personId) (?first AS ?personFirstName) (?last AS ?personLastName) (?orgName AS ?organizationName) (?startYear AS ?organizationWorkFromYear) WHERE { { SELECT DISTINCT ?fr ?frId WHERE { BIND( "00000030786325579101"^^xsd:long AS ?rootId ) ?rootPerson a snvoc:Person . ?rootPerson snvoc:id ?rootId . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))?/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?fr snvoc:id ?frId . FILTER(?frId != ?rootId) } } . ?fr snvoc:workAt ?work . ?work snvoc:workFrom ?startYear . FILTER (?startYear < 2004) . ?work snvoc:hasOrganisation ?org . ?org foaf:name ?orgName . ?org snvoc:isLocatedIn ?country. ?country foaf:name "Puerto_Rico" . ?fr snvoc:firstName ?first . ?fr snvoc:lastName ?last . } ORDER BY ?startYear ?frId DESC(?orgName) LIMIT 10 #LdbcQuery11 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?frId AS ?personId) (?first AS ?personFirstName) (?last AS ?personLastName) (GROUP_CONCAT(DISTINCT ?tagName;separator=', ') AS ?tagNames) (COUNT(DISTINCT ?reply) AS ?replyCount) WHERE { ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000019791209300143"^^xsd:long . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?fr snvoc:id ?frId . ?fr snvoc:firstName ?first . ?fr snvoc:lastName ?last . ?reply snvoc:hasCreator ?fr . ?reply snvoc:replyOf ?post . ?post a snvoc:Post . ?post snvoc:hasTag ?tag . ?tag foaf:name ?tagName . ?tag a ?tagType. ?tagType rdfs:subClassOf* ?tagSuperType . ?tagSuperType rdfs:label "BasketballPlayer" . } GROUP BY ?frId ?first ?last ORDER BY DESC(?replyCount) ?frId LIMIT 20 #LdbcQuery12 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?frId AS ?friendId) (?last AS ?friendLastName) (MIN(?dist) AS ?distanceFromPerson) (?bday AS ?friendBirthday) (?since AS ?friendCreationDate) (?gen AS ?friendGender) (?browser AS ?friendBrowserUsed) (?locationIP AS ?friendLocationIp) (?emails AS ?friendEmails) (?languages AS ?friendLanguages) (?based AS ?friendCityName) (?studies AS ?friendUniversities) (?jobs AS ?friendCompanies) { { SELECT ?fr ?emails ?dist (GROUP_CONCAT(?language;separator=", ") AS ?languages) WHERE { { SELECT ?fr ?dist (GROUP_CONCAT(?email;separator=", ") AS ?emails) WHERE { { SELECT ?fr (MIN(?distInner) AS ?dist) WHERE { BIND( "00000030786325579101"^^xsd:long AS ?rootId ) ?rootPerson a snvoc:Person . ?rootPerson snvoc:id ?rootId . ?fr a snvoc:Person . { ?rootPerson (snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson) ?fr . BIND( 1 AS ?distOneInner ) } UNION { ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . BIND( 2 AS ?distTwoInner ) } UNION { ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . #BIND( 3 AS ?distThreeInner ) } ?fr snvoc:id ?frId . FILTER(?frId != ?rootId) . ?fr snvoc:firstName "Ian" . BIND( IF(COALESCE(?distOneInner, 4) < 4, 1, IF(COALESCE(?distTwoInner, 4) < 4, 2, 3)) AS ?distInner) } GROUP BY ?fr } ?fr snvoc:email ?email . } GROUP BY ?fr ?dist } ?fr snvoc:speaks ?language } GROUP BY ?fr ?emails ?dist } ?fr snvoc:id ?frId . ?fr snvoc:lastName ?last . ?fr snvoc:birthday ?bday . ?fr snvoc:isLocatedIn ?basedURI . ?basedURI foaf:name ?based . ?fr snvoc:creationDate ?since . ?fr snvoc:gender ?gen . ?fr snvoc:locationIP ?locationIP . ?fr snvoc:browserUsed ?browser . OPTIONAL { { SELECT (?frInner AS ?frInnerUni) (GROUP_CONCAT(CONCAT(?uniName, " ", xsd:string(?classYear), " ", ?uniCountry);separator=", ") AS ?studies) { SELECT DISTINCT ?frInner ?uniName ?classYear ?uniCountry { ?frInner a snvoc:Person . ?frInner snvoc:studyAt ?study . ?study snvoc:hasOrganisation ?uni . ?uni foaf:name ?uniName . ?study snvoc:classYear ?classYear . ?uni snvoc:isLocatedIn/foaf:name ?uniCountry . } } GROUP BY ?frInner } . ?frInnerUni snvoc:id ?frInnerUniId . FILTER( ?frId = ?frInnerUniId) } . OPTIONAL { { SELECT (?frInner AS ?frInnerComp) (GROUP_CONCAT(CONCAT(?companyName, " ", xsd:string(?workFrom), " ", ?companyCountry);separator=", ") AS ?jobs) { SELECT DISTINCT ?frInner ?companyName ?workFrom ?companyCountry { ?frInner a snvoc:Person . ?frInner snvoc:workAt ?work . ?work snvoc:hasOrganisation ?company . ?work snvoc:workFrom ?workFrom . ?company snvoc:isLocatedIn/foaf:name ?companyCountry . ?company foaf:name ?companyName } } GROUP BY ?frInner } . ?frInnerComp snvoc:id ?frInnerCompId . FILTER( ?frId = ?frInnerCompId) } } GROUP BY ?frId ?last ?bday ?since ?gen ?browser ?locationIP ?based ?studies ?jobs ?emails ?languages ORDER BY ?distanceFromPerson ?last ?frId LIMIT 20 #LdbcQuery1 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?frId AS ?personId) (?first AS ?personFirstName) (?last AS ?personLastName) (?messageId AS ?postOrCommentId) (?content AS ?postOrCommentContent) (?creationDate AS ?postOrCommentCreationDate) WHERE { VALUES (?type) {(snvoc:Comment) (snvoc:Post)} { SELECT DISTINCT ?fr WHERE { ?rootPerson a snvoc:Person . ?fr a snvoc:Person . ?rootPerson snvoc:id "00000019791209300143"^^xsd:long . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr } } ?message snvoc:hasCreator ?fr . ?message a ?type { { ?message snvoc:content ?content } UNION { ?message snvoc:imageFile ?content } } . ?message snvoc:creationDate ?creationDate . ?message snvoc:id ?messageId . FILTER (?creationDate <= "2012-11-28T00:00:00.000Z"^^xsd:dateTime) . ?fr snvoc:firstName ?first . ?fr snvoc:lastName ?last . ?fr snvoc:id ?frId . } ORDER BY DESC(?creationDate) ?message LIMIT 20 #LdbcQuery2 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?frId AS ?personId) (?firstName AS ?personFirstName) (?lastName AS ?personLastName) ?xCount ?yCount (?xCount + ?yCount AS ?count) WHERE { { SELECT DISTINCT ?fr ?frId WHERE { ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000015393162790207"^^xsd:long . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))?/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?fr snvoc:id ?frId . ?fr snvoc:isLocatedIn/snvoc:isPartOf ?country . ?country a dbpedia-owl:Country . ?country foaf:name ?countryName . FILTER(?fr != ?rootPerson && ?countryName != "Puerto_Rico" && ?countryName != "Republic_of_Macedonia") } } { SELECT (?frId AS ?frIdX) (COUNT(*) AS ?xCount) WHERE { BIND( "2010-12-01T00:00:00.000Z"^^xsd:dateTime AS ?date1 ) . BIND( ?date1 + "P30D"^^xsd:duration AS ?date2 ) . VALUES (?type) {(snvoc:Comment) (snvoc:Post)} ?message a ?type . ?message snvoc:creationDate ?creationDate . FILTER( ?creationDate >= ?date1 && ?creationDate < ?date2 ) . ?message snvoc:hasCreator ?fr . ?fr a snvoc:Person . ?fr snvoc:id ?frId . ?message snvoc:isLocatedIn ?country . ?country a dbpedia-owl:Country . ?country foaf:name "Puerto_Rico" . } GROUP BY ?frId } . FILTER( ?frId = ?frIdX ) . { SELECT (?frId AS ?frIdY) (COUNT(*) AS ?yCount) WHERE { BIND( "2010-12-01T00:00:00.000Z"^^xsd:dateTime AS ?date1 ) . BIND( ?date1 + "P30D"^^xsd:duration AS ?date2 ) . VALUES (?type) {(snvoc:Comment) (snvoc:Post)} ?message a ?type . ?message snvoc:creationDate ?creationDate . FILTER( ?creationDate >= ?date1 && ?creationDate < ?date2 ) . ?message snvoc:hasCreator ?fr . ?fr a snvoc:Person . ?fr snvoc:id ?frId . ?message snvoc:isLocatedIn ?country . ?country a dbpedia-owl:Country . ?country foaf:name "Republic_of_Macedonia" . } GROUP BY ?frId } . FILTER( ?frId = ?frIdY ) ?fr snvoc:firstName ?firstName . ?fr snvoc:lastName ?lastName } ORDER BY DESC(?sum) ?fr LIMIT 20 #LdbcQuery3 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?tagName (COUNT(*) AS ?postCount) WHERE { BIND( "2012-06-01T00:00:00.000Z"^^xsd:dateTime AS ?startDate ) . BIND( ?startDate + "P28D"^^xsd:duration AS ?endDate ) . ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000010995116278874"^^xsd:long . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?post a snvoc:Post . ?post snvoc:hasCreator ?fr . ?post snvoc:hasTag ?tag . ?tag foaf:name ?tagName . ?post snvoc:creationDate ?creationDate . FILTER (?creationDate >= ?startDate && ?creationDate <= ?endDate ) . FILTER NOT EXISTS { ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr2 . ?post2 snvoc:hasCreator ?fr2 . ?post2 a snvoc:Post . ?post2 snvoc:hasTag ?tag . ?post2 snvoc:creationDate ?creationDate2 . FILTER (?creationDate2 < ?startDate) } } GROUP BY ?tagName ORDER BY DESC(?postCount) ?tagName LIMIT 10 #LdbcQuery4 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?title AS ?forumTitle) (SUM(?hasPost) AS ?postCount) WHERE { { SELECT DISTINCT ?fr ?forum WHERE { { SELECT DISTINCT ?fr ?frId WHERE { BIND( "00000015393162790207"^^xsd:long AS ?rootId ) ?rootPerson a snvoc:Person . ?rootPerson snvoc:id ?rootId . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))?/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?fr snvoc:id ?frId . FILTER(?frId != ?rootId) } } . ?forum a snvoc:Forum . ?forum snvoc:hasMember ?mem . ?mem snvoc:hasPerson ?fr . ?mem snvoc:joinDate ?date . FILTER( ?date >= "2012-08-11T00:00:00.000Z"^^xsd:dateTime ) . } } OPTIONAL { ?post a snvoc:Post . ?post snvoc:hasCreator ?fr . ?forum snvoc:containerOf ?post . BIND( 1 AS ?hasPostInner ) } . ?forum snvoc:title ?title . ?forum snvoc:id ?forumId . BIND( COALESCE(?hasPostInner, 0) AS ?hasPost ) } GROUP BY ?title ?forumId ORDER BY DESC(?postCount) ?forumId LIMIT 20 #LdbcQuery5 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?tag2Name AS ?tagName) (COUNT(?post) AS ?postCount) WHERE { BIND("Shakira" AS ?tagName) { SELECT DISTINCT ?fr ?frId WHERE { BIND( "00000030786325579101"^^xsd:long AS ?rootId ) . ?rootPerson a snvoc:Person . ?rootPerson snvoc:id ?rootId . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))?/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?fr snvoc:id ?frId . FILTER(?frId != ?rootId) } } . ?post a snvoc:Post . ?post snvoc:hasCreator ?fr . ?post snvoc:hasTag ?tag1 . ?tag1 foaf:name ?tagName . ?post snvoc:hasTag ?tag2 . ?tag2 foaf:name ?tag2Name . FILTER (?tag2Name != ?tagName) . } GROUP BY ?tag2Name ORDER BY DESC(?postCount) ?tag2Name LIMIT 10 #LdbcQuery6 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?personId (?firstName AS ?personFirstName) (?lastName AS ?personLastName) ?likeCreationDate (?messageId AS ?commentOrPostId) (?content AS ?commentOrPostContent) (?latency AS ?minutesLatency) ?isNew WHERE { { SELECT ?person (MIN(?messageId) AS ?messageId) WHERE { { SELECT ?personId (MAX(?likeDate) AS ?mostRecentLikeDate) WHERE { { SELECT DISTINCT ?message WHERE { VALUES (?type) {(snvoc:Comment) (snvoc:Post)} ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000026388279067534"^^xsd:long . ?message snvoc:hasCreator ?rootPerson . ?message a ?type } } . ?person a snvoc:Person . ?person snvoc:likes ?like . ?person snvoc:id ?personId . ?like snvoc:hasPost|snvoc:hasComment ?message . ?like snvoc:creationDate ?likeDate . } GROUP BY ?personId ORDER BY DESC(?mostRecentLikeDate) ?personId LIMIT 20 } VALUES (?type) {(snvoc:Comment) (snvoc:Post)} ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000026388279067534"^^xsd:long . ?message snvoc:hasCreator ?rootPerson . ?message a ?type . ?message snvoc:id ?messageId . ?person a snvoc:Person . ?person snvoc:id ?personId . ?person snvoc:likes ?like . ?like snvoc:hasPost|snvoc:hasComment ?message . ?like snvoc:creationDate ?mostRecentLikeDate . } GROUP BY ?person } . ?person snvoc:id ?personId . ?person snvoc:firstName ?firstName . ?person snvoc:lastName ?lastName . ?person snvoc:likes ?like . ?like snvoc:hasPost|snvoc:hasComment ?message . ?message snvoc:id ?messageId . ?like snvoc:creationDate ?likeCreationDate . ?message snvoc:creationDate ?messageCreationDate . ?message snvoc:content|snvoc:imageFile ?content . BIND( ?likeCreationDate - ?messageCreationDate AS ?latencyInDuration ) BIND( (DAY(?latencyInDuration) * 24 + HOURS(?latencyInDuration)) * 60 + MINUTES(?latencyInDuration) AS ?latency ) ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000026388279067534"^^xsd:long . BIND( NOT EXISTS { ?rootPerson (snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson) ?person } AS ?isNew ) } ORDER BY DESC(?likeCreationDate) ?personId #LdbcQuery7 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT ?personId ?personFirstName ?personLastName ?commentCreationDate ?commentId ?commentContent WHERE { VALUES (?type) {(snvoc:Comment) (snvoc:Post)} ?rootPerson a snvoc:Person . ?rootPerson snvoc:id "00000002199023256816"^^xsd:long . ?message snvoc:hasCreator ?rootPerson . ?message a ?type . ?comment a snvoc:Comment . ?comment snvoc:replyOf ?message . ?comment snvoc:creationDate ?commentCreationDate . ?comment snvoc:id ?commentId . ?comment snvoc:content ?commentContent . ?comment snvoc:hasCreator ?person . ?person snvoc:id ?personId . ?person snvoc:firstName ?personFirstName . ?person snvoc:lastName ?personLastName } ORDER BY DESC(?commentCreationDate) ?commentId LIMIT 20 #LdbcQuery8 PREFIX rdf: PREFIX rdfs: PREFIX xsd: PREFIX sn: PREFIX snvoc: PREFIX sntag: PREFIX foaf: PREFIX dbpedia: PREFIX dbpedia-owl: SELECT (?frId AS ?personId) (?first AS ?personFirstName) (?last AS ?personLastName) (?messageId AS ?commentOrPostId) (?content AS ?commentOrPostContent) (?creationDate AS ?commentOrPostCreationDate) WHERE { VALUES (?type) {(snvoc:Comment) (snvoc:Post)} { SELECT DISTINCT ?fr ?frId WHERE { BIND( "00000032985348834013"^^xsd:long AS ?rootId ) ?rootPerson a snvoc:Person . ?rootPerson snvoc:id ?rootId . ?rootPerson ((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson))?/((snvoc:knows/snvoc:hasPerson)|^(snvoc:knows/snvoc:hasPerson)) ?fr . ?fr snvoc:id ?frId . FILTER(?frId != ?rootId) } } . ?message snvoc:hasCreator ?fr . ?message a ?type . ?message snvoc:creationDate ?creationDate . FILTER(?creationDate < "2012-08-28T00:00:00.000Z"^^xsd:dateTime) . ?message snvoc:content|snvoc:imageFile ?content . ?message snvoc:id ?messageId . ?fr snvoc:firstName ?first . ?fr snvoc:lastName ?last . ?fr snvoc:id ?frId } ORDER BY DESC(?creationDate) ?post LIMIT 20