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: [[Creation date::+]]
 |?Creation date=date
 |format=table
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |mainlabel=page
}}

Results 1 – 50 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Creation date::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1424",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Creation date::+]]

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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_cdat` AS t1 ON t0.smw_id=t1.s_id
WHERE
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
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t0	index	PRIMARY, smw_id, smw_iw, smw_iw_2	smw_sort	262		56		Using where; Using temporary
1	SIMPLE	t1	ref	s_id	s_id	4	waihekepediawiki.t0.smw_id	1		Using index; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:1

Errors and Warnings

None

page	date"Creation date" is a predefined property that corresponds to the date of the first revision of a subject and is provided by <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>.
10 th anniversary	26 September 2017 10:52:31
103.253.169.115	20 January 2019 18:17:10
104.156.206.41	13 December 2017 14:35:14
109.194.99.101	9 August 2018 02:11:55
110.232.78.8	17 March 2019 09:22:00
114.6.192.186	8 January 2019 22:56:54
115.78.235.164	15 March 2019 05:39:46
118.243.93.219	27 March 2019 02:24:02
134.249.208.227	13 October 2018 22:10:00
134.249.209.52	12 September 2018 15:05:54
134.249.49.198	1 June 2018 11:33:31
140.227.202.8	7 January 2019 16:39:05
144.76.132.65	27 April 2018 15:52:27
144.76.132.66	28 April 2018 11:24:41
144.76.132.67	2 May 2018 08:57:36
144.76.132.71	11 May 2018 04:56:08
144.76.132.72	8 December 2017 08:50:34
144.76.132.73	13 December 2017 16:22:31
144.76.132.74	16 December 2017 10:39:48
144.76.132.75	28 May 2018 16:06:40
144.76.132.76	21 December 2017 01:10:59
144.76.132.77	21 April 2018 00:02:05
144.76.132.78	5 February 2018 12:43:39
144.76.208.99	13 December 2017 00:19:19
146.185.176.230	14 April 2019 19:48:45
146.185.223.202	1 February 2018 13:25:41
146.88.194.86	3 December 2017 22:27:07
148.251.247.20	7 March 2019 04:15:39
151.106.25.134	20 September 2018 15:59:54
163.44.169.45	1 June 2018 13:40:59
173.52.67.199	7 May 2019 00:49:47
176.103.214.95	18 November 2017 03:20:51
176.105.104.102	8 December 2017 00:08:15
176.126.63.104	19 April 2019 06:44:18
176.57.71.26	4 March 2019 09:10:44
177.125.192.97	8 April 2019 12:05:09
177.38.1.64	9 April 2019 10:03:27
177.87.180.66	10 March 2019 15:21:50
178.137.130.155	13 November 2017 15:05:03
178.137.84.20	28 January 2018 02:54:17
178.159.37.112	29 March 2018 07:11:25
178.159.37.49	1 July 2018 20:13:16
178.213.187.191	31 March 2019 00:47:47
178.213.187.244	16 May 2019 05:35:58
178.213.187.53	7 March 2019 02:20:30
178.213.190.251	21 February 2019 13:14:17
182.160.124.26	30 March 2019 01:40:05
185.101.70.44	22 March 2019 07:43:35
188.162.195.191	27 February 2018 08:46:08
188.162.37.7	26 February 2018 08:08:50

Semantic search

Query log

Navigation menu

Search