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=30
 |sort=
 |order=asc
 |mainlabel=page
}}

Results 31 – 80 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.1151",
    "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
30

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		86		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>.
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
188.166.100.220	25 February 2018 10:49:30
188.212.15.4	17 March 2019 03:46:47
193.201.224.201	8 January 2018 11:20:45
194.60.255.241	5 May 2019 21:25:59
195.184.208.221	4 January 2018 21:02:54
2.95.77.217	25 January 2018 18:23:27
2009 Midwinter dip	20 June 2009 22:47:37
213.166.70.62	17 March 2019 11:48:30
213.166.71.35	17 February 2019 05:31:30
23JR	30 July 2018 22:29:16
31.130.10.130	7 November 2017 19:57:51
31.130.18.58	23 October 2017 18:53:15
31.130.2.207	25 October 2017 16:10:42
31.184.238.101	16 December 2018 15:14:53
31.184.238.248	28 February 2019 11:45:41
31.184.238.92	23 September 2018 05:05:30
360 Discovery	5 December 2007 01:48:00
37.115.124.97	11 September 2018 15:35:45
37.115.125.68	28 November 2017 14:15:17
37.115.145.116	16 October 2018 21:17:26
37.115.155.222	26 October 2017 21:59:59
37.143.132.80	19 April 2019 19:51:01
37.9.44.215	11 May 2018 06:45:08
39.137.69.7	25 February 2019 17:01:21
	14 December 2008 02:11:53
46.118.120.230	22 May 2018 12:38:09
46.119.114.237	7 October 2018 07:28:50
46.119.125.241	7 June 2018 13:24:22
46.161.9.14	18 April 2018 19:00:39
46.161.9.23	2 July 2018 06:18:21

Semantic search

Query log

Navigation menu

Search