Semantic search
From Thesaurus Inscriptionum Raeticarum
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=966)
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=966)
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 | 155 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | tirwebspas52.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneType | Meaning | Language | Case | Tense | Morpheme | |
---|---|---|---|---|---|---|
)armatan | unknown | unknown | unknown | |||
)auþile | proper noun | unknown | Raetic | pertinentive | -le | |
)ke | verb | 'X-ed' | Raetic | past | -ke | |
)le | noun | 'by/of ?' | Raetic | pertinentive | -le | |
)na | proper noun | 'daughter of' (?) | Raetic | -na | ||
)nu | proper noun | 'son of' | Raetic | -nu | ||
)nuale | proper noun | 'by/of son of ?' | Raetic | pertinentive | -nu -le | |
)s | noun | 'of ?' | Raetic | genitive | -s(i) | |
)si | noun | 'by/of ?' | Raetic | pertinentive | -si | |
-ka | conjunction | 'and' | Raetic | |||
asua | proper noun | unknown | Raetic | genitive | ||
avaśuerasi | noun | 'by/for the Avaśu*' | Raetic | pertinentive | -si -r(a) | |
azile | proper noun | unknown | Raetic | pertinentive | -le | |
aθare | unknown | unknown | unknown | |||
aθivnuale | proper noun | 'of/by the son of Aθiv- (Aθiu-)' | Raetic | pertinentive | -nu -le | |
aχvil | noun | 'gift' (?) | Raetic | nominative | ||
eluku | noun | 'sacrificed' | Raetic | -ke -u | ||
enikes | proper noun | 'of Enike' | Raetic | genitive | -s(i) | |
enθus | proper noun | 'of (the community of) Enθu*' | Raetic | genitive | -s(i) | |
erikian | unknown | unknown | Raetic | |||
esimnesi | proper noun | 'of/by Esimne' | Raetic | pertinentive | -si | |
esiumninu | proper noun | 'son of Esimne/Esumne' | Raetic | nominative | -nu | |
esiunne | proper noun | 'Esimne / Esumne' | Raetic | nominative | ||
esminu | proper noun | 'son/daughter of Esimne' | Raetic | nominative | -nu | |
esumnesi | proper noun | 'of/by Esumne' | Raetic | pertinentive | -si | |
esθua | proper noun | 'Esθu(a)' (?) | Raetic | |||
esθuale | proper noun | 'of/by Esθu(a)*' (?) | Raetic | pertinentive | -le | |
eθunnuale | proper noun | unknown | Raetic | pertinentive | -nu -le | |
helanu | proper noun | 'son of Hela*' | Raetic | nominative | -nu | |
iai | unknown | unknown | unknown | |||
iθθi | unknown | unknown | unknown | |||
kaial | unknown | unknown | Raetic | |||
kalitis | unknown | unknown | Raetic | |||
kaniśnu | proper noun | son of Kaniś- | Raetic | nominative | -nu | |
kapaśunu | proper noun | 'son of Kapaśu' | Raetic | nominative | -nu | |
kara | proper noun | 'Kara' | Raetic | nominative | ||
karataśna | proper noun | 'son/daughter of Karapaś*' | Raetic | nominative | -na | |
kari | proper noun | 'Kari' | Raetic | nominative | ||
kastriesi | proper noun | unknown | Raetic | pertinentive | -si | |
kaszrinuale | proper noun | unknown | Raetic | pertinentive | -nu -le | |
kativates | unknown | unknown | Raetic | |||
kaθiave | proper noun | 'Kaθiave' | Raetic | nominative | ||
ker | unknown | unknown | Raetic | |||
ketanuvale | proper noun | 'of/by the son of Keta*' | Raetic | pertinentive | -nu -le | |
kleimunθeis | noun | 'from/of/by it/him which/who is ?' | Raetic | ablative | ||
klevie | proper noun | 'Klevie' | Raetic | nominative | ||
klu?θurus | proper noun | 'of Klunθuru' | Raetic | genitive | -s(i) | |
knuse | proper noun | 'Knuse' | Raetic | nominative | ||
kuninasi | proper noun | 'of/by the son/daughter of Kuni' | Raetic | pertinentive | -na -si | |
kusen | unknown | unknown | Raetic | unknown |