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:Object]] [[sortdate::≥-120]] [[sortdate::≤-70.0001]] [[sortdate::!0]]
 |?sortdate
 |format=table
 |limit=100
 |offset=0
 |sort=sortform
 |order=asc
 |mainlabel=Object
 |searchlabel=show&nbsp;list
 |default=&nbsp;
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Object]] [[sortdate::\u2265-120]] [[sortdate::\u2264-70.0001]] [[sortdate::!0]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0210",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Object]] [[sortdate::≥-120]] [[sortdate::≤-70.0001]] [[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_t3` AS t3 ON t2.o_id=t3.id
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
(
   ((t4.o_sortkey>='-120') AND t4.p_id=1199186)
   AND (
   (t6.o_sortkey<='-70.0001') 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
105
OFFSET
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t3	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	lexlepwebu54.t3.id	71	Using index
1	SIMPLE	t4	ref	s_id, p_id, o_sortkey, p_id_2, s_id_2	s_id_2	8	lexlepwebu54.t2.s_id, const	1	Using where; Using index
1	SIMPLE	t6	ref	s_id, p_id, o_sortkey, p_id_2, s_id_2	s_id_2	8	lexlepwebu54.t2.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.t2.s_id, const	1	Using where; Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	lexlepwebu54.t2.s_id	1	Using where
1	SIMPLE	t11	ref	s_id, p_id, s_id_2	s_id	8	lexlepwebu54.t2.s_id, const	1

Auxilliary Tables

Temporary table t3
Recursively computed hierarchy for element(s) (1343).
SELECT s_id FROM `lexlep_smw_fpt_subc` WHERE o_id=1343 LIMIT 1

Query Metrics

Query-Size:7
Query-Depth:1

Errors and Warnings

None

Object	sortdate
AO·1 Aosta	-100
AO·2 Aosta	-100
BG·9 Bergamo	-100
BG·12 Bergamo	-75
BG·24 Fornovo San Giovanni	-100
BG·25 Fornovo San Giovanni	-100
BG·49 Caravaggio	-100
BI·8 Cerrione	-80
BS·7 Brescia	-75
BS·8 Brescia	-90
BS·9 Gottolengo	-100
BS·10 Gottolengo	-100
BS·11 Gottolengo	-100
BS·14 Gottolengo	-75
BS·15 Gottolengo	-100
BS·17 Remedello	-100
BS·18 Remedello	-75
BS·19 Remedello	-75
BS·20 Remedello	-75
BS·23 Urago d'Oglio	-100
CO·1 Gravedona	-100
CO·62 Casate	-100
CO·64 Casate	-75
CO·78 Cantù	-75
GR·1 Mesocco	-100
MI·7 Cernusco sul Naviglio	-100
MI·13 Mezzano	-75
MI·23 Milano	-100
NM·4	-120
NM·5	-80
NM·7	-101
NM·8	-120
NO·6 Oleggio	-112
NO·8 Oleggio	-110
NO·9 Oleggio	-90
NO·10 Oleggio	-75
NO·13 Oleggio	-75
NO·14 Oleggio	-80
NO·16 Oleggio	-87
NO·20 Cureggio	-100
NO·21 San Bernardino di Briona	-100
NO·23 Cerano	-75
NO·24 Cerano	-75
NO·30 Dormelletto	-100
PG·1 Todi	-75
PV·1 Garlasco	-110
PV·5 Zerbo	-100
TI·5 Giubiasco	-87
TI·9 Giubiasco	-90
TI·11 Giubiasco	-100
TI·13 Giubiasco	-75
TI·17 Giubiasco	-75
TI·21 Locarno	-75
TI·22 Locarno	-75
TI·23 Locarno	-75
TI·24 Locarno	-75
TI·25 Locarno	-75
TI·40 Stabio	-100
TI·41 Stabio	-100
TI·48 Giubiasco	-112
TI·50 Giubiasco	-75
UD·1 Verzegnis	-100
VA·7 Somma Lombardo	-75
VA·8 Somma Lombardo	-75
VA·9 Somma Lombardo	-75
VA·10 Somma Lombardo	-75
VA·11 Somma Lombardo	-75
VA·12 Arsago Seprio	-75
VA·18 Arsago Seprio	-100
VA·19 Arsago Seprio	-75
VA·20 Arsago Seprio	-75
VA·21 Arsago Seprio	-75
VA·22 Arsago Seprio	-75
VA·23 Arsago Seprio	-75
VA·24 Arsago Seprio	-75
VA·27 Arsago Seprio	-75
VA·28 Samarate	-110
VA·29 Gallarate	-100
VB·1 Ornavasso	-75
VB·2 Ornavasso	-110
VB·3 Ornavasso	-100
VB·4 Ornavasso	-90
VB·5 Ornavasso	-90
VB·6 Ornavasso	-75
VB·7 Ornavasso	-100
VB·9 Ornavasso	-115
VB·10 Ornavasso	-115
VB·20 Gravellona Toce	-75
VB·26 Stresa	-80
VB·27 Stresa	-80
VB·28 Stresa	-80
VB·30 Stresa	-75
VR·1 Nogarole Rocca	-100
VR·2 Valeggio sul Mincio	-100
VR·3 Valeggio sul Mincio	-100
VR·4 Valeggio sul Mincio	-100
VR·5 Valeggio sul Mincio	-75
VR·8 Santa Maria di Zevio	-90
VR·13 Santa Maria di Zevio	-100
VR·14 Isola Rizza	-100

Semantic search

Query log

Navigation menu

Page actions

Page actions

Personal tools

Contents

Search

Navigation

Maintenance

Tools