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: [[Has religion::+]]
 |?Has religion
 |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": "[[Has religion::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0153",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Has religion::+]]

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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1954')
  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,s_id_2,s_id_3	p_id	4	const	1448	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	Has religion
Maurice Greenberg	Jew
David Greenhalgh	Christian
Justine Greening	Church of England
Nick Greiner	Jew
Ronald Grierson	Jew
Dominic Grieve	Church of England
Aline Griffith	Roman Catholicism
Hanna Gronkiewicz-Waltz	Roman Catholicism
Alfred Grosser	Atheist
Marc Grossman	Jew
Hamid Gul	Islam
António Guterres	Roman Catholicism
Camille Gutt	Jew
Fethullah Gülen	Islam
Richard Haass	Jew
Philip Habib	Catholic
Otto von Habsburg	Roman Catholicism
Juvenal Habyarimana	Roman Catholicism
Ken Hackett	Roman Catholicism
Chuck Hagel	Episcopal Church
William Hague	Church of England
James Hahn	Churches of Christ
Alexander Haig	Roman Catholicism
H. R. Haldeman	Christian Science
J. Evetts Haley	Methodist Episcopal South
Robert Halfon	Jew
Tony Hall	Church of England
Margaret Hamburg	Jew
George Hamilton-Gordon	Church of England
Dag Hammarskjöld	Lutheranism
Armand Hammer	Jew
Philip Hammond	Church of England
John Hamre	Lutheranism
Greg Hands	Romanian Orthodoxy
Hani Hanjour	Sunni Islam
Daniel Hannan	Christianity
Robert Hanssen	Roman Catholicism
Stephan Harbarth	Catholic
Warren Harding	Baptist
Rafic Hariri	Sunni Muslim
Harriet Harman	Christianity
Stephen Harper	Evangelicalism
Benjamin Harrison	Presbyterianism
Gary Hart	Nazarene
Poul Hartling	Lutheranism
Dennis Hastert	Methodism
Yukio Hatoyama	Baptist
Jerome Hauer	Jew
Helmut Haussmann	Protestantism
Edward Heath	Church of England

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools

Misc