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: [[Display born on::+]]
 |?Display born on
 |format=table
 |limit=50
 |offset=1000
 |sort=
 |order=asc
 |mainlabel=Page&nbsp;name
 |class=sortable wikitable smwtable mw-collapsible mw-collapsed
}}

Results 1,001 – 1,050 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Display born on::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0723",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Display born 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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='802604')
  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
1000

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	s_id,p_id,s_id_2	p_id	4	const	19442	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	Display born on
Hazel Blears	14 May 1956
Klaus Blech	14 August 1928
Karl Blessing	5 February 1900
Alan Blinder	14 October 1945
Svein Blindheim	29 August 1916
Tony Blinken	16 April 1962
Hans Blix	28 June 1928
Christoph Blocher	11 October 1940
Stef Blok	10 December 1964
Hans-Henning Blomeyer	28 July 1950
Godfrey Bloom	22 November 1949
Michael Bloomberg	14 February 1942
Janet Bloomfield	10 October 1953
Louis Bloomfield	8 August 1906
Louise Blouin	15 October 1958
Rupert Blue	30 March 1868
Eberhard Blum	28 April 1919
Robert Blum	1911
William Blum	6 March 1933
Isadore Blumenfield	8 September 1900
Mandy Blumenthal	1965
Max Blumenthal	18 December 1977
Sidney Blumenthal	6 November 1948
W. Michael Blumenthal	3 January 1926
Bill Blunden	3 December 1969
David Blunkett	6 June 1947
Anthony Blunt	26 September 1907
Crispin Blunt	15 July 1960
Roy Blunt	10 January 1950
Antti Blåfield	22 June 1953
Helen Boaden	1 March 1956
Tom Boardman	12 January 1919
James Boasberg	20 February 1963
Paul Boateng	14 June 1951
Randall Bock	1956
Peter Bod	28 July 1951
Hans Boden	28 July 1893
Barbara Bodine	28 August 1948
Nicholas Bodington	6 June 1904
Samuel Bodman	26 November 1938
Prodromos Bodosakis-Athanasiadis	1891
John Boehner	17 November 1949
Dana Boente	7 February 1954
Albrecht Freiherr von Boeselager	4 October 1949
Ivan Boesky	6 March 1937
Paul Vanden Boeynants	22 May 1919
George Bogdanich	13 November 1948
Hale Boggs	15 February 1914
Sabine Boghici	1976
Andrew Bogut	28 November 1984

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

Misc