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
0
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
0
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 |
---|---|---|---|---|
)??ipaitit( | undeterminable | unknown | unknown | |
)??paiei? | undeterminable | undeterminable | uncertain | unknown |
)?an | undeterminable | unknown | unknown | |
)?ele( | undeterminable | undeterminable | probable | unknown |
)?rkimu( | undeterminable | unknown | Lepontic | |
)?uka( | undeterminable | unknown | probable | unknown |
)ae?( | undeterminable | unknown | uncertain | unknown |
)ais( | undeterminable | unknown | unknown | |
)aki??ios | proper noun | '°ak??ios' | Celtic | |
)akle( | undeterminable | unknown | unknown | |
)akur( | undeterminable | unknown | Lepontic | |
)alui | proper noun | 'for the son of ...' | Celtic | |
)aniui | proper noun | 'for °anios' | Celtic | |
)apauatos | noun | unknown | Celtic | |
)arsu | proper noun | '°arsu' | Celtic | |
)auśi | prob. noun | undeterminable | Celtic | |
)ei( | undeterminable | unknown | unknown | |
)ena | prob. noun | undeterminable | Celtic | |
)eu | prob. noun | unknown | Celtic | |
)ias( | undeterminable | unknown | unknown | |
)iknos | proper noun | "son of (...)" | Cisalpine Gaulish | |
)ionios | proper noun | '(son) of °iu' | Celtic | |
)iponia | proper noun | ']iponia' | uncertain | Celtic |
)isoni | proper noun | 'for °isu' | Celtic | |
)iuka( | prob. proper noun | "(...)iuka"? | Celtic | |
)iunθanaχa | prob. proper noun | unknown | unknown | |
)kicrisi | proper noun | 'of Kikrisos' | unlikely | unknown |
)kionei | proper noun | 'for °kiu' or 'for °kionis' | Celtic | |
)kiφisi | proper noun | 'of Kibisos' | unlikely | Lepontic |
)m( | undeterminable | unknown | unknown | |
)mit( | undeterminable | unknown | unknown | |
)miu( | undeterminable | unknown | unknown | |
)n | undeterminable | unknown | unknown | |
)n?k??tesaso | noun | - | Cisalpine Gaulish | |
)nei | proper noun | undeterminable | erroneous | Celtic |
)ner( | undeterminable | unknown | unknown | |
)nerio?o( | undeterminable | unknown | probable | unknown |
)ni | proper noun | 'for °u' | Celtic | |
)nialui | proper noun | 'for the son of °nios' | Celtic | |
)ones | noun | undeterminable | unknown | |
)oni | proper noun | 'for °ū' | Celtic | |
)onis | noun | undeterminable | Celtic | |
)osik( | undeterminable | unknown | probable | unknown |
)otukios | proper noun | '(son) of °otuk(i)os' (?) | uncertain | Celtic |
)ouki?( | undeterminable | unknown | unknown | |
)pa( | undeterminable | unknown | unknown | |
)pat( | undeterminable | unknown | uncertain | unknown |
)pet( | undeterminable | unknown | uncertain | unknown |
)peuesa | proper noun | ')peuesa' | probable | Cisalpine Gaulish |
)piośa | prob. proper noun | unknown | dubious | Celtic |