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:Inscription]] [[sortdate::≥-120]] [[sortdate::≤-70.0001]] [[direction::sinistroverse]] [[sortdate::!0]]
 |?text plain=Text
 |?language=Language
 |format=table
 |limit=50
 |offset=0
 |sort=sortform
 |order=asc
 |mainlabel=
 |searchlabel=64
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Inscription]] [[sortdate::\u2265-120]] [[sortdate::\u2264-70.0001]] [[direction::sinistroverse]] [[sortdate::!0]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0267",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Inscription]] [[sortdate::≥-120]] [[sortdate::≤-70.0001]] [[direction::sinistroverse]] [[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, t13.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_blob` AS t8 ON t2.s_id=t8.s_id
INNER JOIN
`lexlep_smw_di_number` AS t10 ON t2.s_id=t10.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`lexlep_smw_di_blob` AS t13 ON t0.smw_id=t13.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_hash='sinistroverse') AND t8.p_id=641)
   AND (
   (t10.o_sortkey!='0') AND t10.p_id=1199186)
  )
   AND (t13.p_id=1199080)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t13.o_hash ASC
LIMIT
55
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	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	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	t10	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_hash, s_id_2	s_id	8	lexlepwebu54.t2.s_id, const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	lexlepwebu54.t2.s_id	1	Using where
1	SIMPLE	t13	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) (1276).
SELECT s_id FROM `lexlep_smw_fpt_subc` WHERE o_id=1276 LIMIT 1

Query Metrics

Query-Size:9
Query-Depth:1

Errors and Warnings

None

	Text	Language
AO·1.1	ap	Celtic
AO·1.2	]ạẹ?[	unknown
AO·2	]?ele[	unknown
BG·9	ru	unknown
BG·24	art	Celtic
BG·25	art	Celtic
BG·49	piuo	Celtic
BS·10	ka	unknown
BS·14	aru??	unknown
BS·15	????tios	Celtic
BS·18	pisa	unknown
BS·19	uasi	unknown
BS·20	mi[t]a	unknown
BS·23	uịru	unknown
CO·62	zvośoris	Lepontic
CO·78	at	unknown
NM·4	pirakos	Celtic
NM·7	toutiopouos	Celtic
NM·8	natoris	unknown
NO·6	sura	unknown
NO·24	sutiuakos	unknown
NO·30	piraki	Celtic
PV·1	esopnos kepi	Celtic
TI·5	arimai	Celtic
TI·11	rupelos	Celtic
TI·13	pirạụịχeś	Celtic
TI·21	ateratos	Celtic
TI·22	kr	unknown
TI·23	setupokios	Celtic
TI·24	śium	unknown
TI·25	anteśilu	Celtic
TI·40	komoneos/uarsileos	Celtic
TI·48.1	iap??ị	Celtic
VA·11	at?	unknown
VA·19	uini	Celtic
VA·20	ṣnaśịọụịṭoṣ §	Celtic
VB·1	ṣasamos	Celtic
VB·2	oletuamaśilu§	Celtic
VB·3.1	latumarui:sapsutai:pe:uinom:natom	Celtic
VB·3.2	mou:ea	unknown
VB·3.3	lutou:iiii	unknown
VB·3.4	tu??	unknown
VB·3.5	enu	unknown
VB·4	atios	Celtic
VB·7	kri	Celtic
VR·1	komono[s	unknown
VR·5	kulsius	unknown
VR·13	kulopouị	unknown
VR·14	keleśu	Lepontic
VR·15	kośio	Lepontic

Semantic search

Query log

Navigation menu

Page actions

Page actions

Personal tools

Contents

Search

Navigation

Maintenance

Tools