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, t4.o_hash
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=966)
AND (t4.p_id=2586469)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
55
OFFSET
50
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, t4.o_hash
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=966)
AND (t4.p_id=2586469)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
55
OFFSET
50
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 | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2 | s_id | 8 | tirwebspas52.t1.s_id, const | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneType | Meaning | Language | Case | Tense | Morpheme | |
---|---|---|---|---|---|---|
nuþnuale | proper noun | 'of/by the son of Nuz*' | Raetic | pertinentive | -nu -le | |
azile | proper noun | unknown | Raetic | pertinentive | -le | |
metlainile | proper noun | 'by Metlaini' (?) | Raetic | pertinentive | -le | |
sletile | proper noun | 'of/by Sleti' | Raetic | pertinentive | -le | |
)auþile | proper noun | unknown | Raetic | pertinentive | -le | |
lumene | proper noun | 'Lumene' | Raetic | nominative | ||
þine | unknown | unknown | unknown | |||
piθam(n)e | proper noun | 'Piθam(n)e' | Raetic | nominative | ||
esiunne | proper noun | 'Esimne / Esumne' | Raetic | nominative | ||
aθare | unknown | unknown | unknown | |||
lavise | proper noun | 'Lavise' | Raetic | nominative | ||
knuse | proper noun | 'Knuse' | Raetic | nominative | ||
tite | proper noun | 'Tite' | Raetic | |||
lauste | proper noun | 'Lauste' | Raetic | nominative | ||
laþe | unknown | unknown | Raetic | |||
þinaχe | verb | "(hat/haben) geweiht" (Rix) | Raetic | past | -ke | |
maieχe | verb | unknown | Raetic | past | -ke | |
puχe | unknown | unknown | Raetic | |||
iai | unknown | unknown | unknown | |||
iθθi | unknown | unknown | unknown | |||
uθiiθi | unknown | unknown | unknown | |||
χeli | proper noun | 'Χeli' | Raetic | nominative | ||
mi | pronoun | "I" | Etruscan | nominative | ||
remi | proper noun | 'Remi' | Raetic | nominative | ||
θarani( | proper noun | 'Taranis' (theonym) | Raetic Celtic | |||
upi | unknown | unknown | unknown | |||
kari | proper noun | 'Kari' | Raetic | nominative | ||
χari | proper noun | 'Χari' | Raetic | nominative | ||
piri | proper noun | 'Piri' | Raetic | nominative | ||
)si | noun | 'by/of ?' | Raetic | pertinentive | -si | |
kuninasi | proper noun | 'of/by the son/daughter of Kuni' | Raetic | pertinentive | -na -si | |
avaśuerasi | noun | 'by/for the Avaśu*' | Raetic | pertinentive | -si -r(a) | |
lastasi | proper noun | 'by/for Lasta' | Raetic | pertinentive | -si | |
kastriesi | proper noun | unknown | Raetic | pertinentive | -si | |
φelturiesi | proper noun | 'of/by Φeliturie' | Raetic | pertinentive | -si | |
ritauiesi | proper noun | 'of/by Ritauie' | Raetic | pertinentive | -si | |
esimnesi | proper noun | 'of/by Esimne' | Raetic | pertinentive | -si | |
esumnesi | proper noun | 'of/by Esumne' | Raetic | pertinentive | -si | |
pitaunesi | proper noun | 'of/by Pitaune' | Raetic | pertinentive | -si | |
laθurusi | proper noun | 'of/by Laθuru' | Raetic | pertinentive | -si | |
sχsi | unknown | unknown | unknown | |||
þurti | unknown | unknown | Raetic | |||
kaial | unknown | unknown | Raetic | |||
þal | numeral | 'two' | Raetic | |||
aχvil | noun | 'gift' (?) | Raetic | nominative | ||
erikian | unknown | unknown | Raetic | |||
)armatan | unknown | unknown | unknown | |||
kusen | unknown | unknown | Raetic | unknown | ||
taniun | unknown | unknown | Raetic | |||
śaruś | unknown | unknown | unknown |