Paste P6583

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

Authored by Nemo_bis on Jan 14 2018, 7:19 PM.
1​PREFIX schema: <http://schema.org/>
2
3​SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
4​ ?item wdt:P31 wd:Q5.
5​ ?item wdt:P21 wd:Q6581072.
6​ ?item (wdt:P1344/wdt:P31) wd:Q1344963 .
7​ ?sitelink schema:about ?item.
8​ FILTER(NOT EXISTS {
9​ ?wfr schema:about ?item.
10​ ?wfr schema:inLanguage "it".
11​ })
12​}
13​GROUP BY ?item ?itemLabel
14​HAVING (?count > 0)
15​LIMIT 100
16
17​EXPLAIN:
18
19​<!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
20​></head
21​><body<h1>Query</h1
22​><h2>SPARQL</h2
23​><pre>PREFIX schema: &lt;http:&#47;&#47;schema.org&#47;&gt;
24
25​SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
26​ ?item wdt:P31 wd:Q5.
27​ ?item wdt:P21 wd:Q6581072.
28​ ?item (wdt:P1344&#47;wdt:P31) wd:Q1344963 .
29​ ?sitelink schema:about ?item.
30​ FILTER(NOT EXISTS {
31​ ?wfr schema:about ?item.
32​ ?wfr schema:inLanguage &#34;it&#34;.
33​ })
34​}
35​GROUP BY ?item ?itemLabel
36​HAVING (?count &gt; 0)
37​LIMIT 100</pre
38​><h2>Parse Tree</h2
39​><pre>QueryContainer
40​ PrefixDecl (prefix=schema)
41​ IRI (http:&#47;&#47;schema.org&#47;)
42​ SelectQuery
43​ Select
44​ ProjectionElem
45​ Var (item)
46​ ProjectionElem
47​ Count
48​ Var (sitelink)
49​ Var (count)
50​ WhereClause
51​ GraphPatternGroup
52​ BasicGraphPattern
53​ TriplesSameSubjectPath
54​ Var (item)
55​ PropertyListPath
56​ PathAlternative
57​ PathSequence
58​ PathElt
59​ IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P31)
60​ ObjectList
61​ IRI (http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q5)
62​ TriplesSameSubjectPath
63​ Var (item)
64​ PropertyListPath
65​ PathAlternative
66​ PathSequence
67​ PathElt
68​ IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P21)
69​ ObjectList
70​ IRI (http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q6581072)
71​ TriplesSameSubjectPath
72​ Var (item)
73​ PropertyListPath
74​ PathAlternative
75​ PathSequence
76​ PathElt
77​ PathAlternative
78​ PathSequence
79​ PathElt
80​ IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P1344)
81​ PathElt
82​ IRI (http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;P31)
83​ ObjectList
84​ IRI (http:&#47;&#47;www.wikidata.org&#47;entity&#47;Q1344963)
85​ TriplesSameSubjectPath
86​ Var (sitelink)
87​ PropertyListPath
88​ PathAlternative
89​ PathSequence
90​ PathElt
91​ IRI (http:&#47;&#47;schema.org&#47;about)
92​ ObjectList
93​ Var (item)
94​ Constraint
95​ NotExistsFunc
96​ GraphPatternGroup
97​ BasicGraphPattern
98​ TriplesSameSubjectPath
99​ Var (wfr)
100​ PropertyListPath
101​ PathAlternative
102​ PathSequence
103​ PathElt
104​ IRI (http:&#47;&#47;schema.org&#47;about)
105​ ObjectList
106​ Var (item)
107​ TriplesSameSubjectPath
108​ Var (wfr)
109​ PropertyListPath
110​ PathAlternative
111​ PathSequence
112​ PathElt
113​ IRI (http:&#47;&#47;schema.org&#47;inLanguage)
114​ ObjectList
115​ RDFLiteral
116​ String (it)
117​ GroupClause
118​ GroupCondition
119​ Var (item)
120​ GroupCondition
121​ Var (itemLabel)
122​ HavingClause
123​ Constraint
124​ Compare (GT)
125​ Var (count)
126​ NumericLiteral (value=0, datatype=http:&#47;&#47;www.w3.org&#47;2001&#47;XMLSchema#integer)
127​ Limit (100)</pre
128​><h2>Original AST</h2
129​><pre>
130​PREFIX schema: &lt;http:&#47;&#47;schema.org&#47;&gt;
131​PREFIX rdf: &lt;http:&#47;&#47;www.w3.org&#47;1999&#47;02&#47;22-rdf-syntax-ns#&gt;
132​PREFIX rdfs: &lt;http:&#47;&#47;www.w3.org&#47;2000&#47;01&#47;rdf-schema#&gt;
133​PREFIX sesame: &lt;http:&#47;&#47;www.openrdf.org&#47;schema&#47;sesame#&gt;
134​PREFIX owl: &lt;http:&#47;&#47;www.w3.org&#47;2002&#47;07&#47;owl#&gt;
135​PREFIX xsd: &lt;http:&#47;&#47;www.w3.org&#47;2001&#47;XMLSchema#&gt;
136​PREFIX fn: &lt;http:&#47;&#47;www.w3.org&#47;2005&#47;xpath-functions#&gt;
137​PREFIX foaf: &lt;http:&#47;&#47;xmlns.com&#47;foaf&#47;0.1&#47;&gt;
138​PREFIX dc: &lt;http:&#47;&#47;purl.org&#47;dc&#47;elements&#47;1.1&#47;&gt;
139​PREFIX hint: &lt;http:&#47;&#47;www.bigdata.com&#47;queryHints#&gt;
140​PREFIX bd: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf#&gt;
141​PREFIX bds: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;search#&gt;
142​PREFIX psn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value-normalized&#47;&gt;
143​PREFIX pqn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value-normalized&#47;&gt;
144​PREFIX prn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value-normalized&#47;&gt;
145​PREFIX mwapi: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#API&#47;&gt;
146​PREFIX gas: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;gas#&gt;
147​PREFIX wdt: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;&gt;
148​PREFIX wdtn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct-normalized&#47;&gt;
149​PREFIX psv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value&#47;&gt;
150​PREFIX ps: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;&gt;
151​PREFIX pqv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value&#47;&gt;
152​PREFIX pq: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;&gt;
153​PREFIX prv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value&#47;&gt;
154​PREFIX pr: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;&gt;
155​PREFIX wdno: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;novalue&#47;&gt;
156​PREFIX p: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;&gt;
157​PREFIX wikibase: &lt;http:&#47;&#47;wikiba.se&#47;ontology#&gt;
158​PREFIX wd: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;&gt;
159​PREFIX wds: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;statement&#47;&gt;
160​PREFIX wdv: &lt;http:&#47;&#47;www.wikidata.org&#47;value&#47;&gt;
161​PREFIX wdref: &lt;http:&#47;&#47;www.wikidata.org&#47;reference&#47;&gt;
162​PREFIX wdata: &lt;http:&#47;&#47;www.wikidata.org&#47;wiki&#47;Special:EntityData&#47;&gt;
163​PREFIX prov: &lt;http:&#47;&#47;www.w3.org&#47;ns&#47;prov#&gt;
164​PREFIX skos: &lt;http:&#47;&#47;www.w3.org&#47;2004&#47;02&#47;skos&#47;core#&gt;
165​PREFIX geo: &lt;http:&#47;&#47;www.opengis.net&#47;ont&#47;geosparql#&gt;
166​PREFIX geof: &lt;http:&#47;&#47;www.opengis.net&#47;def&#47;geosparql&#47;function&#47;&gt;
167​PREFIX mediawiki: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#&gt;
168​QueryType: SELECT
169​includeInferred=true
170​timeout=60000
171​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) )
172​ JoinGroupNode {
173​ 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]
174​ 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]
175​ 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]
176​ StatementPatternNode(VarNode(sitelink), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
177​ FILTER( NotExistsNode(VarNode(-exists-1))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http:&#47;&#47;www.bigdata.com&#47;sparql-1.1-undefined-functionsnot-exists, graphPattern=
178​ JoinGroupNode {
179​ StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
180​ StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http:&#47;&#47;schema.org&#47;inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
181​ }, valueExpr=com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1))] )
182​ }
183​group by VarNode(item) VarNode(itemLabel)
184​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]]
185​slice(limit=100)</pre
186​><h2>Static Analysis Statistics</h2
187​><table><tr><th>object</th
188​><th>category</th
189​><th>elapsed [ms]</th
190​><th>elapsed [us]</th
191​><th>numCalls</th
192​></tr
193​><tr><td>ParseTime</td
194​><td>Parser</td
195​><td>1</td
196​><td>1478</td
197​><td>1</td
198​></tr
199​><tr><td>ResolveValues</td
200​><td>Resolve Values</td
201​><td>0</td
202​><td>770</td
203​><td>1</td
204​></tr
205​><tr><td>Optimizers</td
206​><td>Optimizers (all)</td
207​><td>3</td
208​><td>3863</td
209​><td>1</td
210​></tr
211​><tr><td>ASTOrderByAggregateFlatteningOptimizer</td
212​><td>Optimizer</td
213​><td>0</td
214​><td>4</td
215​><td>1</td
216​></tr
217​><tr><td>ASTQueryHintOptimizer</td
218​><td>Optimizer</td
219​><td>0</td
220​><td>414</td
221​><td>1</td
222​></tr
223​><tr><td>LabelServicePlacementOptimizer</td
224​><td>Optimizer</td
225​><td>0</td
226​><td>6</td
227​><td>1</td
228​></tr
229​><tr><td>ASTFilterNormalizationOptimizer</td
230​><td>Optimizer</td
231​><td>0</td
232​><td>2</td
233​><td>1</td
234​></tr
235​><tr><td>ASTStaticBindingsOptimizer</td
236​><td>Optimizer</td
237​><td>0</td
238​><td>44</td
239​><td>1</td
240​></tr
241​><tr><td>ASTSearchInSearchOptimizer</td
242​><td>Optimizer</td
243​><td>0</td
244​><td>5</td
245​><td>1</td
246​></tr
247​><tr><td>ASTPropertyPathOptimizer</td
248​><td>Optimizer</td
249​><td>0</td
250​><td>26</td
251​><td>1</td
252​></tr
253​><tr><td>ASTSetValueExpressionsOptimizer</td
254​><td>Optimizer</td
255​><td>0</td
256​><td>436</td
257​><td>1</td
258​></tr
259​><tr><td>ASTFlattenUnionsOptimizer</td
260​><td>Optimizer</td
261​><td>0</td
262​><td>2</td
263​><td>1</td
264​></tr
265​><tr><td>ASTUnionFiltersOptimizer</td
266​><td>Optimizer</td
267​><td>0</td
268​><td>2</td
269​><td>1</td
270​></tr
271​><tr><td>ASTEmptyGroupOptimizer</td
272​><td>Optimizer</td
273​><td>0</td
274​><td>2</td
275​><td>1</td
276​></tr
277​><tr><td>ASTWildcardProjectionOptimizer</td
278​><td>Optimizer</td
279​><td>0</td
280​><td>146</td
281​><td>1</td
282​></tr
283​><tr><td>ASTSearchOptimizer</td
284​><td>Optimizer</td
285​><td>0</td
286​><td>6</td
287​><td>1</td
288​></tr
289​><tr><td>ASTFulltextSearchOptimizer</td
290​><td>Optimizer</td
291​><td>0</td
292​><td>4</td
293​><td>1</td
294​></tr
295​><tr><td>ASTGeoSpatialSearchOptimizer</td
296​><td>Optimizer</td
297​><td>0</td
298​><td>5</td
299​><td>1</td
300​></tr
301​><tr><td>AskOptimizer</td
302​><td>Optimizer</td
303​><td>0</td
304​><td>1</td
305​><td>1</td
306​></tr
307​><tr><td>ASTDescribeOptimizer</td
308​><td>Optimizer</td
309​><td>0</td
310​><td>1</td
311​><td>1</td
312​></tr
313​><tr><td>ASTConstructOptimizer</td
314​><td>Optimizer</td
315​><td>0</td
316​><td>3</td
317​><td>1</td
318​></tr
319​><tr><td>ASTExistsOptimizer</td
320​><td>Optimizer</td
321​><td>0</td
322​><td>47</td
323​><td>1</td
324​></tr
325​><tr><td>ASTGraphGroupOptimizer</td
326​><td>Optimizer</td
327​><td>0</td
328​><td>3</td
329​><td>1</td
330​></tr
331​><tr><td>ASTLiftPreFiltersOptimizer</td
332​><td>Optimizer</td
333​><td>0</td
334​><td>1</td
335​><td>1</td
336​></tr
337​><tr><td>ASTALPServiceOptimizer</td
338​><td>Optimizer</td
339​><td>0</td
340​><td>4</td
341​><td>1</td
342​></tr
343​><tr><td>ASTBottomUpOptimizer</td
344​><td>Optimizer</td
345​><td>0</td
346​><td>687</td
347​><td>1</td
348​></tr
349​><tr><td>ASTSimpleOptionalOptimizer</td
350​><td>Optimizer</td
351​><td>0</td
352​><td>2</td
353​><td>1</td
354​></tr
355​><tr><td>ASTFlattenJoinGroupsOptimizer</td
356​><td>Optimizer</td
357​><td>0</td
358​><td>3</td
359​><td>1</td
360​></tr
361​><tr><td>ASTServiceNodeOptimizer</td
362​><td>Optimizer</td
363​><td>0</td
364​><td>2</td
365​><td>1</td
366​></tr
367​><tr><td>LabelServiceExtractOptimizer</td
368​><td>Optimizer</td
369​><td>0</td
370​><td>5</td
371​><td>1</td
372​></tr
373​><tr><td>ASTJoinGroupOrderOptimizer</td
374​><td>Optimizer</td
375​><td>0</td
376​><td>401</td
377​><td>2</td
378​></tr
379​><tr><td>ASTRunFirstRunLastOptimizer</td
380​><td>Optimizer</td
381​><td>0</td
382​><td>8</td
383​><td>2</td
384​></tr
385​><tr><td>ASTRangeOptimizer</td
386​><td>Optimizer</td
387​><td>0</td
388​><td>4</td
389​><td>1</td
390​></tr
391​><tr><td>ASTRangeCountOptimizer</td
392​><td>Optimizer</td
393​><td>1</td
394​><td>1212</td
395​><td>1</td
396​></tr
397​><tr><td>ASTCardinalityOptimizer</td
398​><td>Optimizer</td
399​><td>0</td
400​><td>6</td
401​><td>1</td
402​></tr
403​><tr><td>ASTFastRangeCountOptimizer</td
404​><td>Optimizer</td
405​><td>0</td
406​><td>12</td
407​><td>1</td
408​></tr
409​><tr><td>ASTSimpleGroupByAndCountOptimizer</td
410​><td>Optimizer</td
411​><td>0</td
412​><td>2</td
413​><td>1</td
414​></tr
415​><tr><td>ASTDistinctTermScanOptimizer</td
416​><td>Optimizer</td
417​><td>0</td
418​><td>4</td
419​><td>1</td
420​></tr
421​><tr><td>ASTStaticJoinOptimizer</td
422​><td>Optimizer</td
423​><td>0</td
424​><td>84</td
425​><td>1</td
426​></tr
427​><tr><td>ASTAttachJoinFiltersOptimizer</td
428​><td>Optimizer</td
429​><td>0</td
430​><td>83</td
431​><td>1</td
432​></tr
433​><tr><td>ASTSparql11SubqueryOptimizer</td
434​><td>Optimizer</td
435​><td>0</td
436​><td>4</td
437​><td>1</td
438​></tr
439​><tr><td>ASTNamedSubqueryOptimizer</td
440​><td>Optimizer</td
441​><td>0</td
442​><td>1</td
443​><td>1</td
444​></tr
445​><tr><td>ASTSubGroupJoinVarOptimizer</td
446​><td>Optimizer</td
447​><td>0</td
448​><td>3</td
449​><td>1</td
450​></tr
451​><tr><td>EmptyLabelServiceOptimizer</td
452​><td>Optimizer</td
453​><td>0</td
454​><td>6</td
455​><td>1</td
456​></tr
457​><tr><td>RangeCount</td
458​><td>Range Count</td
459​><td>3</td
460​><td>3076</td
461​><td>7</td
462​></tr
463​></table
464​><h2>Optimized AST</h2
465​><pre>
466​PREFIX schema: &lt;http:&#47;&#47;schema.org&#47;&gt;
467​PREFIX rdf: &lt;http:&#47;&#47;www.w3.org&#47;1999&#47;02&#47;22-rdf-syntax-ns#&gt;
468​PREFIX rdfs: &lt;http:&#47;&#47;www.w3.org&#47;2000&#47;01&#47;rdf-schema#&gt;
469​PREFIX sesame: &lt;http:&#47;&#47;www.openrdf.org&#47;schema&#47;sesame#&gt;
470​PREFIX owl: &lt;http:&#47;&#47;www.w3.org&#47;2002&#47;07&#47;owl#&gt;
471​PREFIX xsd: &lt;http:&#47;&#47;www.w3.org&#47;2001&#47;XMLSchema#&gt;
472​PREFIX fn: &lt;http:&#47;&#47;www.w3.org&#47;2005&#47;xpath-functions#&gt;
473​PREFIX foaf: &lt;http:&#47;&#47;xmlns.com&#47;foaf&#47;0.1&#47;&gt;
474​PREFIX dc: &lt;http:&#47;&#47;purl.org&#47;dc&#47;elements&#47;1.1&#47;&gt;
475​PREFIX hint: &lt;http:&#47;&#47;www.bigdata.com&#47;queryHints#&gt;
476​PREFIX bd: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf#&gt;
477​PREFIX bds: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;search#&gt;
478​PREFIX psn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value-normalized&#47;&gt;
479​PREFIX pqn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value-normalized&#47;&gt;
480​PREFIX prn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value-normalized&#47;&gt;
481​PREFIX mwapi: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#API&#47;&gt;
482​PREFIX gas: &lt;http:&#47;&#47;www.bigdata.com&#47;rdf&#47;gas#&gt;
483​PREFIX wdt: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct&#47;&gt;
484​PREFIX wdtn: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;direct-normalized&#47;&gt;
485​PREFIX psv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;value&#47;&gt;
486​PREFIX ps: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;statement&#47;&gt;
487​PREFIX pqv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;value&#47;&gt;
488​PREFIX pq: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;qualifier&#47;&gt;
489​PREFIX prv: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;value&#47;&gt;
490​PREFIX pr: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;reference&#47;&gt;
491​PREFIX wdno: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;novalue&#47;&gt;
492​PREFIX p: &lt;http:&#47;&#47;www.wikidata.org&#47;prop&#47;&gt;
493​PREFIX wikibase: &lt;http:&#47;&#47;wikiba.se&#47;ontology#&gt;
494​PREFIX wd: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;&gt;
495​PREFIX wds: &lt;http:&#47;&#47;www.wikidata.org&#47;entity&#47;statement&#47;&gt;
496​PREFIX wdv: &lt;http:&#47;&#47;www.wikidata.org&#47;value&#47;&gt;
497​PREFIX wdref: &lt;http:&#47;&#47;www.wikidata.org&#47;reference&#47;&gt;
498​PREFIX wdata: &lt;http:&#47;&#47;www.wikidata.org&#47;wiki&#47;Special:EntityData&#47;&gt;
499​PREFIX prov: &lt;http:&#47;&#47;www.w3.org&#47;ns&#47;prov#&gt;
500​PREFIX skos: &lt;http:&#47;&#47;www.w3.org&#47;2004&#47;02&#47;skos&#47;core#&gt;
501​PREFIX geo: &lt;http:&#47;&#47;www.opengis.net&#47;ont&#47;geosparql#&gt;
502​PREFIX geof: &lt;http:&#47;&#47;www.opengis.net&#47;def&#47;geosparql&#47;function&#47;&gt;
503​PREFIX mediawiki: &lt;https:&#47;&#47;www.mediawiki.org&#47;ontology#&gt;
504​QueryType: SELECT
505​includeInferred=true
506​timeout=60000
507​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) )
508​ JoinGroupNode {
509​ 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]
510​ AST2BOpBase.estimatedCardinality=661
511​ AST2BOpBase.originalIndex=POS
512​ 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]
513​ AST2BOpBase.estimatedCardinality=304519
514​ AST2BOpBase.originalIndex=POS
515​ QueryType: ASK
516​ SELECT VarNode(item) VarNode(-exists-1)[anonymous]
517​ JoinGroupNode {
518​ StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http:&#47;&#47;schema.org&#47;inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
519​ AST2BOpBase.estimatedCardinality=1923821
520​ AST2BOpBase.originalIndex=POS
521​ StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
522​ AST2BOpBase.estimatedCardinality=61377603
523​ AST2BOpBase.originalIndex=POS
524​ }
525​ @askVar=-exists-1
526​ FILTER( NotExistsNode(VarNode(-exists-1))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http:&#47;&#47;www.bigdata.com&#47;sparql-1.1-undefined-functionsnot-exists, graphPattern=
527​ JoinGroupNode {
528​ StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http:&#47;&#47;schema.org&#47;inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
529​ AST2BOpBase.estimatedCardinality=1923821
530​ AST2BOpBase.originalIndex=POS
531​ StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
532​ AST2BOpBase.estimatedCardinality=61377603
533​ AST2BOpBase.originalIndex=POS
534​ }, valueExpr=com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1))] )
535​ 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]
536​ AST2BOpBase.estimatedCardinality=624933
537​ AST2BOpBase.originalIndex=POS
538​ 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]
539​ AST2BOpBase.estimatedCardinality=4085615
540​ AST2BOpBase.originalIndex=POS
541​ StatementPatternNode(VarNode(sitelink), ConstantNode(Vocab(40)[http:&#47;&#47;schema.org&#47;about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
542​ AST2BOpBase.estimatedCardinality=61377603
543​ AST2BOpBase.originalIndex=POS
544​ }
545​group by ( VarNode(item) AS VarNode(item) ) ( VarNode(itemLabel) AS VarNode(itemLabel) )
546​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]]
547​slice(limit=100)
548
549​with static (exogeneous) bindings defined as follows:
550​{
551​ { }
552​}
553​</pre
554​><h2>Query Plan</h2
555​><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]
556​ com.bigdata.bop.solutions.ProjectionOp[23](MemoryGroupByOp[22])[ BOp.bopId=23, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, JoinAnnotations.select=[item, count]]
557​ 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])]}]
558​ 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]
559​ com.bigdata.bop.solutions.DropOp[20](PipelineJoin[19])[ BOp.bopId=20, DropOp.dropVars=[-exists-1]]
560​ 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]]]
561​ 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]]]
562​ 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]]]
563​ 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)))]
564​ 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]
565​ SPARQL-QUERY: queryStr=PREFIX schema: <http://schema.org/>
566
567​SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
568​ ?item wdt:P31 wd:Q5.
569​ ?item wdt:P21 wd:Q6581072.
570​ ?item (wdt:P1344/wdt:P31) wd:Q1344963 .
571​ ?sitelink schema:about ?item.
572​ FILTER(NOT EXISTS {
573​ ?wfr schema:about ?item.
574​ ?wfr schema:inLanguage "it".
575​ })
576​}
577​GROUP BY ?item ?itemLabel
578​HAVING (?count > 0)
579​LIMIT 100
580​java.util.concurrent.TimeoutException
581​ at java.util.concurrent.FutureTask.get(FutureTask.java:205)
582​ at com.bigdata.rdf.sail.webapp.BigdataServlet.submitApiTask(BigdataServlet.java:293)
583​ at com.bigdata.rdf.sail.webapp.QueryServlet.doSparqlQuery(QueryServlet.java:654)
584​ at com.bigdata.rdf.sail.webapp.QueryServlet.doGet(QueryServlet.java:288)
585​ at com.bigdata.rdf.sail.webapp.RESTServlet.doGet(RESTServlet.java:240)
586​ at com.bigdata.rdf.sail.webapp.MultiTenancyServlet.doGet(MultiTenancyServlet.java:271)
587​ at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
588​ at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
589​ at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:769)
590​ at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1667)
591​ at org.wikidata.query.rdf.blazegraph.throttling.ThrottlingFilter.doFilter(ThrottlingFilter.java:304)
592​ at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
593​ at ch.qos.logback.classic.helpers.MDCInsertingServletFilter.doFilter(MDCInsertingServletFilter.java:49)
594​ at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
595​ at org.wikidata.query.rdf.blazegraph.filters.ClientIPFilter.doFilter(ClientIPFilter.java:43)
596​ at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
597​ at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
598​ at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
599​ at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
600​ at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
601​ at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
602​ at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
603​ at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
604​ at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
605​ at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
606​ at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
607​ at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
608​ at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
609​ at org.eclipse.jetty.server.Server.handle(Server.java:497)
610​ at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
611​ at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
612​ at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
613​ at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:610)
614​ at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:539)
615​ 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