Semantic search
From Lexicon Leponticum
Jump to navigationJump to search
Debug output SQLStore
ASK Query
[[Category:Word]]
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
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1170)
AND 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
500
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
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1170)
AND 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
500
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 653 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | lexlepwebu54.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneWord | Word type | Translation | Status | Language |
---|---|---|---|---|
sipiu | proper noun | 'Sipiu' | unknown | |
siteś | noun | "the seats" | Lepontic | |
siuilios | proper noun | 'Siuilios' | dubious | Celtic |
siś | unclear | unknown | Celtic | |
sla( | undeterminable | unknown | unknown | |
slaniai | proper noun | 'for Slania' | Lepontic | |
snaśiouitos | proper noun | 'Snaśiouitos' | probable | Celtic |
sola | proper noun | "Sola" | Cisalpine Gaulish | |
solos | proper noun | 'Solos' | Celtic | |
spt | undeterminable | unknown, prob. an abbreviation? | unknown | |
spuris | proper noun | 'of Spuris' (?) | unknown | |
stu( | undeterminable | unknown | unknown | |
suloikei | proper noun | "to Suloigis" | Lepontic | |
sunalei | proper noun | 'for Sunalis' | uncertain | Celtic |
sur | prob. proper noun | abbreviation (?) | Celtic | |
sura | proper noun | "Sura" (name) | unknown | |
surica | proper noun | "Surika" | Lepontic | |
sutiuakos | proper noun | "Sutiuakos" | Celtic | |
ta | unclear | - | Lepontic | |
ta( | undeterminable | unknown | unknown | |
tai | proper noun | 'of Taios' (?) | Celtic | |
tak | undeterminable | maybe an abbreviation? | dubious | unknown |
taka | proper noun | - | Celtic | |
takos | noun | 1) 'giudice, decree', 2) 'peace' or 3) 'good' | Cisalpine Gaulish | |
talu | proper noun | 'Talu' (?) | Celtic | |
tanatani | unclear | unknown | Celtic | |
tanotaliknoi | proper noun | 'sons of Dannotalos' | Cisalpine Gaulish | |
tanotalos | proper noun | "Dannotalos" | Cisalpine Gaulish | |
tau | prob. proper noun | abbreviation (?) | Celtic | |
te( | undeterminable | unknown | unknown | |
tekialui | proper noun | 'for the son of Tekios' | Celtic | |
telialui | proper noun | 'for the son of Telios' | probable | Celtic |
terialui | proper noun | 'for the son of Terios' | unlikely | Celtic |
teromui | proper noun | 'for Teromos' | Celtic | |
tetu | verb | "he/she gave, dedicated" | Lepontic | |
tetumus | proper noun | "Tetumus" | Celtic | |
teu | proper noun | 'Teu' | Lepontic | |
teua | unclear | unknown | Celtic | |
teuoχtom | noun | - | Cisalpine Gaulish | |
teuoχtoni(o)n | noun | 'gods and men' | Cisalpine Gaulish | |
ti | unclear | unknown | unknown | |
tikou | proper noun | 'Tikou' (?) | unlikely | Celtic |
timirios | proper noun | 'Timirios' | Celtic | |
tiou | proper noun | 'Tiou' or abbreviation (?) | Celtic | |
tisiui | proper noun | 'for Tisios' | Lepontic | |
to | prob. proper noun | abbreviation (?) | Celtic | |
tokra | proper noun | "Tokra" | Celtic | |
tokua | proper noun | "Tokua" | Celtic | |
tonoiso | proper noun | 'of/from Tonos' | Celtic | |
tou | undeterminable | abbreviation (?) | Celtic |