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: [[Category:Reference]] [[sortdate::≥2010]] [[sortdate::≤2019.9999]] [[sortdate::!0]]
 |?sortdate
 |format=table
 |limit=50
 |offset=0
 |sort=sortform
 |order=asc
 |mainlabel=Reference
 |searchlabel=show&nbsp;list
 |default=&nbsp;
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Reference]] [[sortdate::\u22652010]] [[sortdate::\u22642019.9999]] [[sortdate::!0]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0154",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Reference]] [[sortdate::≥2010]] [[sortdate::≤2019.9999]] [[sortdate::!0]]

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, t11.o_hash
FROM
`lexlep_smw_object_ids` AS t0
INNER JOIN
(`lexlep_smw_fpt_inst` AS t2
INNER JOIN
`lexlep_smw_di_number` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`lexlep_smw_di_number` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
`lexlep_smw_di_number` AS t8 ON t2.s_id=t8.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`lexlep_smw_di_blob` AS t11 ON t0.smw_id=t11.s_id
WHERE
(t2.o_id=1313
   AND (
   (t4.o_sortkey>='2010') AND t4.p_id=1199186)
   AND (
   (t6.o_sortkey<='2019.9999') AND t6.p_id=1199186)
   AND (
   (t8.o_sortkey!='0') AND t8.p_id=1199186)
  )
   AND (t11.p_id=1199080)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t11.o_hash ASC
LIMIT
55
OFFSET
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t4	range	s_id, p_id, o_sortkey, p_id_2, s_id_2	p_id	13		241	Using index condition; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	9	lexlepwebu54.t4.s_id, const	1	Using index
1	SIMPLE	t6	ref	s_id, p_id, o_sortkey, p_id_2, s_id_2	s_id_2	8	lexlepwebu54.t4.s_id, const	1	Using where; Using index
1	SIMPLE	t8	ref	s_id, p_id, o_sortkey, p_id_2, s_id_2	s_id_2	8	lexlepwebu54.t4.s_id, const	1	Using where; Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	lexlepwebu54.t4.s_id	1	Using where
1	SIMPLE	t11	ref	s_id, p_id, s_id_2	s_id	8	lexlepwebu54.t4.s_id, const	1

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:7
Query-Depth:1

Errors and Warnings

None

Reference	sortdate
Ajello et al. 2010	2,010
Alvah Catt et al. 2019	2,019
Amann et al. 2019	2,019
Andenmatten & Paccolat 2012	2,012
Anreiter et al. 2012	2,012
Arslan 2017	2,017
Askedal & Nielsen 2015	2,015
Baglioni & Tribulato 2015	2,015
Balbo 2016	2,016
Bandelli 2017	2,017
Barral et al. 2014	2,014
Bats 2011	2,011
Beekes 2010	2,010
Bellomo & Gazzoli 2019	2,019
Biondani & Mazzeo Saracino 2017	2,017
Brecciaroli Taborelli 2011	2,011
Brecciaroli Taborelli 2011b	2,011
Busà & Gesuato 2015	2,015
Calvelli 2019	2,019
Cardani Vergani 2014	2,014
Cardani Vergani et al. 2011	2,011
Casini & Fossati 2013	2,013
Casini & Fossati 2013b	2,013
Casini & Fossati 2016	2,016
Casini & Motta 2011	2,011
Casini & Motta 2018	2,018
Casini & Motta 2019	2,019
Casini & Tizzoni 2015	2,015
Casini & Tizzoni 2015b	2,015
Casini et al. 2013	2,013
Casini et al. 2014	2,014
Casini et al. 2014b	2,014
Cavalieri Manasse & Cresci Marrone 2015	2,015
Cavalieri Manasse 2016	2,014
Ceresa Mori et al. 2011	2,010
Chiaramonte Treré et al. 2012	2,012
Colonna 2017	2,017
Cornelio et al. 2017	2,017
Cresci Marrone & Solinas 2011	2,011
Cresci Marrone & Solinas 2013	2,013
Cresci Marrone 2015	2,015
De Bernardo Stempel 2010	2,010
De Bernardo Stempel 2011	2,011
De Bernardo Stempel 2012	2,012
De Goede 2014	2,014
Delamarre 2010	2,010
Delamarre 2012	2,012
Delamarre 2017	2,017
Delamarre 2019	2,019
Delestrée & Meziane 2016	2,016

Semantic search

Query log

Navigation menu

Page actions

Page actions

Personal tools

Contents

Search

Navigation

Maintenance

Tools