Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Is not stub::+]]
 |?Is not stub
 |format=table
 |limit=50
 |offset=500
 |sort=
 |order=asc
 |mainlabel=Page&nbsp;name
 |class=sortable wikitable smwtable mw-collapsible mw-collapsed
}}

Results 501 – 550 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Is not stub::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1572",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Is not stub::+]]

SQL Query

SELECT DISTINCT
t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`mw_smw_object_ids` AS t0
INNER JOIN
`mw_smw_di_bool` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='667817')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
500

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	index	s_id	s_id	8		29332	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	wikispooks.t1.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:1

Errors and Warnings

None

Page name	Is not stub
2003 El Nogal Club bombing	true
2003 Iraq War	true
2003 UK-US extradition treaty	true
2004	true
2004 Madrid train bombings	true
2005	true
2005 London bombings	true
2006	true
2006 Counter Terror World Summit	true
2006 Mexico DC-9 drug bust	true
2006 transatlantic aircraft plot	true
2007	true
2007 Yucatan Gulfstream drug crash	true
2008	true
2008 Counter-Terrorism advertising campaign	true
2008 Financial Crisis	true
2008 Mumbai attacks	true
2009	true
2009 Queen's Day Attack	true
2010	true
2010 Cumbria shootings	true
2010 Gaza Freedom Flotilla	true
2010 United States diplomatic cables leak	true
2010 United States diplomatic cables leak/Middle East	true
2010s	true
2010s/Assassinations	true
2010s/Murders	true
2011	true
2011 Alexandria bombing	true
2011 Attacks on Libya	true
2011 England riots	true
2011 Norway attacks	true
2011 Syrian Insurgency	true
2012	true
2012 Benghazi attack	true
2013	true
2014	true
2014 Australia turboprop drug bust	true
2014 Clacton by-election	true
2014 Kunming Attack	true
2014 Norway terror threat	true
2014 Ukraine coup	true
2014 Ukraine coup/ATO map 16 JUL 2014	true
2014 Ukraine coup/Civil war	true
2014 Ukraine coup/Cultural genocide	true
2014 Ukraine coup/Geneva agreement	true
2014 Ukraine coup/Maidan snipers	true
2014 Ukraine coup/Odessa massacre	true
2014 Winter Olympics	true
2015	true

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

Misc