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: [[Died on::+]]
 |?Died on
 |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": "[[Died on::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0318",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Died on::+]]

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_time` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='2398201')
  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	ref	s_id,p_id,p_id_2,s_id_2	p_id	4	const	8424	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	Died on
Charles-Victor Bracht	7 March 1978
Philip Bradbourn	19 December 2014
John Brademas	11 July 2016
Thomas W. Braden	3 April 2009
Robert Bradford	14 November 1981
Ben Bradlee	21 October 2014
Omar Bradley	8 April 1981
Enrico Braggiotti	31 October 2019
Bernard Braine	5 January 2000
Edwin Bramall	12 November 2019
Robert Brand	23 August 1963
Thomas Brand	17 October 1965
Karl Brandt	8 July 1975
Willy Brandt	8 October 1992
Thomas Elmer Braniff	10 January 1954
Hubert Brasier	12 October 1981
Thomas Brassey	23 February 1918
Trygve Bratteli	20 November 1984
Max Brauer	2 February 1973
Andrew Breitbart	1 March 2012
Tor Brekke	6 March 2009
Richard Brenneke	23 July 2015
Charles Henry Brent	27 March 1929
Albert Breton	2016
Willy Bretscher	1992
Reginald Brett	22 January 1930
Philippe Brewaeys	2 May 2016
Kingman Brewster	8 November 1988
Leonid Brezhnev	10 November 1982
Aristide Briand	7 March 1932
Maurice Bridgeman	18 June 1980
Edward Bridges	27 August 1969
Asa Briggs	15 March 2016
Charles A. Briggs	4 November 2015
Harvey Bright	11 December 2004
Thomas Brimelow	2 August 1995
Andrew Brimmer	7 October 2012
Poul Brink	23 October 2002
John Brinkerhoff	18 December 2020
Norah Briscoe	1996
Desmond Bristow	September 2000
Leon Brittan	21 January 2015
Ed Broadbent	11 January 2024
Miguel d'Escoto Brockmann	8 June 2017
Tassilo Broesigke	9 September 2003
Erik Brofoss	7 May 1979
Gerardo Broggini	29 October 2018
Jean de Broglie	24 December 1976
James Brokenshire	7 October 2021
Edgar Bronfman	21 December 2013

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

Misc