Paste P6583

(wdt:P1344/wdt:P31) wd:Q1344963 timeout
ActivePublic

Authored by Nemo_bis on Jan 14 2018, 7:19 PM.
PREFIX schema: <http://schema.org/>
SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
?item wdt:P31 wd:Q5.
?item wdt:P21 wd:Q6581072.
?item (wdt:P1344/wdt:P31) wd:Q1344963 .
?sitelink schema:about ?item.
FILTER(NOT EXISTS {
?wfr schema:about ?item.
?wfr schema:inLanguage "it".
})
}
GROUP BY ?item ?itemLabel
HAVING (?count > 0)
LIMIT 100
EXPLAIN:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text&#47;html;charset=UTF-8"><title>blazegraph&trade; by SYSTAP</title
></head
><body<h1>Query</h1
><h2>SPARQL</h2
><pre>PREFIX schema: &lt;http:&#47;&#47;schema.org&#47;&gt;
SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
?item wdt:P31 wd:Q5.
?item wdt:P21 wd:Q6581072.
?item (wdt:P1344&#47;wdt:P31) wd:Q1344963 .
?sitelink schema:about ?item.
FILTER(NOT EXISTS {
?wfr schema:about ?item.
?wfr schema:inLanguage &#34;it&#34;.
})
}
GROUP BY ?item ?itemLabel
HAVING (?count &gt; 0)
LIMIT 100</pre
><h2>Parse Tree</h2
><pre>QueryContainer
PrefixDecl (prefix=schema)
IRI (http:&#47;&#47;schema.org&#47;)
SelectQuery
Select
ProjectionElem
Var (item)
ProjectionElem
Count
Var (sitelink)
Var (count)
WhereClause
GraphPatternGroup
BasicGraphPattern
TriplesSameSubjectPath
Var (item)
PropertyListPath
PathAlternative
PathSequence
PathElt
IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P31)
ObjectList
IRI (http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q5)
TriplesSameSubjectPath
Var (item)
PropertyListPath
PathAlternative
PathSequence
PathElt
IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P21)
ObjectList
IRI (http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q6581072)
TriplesSameSubjectPath
Var (item)
PropertyListPath
PathAlternative
PathSequence
PathElt
PathAlternative
PathSequence
PathElt
IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P1344)
PathElt
IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P31)
ObjectList
IRI (http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q1344963)
TriplesSameSubjectPath
Var (sitelink)
PropertyListPath
PathAlternative
PathSequence
PathElt
IRI (http:&#47;&#47;schema.org&#47;about)
ObjectList
Var (item)
Constraint
NotExistsFunc
GraphPatternGroup
BasicGraphPattern
TriplesSameSubjectPath
Var (wfr)
PropertyListPath
PathAlternative
PathSequence
PathElt
IRI (http:&#47;&#47;schema.org&#47;about)
ObjectList
Var (item)
TriplesSameSubjectPath
Var (wfr)
PropertyListPath
PathAlternative
PathSequence
PathElt
IRI (http:&#47;&#47;schema.org&#47;inLanguage)
ObjectList
RDFLiteral
String (it)
GroupClause
GroupCondition
Var (item)
GroupCondition
Var (itemLabel)
HavingClause
Constraint
Compare (GT)
Var (count)
NumericLiteral (value=0, datatype=http:&#47;&#47;www.w3.org&#47;2001&#47;XMLSchema#integer)
Limit (100)</pre
><h2>Original AST</h2
><pre>
PREFIX schema: &lt;http:&#47;&#47;schema.org&#47;&gt;
PREFIX rdf: &lt;http:&#47;&#47;www.w3.org&#47;1999&#47;02&#47;22-rdf-syntax-ns#&gt;
PREFIX rdfs: &lt;http:&#47;&#47;www.w3.org&#47;2000&#47;01&#47;rdf-schema#&gt;
PREFIX sesame: &lt;http:&#47;&#47;www.openrdf.org&#47;schema&#47;sesame#&gt;
PREFIX owl: &lt;http:&#47;&#47;www.w3.org&#47;2002&#47;07&#47;owl#&gt;
PREFIX xsd: &lt;http:&#47;&#47;www.w3.org&#47;2001&#47;XMLSchema#&gt;
PREFIX fn: &lt;http:&#47;&#47;www.w3.org&#47;2005&#47;xpath-functions#&gt;
PREFIX foaf: &lt;http:&#47;&#47;xmlns.com&#47;foaf&#47;0.1&#47;&gt;
PREFIX dc: &lt;http:&#47;&#47;purl.org&#47;dc&#47;elements&#47;1.1&#47;&gt;
PREFIX hint: &lt;http:&#47;&#47;www.bigdata.com&#47;queryHints#&gt;
PREFIX bd: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf#&gt;
PREFIX bds: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;search#&gt;
PREFIX psn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value-normalized&#47;&gt;
PREFIX pqn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value-normalized&#47;&gt;
PREFIX prn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value-normalized&#47;&gt;
PREFIX mwapi: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#API&#47;&gt;
PREFIX gas: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;gas#&gt;
PREFIX wdt: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;&gt;
PREFIX wdtn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct-normalized&#47;&gt;
PREFIX psv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value&#47;&gt;
PREFIX ps: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;&gt;
PREFIX pqv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value&#47;&gt;
PREFIX pq: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;&gt;
PREFIX prv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value&#47;&gt;
PREFIX pr: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;&gt;
PREFIX wdno: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;novalue&#47;&gt;
PREFIX p: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;&gt;
PREFIX wikibase: &lt;http:&#47;&#47;wikiba.se&#47;ontology#&gt;
PREFIX wd: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;&gt;
PREFIX wds: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;statement&#47;&gt;
PREFIX wdv: &lt;http:&#47;&#47;www.wikidata.org&#47;value&#47;&gt;
PREFIX wdref: &lt;http:&#47;&#47;www.wikidata.org&#47;reference&#47;&gt;
PREFIX wdata: &lt;http:&#47;&#47;www.wikidata.org&#47;wiki&#47;Special:EntityData&#47;&gt;
PREFIX prov: &lt;http:&#47;&#47;www.w3.org&#47;ns&#47;prov#&gt;
PREFIX skos: &lt;http:&#47;&#47;www.w3.org&#47;2004&#47;02&#47;skos&#47;core#&gt;
PREFIX geo: &lt;http:&#47;&#47;www.opengis.net&#47;ont&#47;geosparql#&gt;
PREFIX geof: &lt;http:&#47;&#47;www.opengis.net&#47;def&#47;geosparql&#47;function&#47;&gt;
PREFIX mediawiki: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#&gt;
QueryType: SELECT
includeInferred=true
timeout=60000
SELECT VarNode(item) ( com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(sitelink))[ FunctionNode.scalarVals={com.bigdata.bop.aggregate.AggregateBase.distinct=true}, FunctionNode.functionURI=http:&#47;&#47;www.w3.org&#47;2006&#47;sparql-functions#count, valueExpr=com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true]] AS VarNode(count) )
JoinGroupNode {
StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedByte(31)), ConstantNode(Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedByte(5))) [scope=DEFAULT_CONTEXTS]
StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedByte(21)), ConstantNode(Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedInt(6581072))) [scope=DEFAULT_CONTEXTS]
PropertyPathNode(VarNode(item), com.bigdata.rdf.sparql.ast.PathNode(PathAlternative), ConstantNode(Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedInt(1344963))) [scope=DEFAULT_CONTEXTS]
StatementPatternNode(VarNode(sitelink), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
FILTER( NotExistsNode(VarNode(-exists-1))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http:&#47;&#47;www.bigdata.com&#47;sparql-1.1-undefined-functionsnot-exists, graphPattern=
JoinGroupNode {
StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http:&#47;&#47;schema.org&#47;inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
}, valueExpr=com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1))] )
}
group by VarNode(item) VarNode(itemLabel)
having com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(count),ConstantNode(XSDInteger(0)))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http:&#47;&#47;www.w3.org&#47;2005&#47;xpath-functions#greater-than, valueExpr=com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT]]
slice(limit=100)</pre
><h2>Static Analysis Statistics</h2
><table><tr><th>object</th
><th>category</th
><th>elapsed [ms]</th
><th>elapsed [us]</th
><th>numCalls</th
></tr
><tr><td>ParseTime</td
><td>Parser</td
><td>1</td
><td>1478</td
><td>1</td
></tr
><tr><td>ResolveValues</td
><td>Resolve Values</td
><td>0</td
><td>770</td
><td>1</td
></tr
><tr><td>Optimizers</td
><td>Optimizers (all)</td
><td>3</td
><td>3863</td
><td>1</td
></tr
><tr><td>ASTOrderByAggregateFlatteningOptimizer</td
><td>Optimizer</td
><td>0</td
><td>4</td
><td>1</td
></tr
><tr><td>ASTQueryHintOptimizer</td
><td>Optimizer</td
><td>0</td
><td>414</td
><td>1</td
></tr
><tr><td>LabelServicePlacementOptimizer</td
><td>Optimizer</td
><td>0</td
><td>6</td
><td>1</td
></tr
><tr><td>ASTFilterNormalizationOptimizer</td
><td>Optimizer</td
><td>0</td
><td>2</td
><td>1</td
></tr
><tr><td>ASTStaticBindingsOptimizer</td
><td>Optimizer</td
><td>0</td
><td>44</td
><td>1</td
></tr
><tr><td>ASTSearchInSearchOptimizer</td
><td>Optimizer</td
><td>0</td
><td>5</td
><td>1</td
></tr
><tr><td>ASTPropertyPathOptimizer</td
><td>Optimizer</td
><td>0</td
><td>26</td
><td>1</td
></tr
><tr><td>ASTSetValueExpressionsOptimizer</td
><td>Optimizer</td
><td>0</td
><td>436</td
><td>1</td
></tr
><tr><td>ASTFlattenUnionsOptimizer</td
><td>Optimizer</td
><td>0</td
><td>2</td
><td>1</td
></tr
><tr><td>ASTUnionFiltersOptimizer</td
><td>Optimizer</td
><td>0</td
><td>2</td
><td>1</td
></tr
><tr><td>ASTEmptyGroupOptimizer</td
><td>Optimizer</td
><td>0</td
><td>2</td
><td>1</td
></tr
><tr><td>ASTWildcardProjectionOptimizer</td
><td>Optimizer</td
><td>0</td
><td>146</td
><td>1</td
></tr
><tr><td>ASTSearchOptimizer</td
><td>Optimizer</td
><td>0</td
><td>6</td
><td>1</td
></tr
><tr><td>ASTFulltextSearchOptimizer</td
><td>Optimizer</td
><td>0</td
><td>4</td
><td>1</td
></tr
><tr><td>ASTGeoSpatialSearchOptimizer</td
><td>Optimizer</td
><td>0</td
><td>5</td
><td>1</td
></tr
><tr><td>AskOptimizer</td
><td>Optimizer</td
><td>0</td
><td>1</td
><td>1</td
></tr
><tr><td>ASTDescribeOptimizer</td
><td>Optimizer</td
><td>0</td
><td>1</td
><td>1</td
></tr
><tr><td>ASTConstructOptimizer</td
><td>Optimizer</td
><td>0</td
><td>3</td
><td>1</td
></tr
><tr><td>ASTExistsOptimizer</td
><td>Optimizer</td
><td>0</td
><td>47</td
><td>1</td
></tr
><tr><td>ASTGraphGroupOptimizer</td
><td>Optimizer</td
><td>0</td
><td>3</td
><td>1</td
></tr
><tr><td>ASTLiftPreFiltersOptimizer</td
><td>Optimizer</td
><td>0</td
><td>1</td
><td>1</td
></tr
><tr><td>ASTALPServiceOptimizer</td
><td>Optimizer</td
><td>0</td
><td>4</td
><td>1</td
></tr
><tr><td>ASTBottomUpOptimizer</td
><td>Optimizer</td
><td>0</td
><td>687</td
><td>1</td
></tr
><tr><td>ASTSimpleOptionalOptimizer</td
><td>Optimizer</td
><td>0</td
><td>2</td
><td>1</td
></tr
><tr><td>ASTFlattenJoinGroupsOptimizer</td
><td>Optimizer</td
><td>0</td
><td>3</td
><td>1</td
></tr
><tr><td>ASTServiceNodeOptimizer</td
><td>Optimizer</td
><td>0</td
><td>2</td
><td>1</td
></tr
><tr><td>LabelServiceExtractOptimizer</td
><td>Optimizer</td
><td>0</td
><td>5</td
><td>1</td
></tr
><tr><td>ASTJoinGroupOrderOptimizer</td
><td>Optimizer</td
><td>0</td
><td>401</td
><td>2</td
></tr
><tr><td>ASTRunFirstRunLastOptimizer</td
><td>Optimizer</td
><td>0</td
><td>8</td
><td>2</td
></tr
><tr><td>ASTRangeOptimizer</td
><td>Optimizer</td
><td>0</td
><td>4</td
><td>1</td
></tr
><tr><td>ASTRangeCountOptimizer</td
><td>Optimizer</td
><td>1</td
><td>1212</td
><td>1</td
></tr
><tr><td>ASTCardinalityOptimizer</td
><td>Optimizer</td
><td>0</td
><td>6</td
><td>1</td
></tr
><tr><td>ASTFastRangeCountOptimizer</td
><td>Optimizer</td
><td>0</td
><td>12</td
><td>1</td
></tr
><tr><td>ASTSimpleGroupByAndCountOptimizer</td
><td>Optimizer</td
><td>0</td
><td>2</td
><td>1</td
></tr
><tr><td>ASTDistinctTermScanOptimizer</td
><td>Optimizer</td
><td>0</td
><td>4</td
><td>1</td
></tr
><tr><td>ASTStaticJoinOptimizer</td
><td>Optimizer</td
><td>0</td
><td>84</td
><td>1</td
></tr
><tr><td>ASTAttachJoinFiltersOptimizer</td
><td>Optimizer</td
><td>0</td
><td>83</td
><td>1</td
></tr
><tr><td>ASTSparql11SubqueryOptimizer</td
><td>Optimizer</td
><td>0</td
><td>4</td
><td>1</td
></tr
><tr><td>ASTNamedSubqueryOptimizer</td
><td>Optimizer</td
><td>0</td
><td>1</td
><td>1</td
></tr
><tr><td>ASTSubGroupJoinVarOptimizer</td
><td>Optimizer</td
><td>0</td
><td>3</td
><td>1</td
></tr
><tr><td>EmptyLabelServiceOptimizer</td
><td>Optimizer</td
><td>0</td
><td>6</td
><td>1</td
></tr
><tr><td>RangeCount</td
><td>Range Count</td
><td>3</td
><td>3076</td
><td>7</td
></tr
></table
><h2>Optimized AST</h2
><pre>
PREFIX schema: &lt;http:&#47;&#47;schema.org&#47;&gt;
PREFIX rdf: &lt;http:&#47;&#47;www.w3.org&#47;1999&#47;02&#47;22-rdf-syntax-ns#&gt;
PREFIX rdfs: &lt;http:&#47;&#47;www.w3.org&#47;2000&#47;01&#47;rdf-schema#&gt;
PREFIX sesame: &lt;http:&#47;&#47;www.openrdf.org&#47;schema&#47;sesame#&gt;
PREFIX owl: &lt;http:&#47;&#47;www.w3.org&#47;2002&#47;07&#47;owl#&gt;
PREFIX xsd: &lt;http:&#47;&#47;www.w3.org&#47;2001&#47;XMLSchema#&gt;
PREFIX fn: &lt;http:&#47;&#47;www.w3.org&#47;2005&#47;xpath-functions#&gt;
PREFIX foaf: &lt;http:&#47;&#47;xmlns.com&#47;foaf&#47;0.1&#47;&gt;
PREFIX dc: &lt;http:&#47;&#47;purl.org&#47;dc&#47;elements&#47;1.1&#47;&gt;
PREFIX hint: &lt;http:&#47;&#47;www.bigdata.com&#47;queryHints#&gt;
PREFIX bd: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf#&gt;
PREFIX bds: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;search#&gt;
PREFIX psn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value-normalized&#47;&gt;
PREFIX pqn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value-normalized&#47;&gt;
PREFIX prn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value-normalized&#47;&gt;
PREFIX mwapi: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#API&#47;&gt;
PREFIX gas: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;gas#&gt;
PREFIX wdt: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;&gt;
PREFIX wdtn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct-normalized&#47;&gt;
PREFIX psv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value&#47;&gt;
PREFIX ps: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;&gt;
PREFIX pqv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value&#47;&gt;
PREFIX pq: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;&gt;
PREFIX prv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value&#47;&gt;
PREFIX pr: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;&gt;
PREFIX wdno: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;novalue&#47;&gt;
PREFIX p: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;&gt;
PREFIX wikibase: &lt;http:&#47;&#47;wikiba.se&#47;ontology#&gt;
PREFIX wd: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;&gt;
PREFIX wds: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;statement&#47;&gt;
PREFIX wdv: &lt;http:&#47;&#47;www.wikidata.org&#47;value&#47;&gt;
PREFIX wdref: &lt;http:&#47;&#47;www.wikidata.org&#47;reference&#47;&gt;
PREFIX wdata: &lt;http:&#47;&#47;www.wikidata.org&#47;wiki&#47;Special:EntityData&#47;&gt;
PREFIX prov: &lt;http:&#47;&#47;www.w3.org&#47;ns&#47;prov#&gt;
PREFIX skos: &lt;http:&#47;&#47;www.w3.org&#47;2004&#47;02&#47;skos&#47;core#&gt;
PREFIX geo: &lt;http:&#47;&#47;www.opengis.net&#47;ont&#47;geosparql#&gt;
PREFIX geof: &lt;http:&#47;&#47;www.opengis.net&#47;def&#47;geosparql&#47;function&#47;&gt;
PREFIX mediawiki: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#&gt;
QueryType: SELECT
includeInferred=true
timeout=60000
SELECT ( VarNode(item) AS VarNode(item) ) ( com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(sitelink))[ FunctionNode.scalarVals={com.bigdata.bop.aggregate.AggregateBase.distinct=true}, FunctionNode.functionURI=http:&#47;&#47;www.w3.org&#47;2006&#47;sparql-functions#count, valueExpr=com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true]] AS VarNode(count) )
JoinGroupNode {
StatementPatternNode(VarNode(--pp-anon-d7785ce1-fb55-4cbd-9f53-6d8d8de0f74c)[anonymous], ConstantNode(Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedByte(31)), ConstantNode(Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedInt(1344963))) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=661
AST2BOpBase.originalIndex=POS
StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedShort(1344)), VarNode(--pp-anon-d7785ce1-fb55-4cbd-9f53-6d8d8de0f74c)[anonymous]) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=304519
AST2BOpBase.originalIndex=POS
QueryType: ASK
SELECT VarNode(item) VarNode(-exists-1)[anonymous]
JoinGroupNode {
StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http:&#47;&#47;schema.org&#47;inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=1923821
AST2BOpBase.originalIndex=POS
StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=61377603
AST2BOpBase.originalIndex=POS
}
@askVar=-exists-1
FILTER( NotExistsNode(VarNode(-exists-1))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http:&#47;&#47;www.bigdata.com&#47;sparql-1.1-undefined-functionsnot-exists, graphPattern=
JoinGroupNode {
StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http:&#47;&#47;schema.org&#47;inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=1923821
AST2BOpBase.originalIndex=POS
StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=61377603
AST2BOpBase.originalIndex=POS
}, valueExpr=com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1))] )
StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedByte(21)), ConstantNode(Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedInt(6581072))) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=624933
AST2BOpBase.originalIndex=POS
StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedByte(31)), ConstantNode(Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedByte(5))) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=4085615
AST2BOpBase.originalIndex=POS
StatementPatternNode(VarNode(sitelink), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
AST2BOpBase.estimatedCardinality=61377603
AST2BOpBase.originalIndex=POS
}
group by ( VarNode(item) AS VarNode(item) ) ( VarNode(itemLabel) AS VarNode(itemLabel) )
having com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(count),ConstantNode(XSDInteger(0)))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http:&#47;&#47;www.w3.org&#47;2005&#47;xpath-functions#greater-than, valueExpr=com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT]]
slice(limit=100)
with static (exogeneous) bindings defined as follows:
{
{ }
}
</pre
><h2>Query Plan</h2
><pre>com.bigdata.bop.solutions.SliceOp[24](ProjectionOp[23])[ BOp.bopId=24, SliceOp.offset=0, SliceOp.limit=100, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=true, PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false, PipelineOp.sharedState=true, BOp.timeout=60000, BOp.namespace=wdq, QueryEngine.queryId=222f3cf9-7789-4e1f-9c50-82d808e5e96e, QueryEngine.chunkHandler=com.bigdata.bop.engine.NativeHeapStandloneChunkHandler@39dafcfa]
com.bigdata.bop.solutions.ProjectionOp[23](MemoryGroupByOp[22])[ BOp.bopId=23, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, JoinAnnotations.select=[item, count]]
com.bigdata.bop.solutions.MemoryGroupByOp[22](ChunkedMaterializationOp[21])[ BOp.bopId=22, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=false, PipelineOp.maxMemory=0, GroupByOp.groupByState=GroupByState{select=[com.bigdata.bop.Bind(item,item), com.bigdata.bop.Bind(count,com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true])],groupBy=[com.bigdata.bop.Bind(item,item), com.bigdata.bop.Bind(itemLabel,itemLabel)],having=[com.bigdata.rdf.internal.constraints.SPARQLConstraint(com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT])]}, GroupByOp.groupByRewrite=GroupByRewriter{aggExpr={com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true]=ef05773f-eea0-4699-9d87-4a74e40f563d},select2=[com.bigdata.bop.Bind(item,item), com.bigdata.bop.Bind(count,ef05773f-eea0-4699-9d87-4a74e40f563d)],having2=[com.bigdata.rdf.internal.constraints.SPARQLConstraint(com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT])]}]
com.bigdata.bop.rdf.join.ChunkedMaterializationOp[21](DropOp[20])[ ChunkedMaterializationOp.vars=[count], IPredicate.relationName=[wdq.lex], IPredicate.timestamp=1515957318305, ChunkedMaterializationOp.materializeAll=false, PipelineOp.sharedState=true, PipelineOp.reorderSolutions=true, PipelineOp.maxParallel=5, BOp.bopId=21]
com.bigdata.bop.solutions.DropOp[20](PipelineJoin[19])[ BOp.bopId=20, DropOp.dropVars=[-exists-1]]
com.bigdata.bop.join.PipelineJoin[19](PipelineJoin[17])[ BOp.bopId=19, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, BOp.evaluationContext=ANY, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[18](sitelink=null, Vocab(40)[http:&#47;&#47;schema.org&#47;about], item=null)[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1515957318305, BOp.bopId=18, AST2BOpBase.estimatedCardinality=61377603, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
com.bigdata.bop.join.PipelineJoin[17](PipelineJoin[15])[ BOp.bopId=17, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, BOp.evaluationContext=ANY, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[16](item=null, Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedByte(31), Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedByte(5))[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1515957318305, BOp.bopId=16, AST2BOpBase.estimatedCardinality=4085615, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
com.bigdata.bop.join.PipelineJoin[15](ConditionalRoutingOp[11])[ BOp.bopId=15, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, BOp.evaluationContext=ANY, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[14](item=null, Vocab(6)[http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P]:XSDUnsignedByte(21), Vocab(2)[http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q]:XSDUnsignedInt(6581072))[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1515957318305, BOp.bopId=14, AST2BOpBase.estimatedCardinality=624933, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
com.bigdata.bop.bset.ConditionalRoutingOp[11](ChunkedMaterializationOp[13])[ BOp.bopId=11, ConditionalRoutingOp.condition=com.bigdata.rdf.internal.constraints.SPARQLConstraint(com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1)))]
com.bigdata.bop.rdf.join.ChunkedMaterializationOp[13](ConditionalRoutingOp[12])[ ChunkedMaterializationOp.vars=[-exists-1], IPredicate.relationName=[wdq.lex], IPredicate.timestamp=1515957318305, ChunkedMaterializationOp.materializeAll=false, PipelineOp.sharedState=true, PipelineOp.reorderSolutions=true, PipelineOp.maxParallel=5, BOp.bopId=13]
SPARQL-QUERY: queryStr=PREFIX schema: <http://schema.org/>
SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
?item wdt:P31 wd:Q5.
?item wdt:P21 wd:Q6581072.
?item (wdt:P1344/wdt:P31) wd:Q1344963 .
?sitelink schema:about ?item.
FILTER(NOT EXISTS {
?wfr schema:about ?item.
?wfr schema:inLanguage "it".
})
}
GROUP BY ?item ?itemLabel
HAVING (?count > 0)
LIMIT 100
java.util.concurrent.TimeoutException
at java.util.concurrent.FutureTask.get(FutureTask.java:205)
at com.bigdata.rdf.sail.webapp.BigdataServlet.submitApiTask(BigdataServlet.java:293)
at com.bigdata.rdf.sail.webapp.QueryServlet.doSparqlQuery(QueryServlet.java:654)
at com.bigdata.rdf.sail.webapp.QueryServlet.doGet(QueryServlet.java:288)
at com.bigdata.rdf.sail.webapp.RESTServlet.doGet(RESTServlet.java:240)
at com.bigdata.rdf.sail.webapp.MultiTenancyServlet.doGet(MultiTenancyServlet.java:271)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:769)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1667)
at org.wikidata.query.rdf.blazegraph.throttling.ThrottlingFilter.doFilter(ThrottlingFilter.java:304)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at ch.qos.logback.classic.helpers.MDCInsertingServletFilter.doFilter(MDCInsertingServletFilter.java:49)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at org.wikidata.query.rdf.blazegraph.filters.ClientIPFilter.doFilter(ClientIPFilter.java:43)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:610)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:539)
at java.lang.Thread.run(Thread.java:748)
Nemo_bis created this paste.Jan 14 2018, 7:19 PM
SELECT DISTINCT ?item ?count WHERE {
  ?item wdt:P31 wd:Q5;
        wdt:P21 wd:Q6581072;
        wdt:P1344/wdt:P31 wd:Q1344963;
        wikibase:sitelinks ?count .
  FILTER( ?count > 0 ) .
  MINUS { ?item ^schema:about/schema:inLanguage "it" } .
}
LIMIT 100