Semantic search
From Lexicon Leponticum
Jump to navigationJump to search
Debug output SQLStore
ASK Query
[[Category:Word]] [[language::Celtic]]
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 t2
INNER JOIN
`lexlep_smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=1170
AND (
(t4.o_hash='Celtic') AND t4.p_id=899)
)
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
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, t0.smw_sort
FROM
`lexlep_smw_object_ids` AS t0
INNER JOIN
(`lexlep_smw_fpt_inst` AS t2
INNER JOIN
`lexlep_smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=1170
AND (
(t4.o_hash='Celtic') AND t4.p_id=899)
)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | 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 | t4 | 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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneWord | Word type | Translation | Status | Language |
---|---|---|---|---|
arki | proper noun | 'of Ark(i)os' | probable | Celtic |
arpatimoi | noun | unknown | Celtic | |
art | prob. proper noun | abbreviation (?) | Celtic | |
artebuθz | proper noun | 'Artebuθz' | Celtic | |
artonis | proper noun | "(son) of Artu"? | Celtic | |
aruki | proper noun | "of Arukos" | Celtic | |
ase | unclear | unknown | Celtic | |
aststaz | verb | "he/she erected / placed (beside)" | Celtic | |
astuo | unclear | unknown | Celtic | |
at | prob. proper noun | abbreviation (?) | Celtic | |
atai | proper noun | 'for Ata' | uncertain | Celtic |
atbiti | proper noun | "(daughter) of Atbitos" | Celtic | |
atep | proper noun | abbreviation | Celtic | |
atepa | proper noun | 'Atepa' | Celtic | |
ateporix | proper noun | 'Ateporiχs' | Celtic | |
atepu | proper noun | 'Atepu' | Celtic | |
ateratos | proper noun | 'Ateratos' | Celtic | |
aterio | proper noun | 'Aterio' | Celtic | |
ateuloipitus | proper noun | 'Ateuloipitus' | Celtic | |
atiaki | proper noun | "of Atiakos" | uncertain | Celtic |
atieki | proper noun | "of Atiekos" | uncertain | Celtic |
atilonei | proper noun | 'to/for Atilu' | Celtic | |
atis | proper noun | "Atis" | Celtic | |
atissius | proper noun | "Atissius" | Celtic | |
atlatu | proper noun | "Atlatu" | Celtic | |
auai | proper noun | 'for Aua' | uncertain | Celtic |
aui | proper noun | 'for Auos' | Celtic | |
aunmi | proper noun | "of Aunmos"? | Celtic | |
autesai | proper noun | "to Autesa" | Celtic | |
azus | proper noun | 'Azus' | uncertain | Celtic |
aśkoneti | proper noun | '(son) of Aśkonet(i)os' | Celtic | |
aśkonetio | proper noun | 'Aśkonetio' | Celtic | |
aśuesa | proper noun | 'Aśuesa' | Celtic | |
broχθui | proper noun | 'of Brogduos' or 'for Brogdos' | Celtic | |
caledonos | proper noun | 'of Caledu' | Celtic | |
celθestra | proper noun | - | Celtic | |
cese | proper noun | - | Celtic | |
cesii | proper noun | "of Kesos" | Celtic | |
ciami | proper noun | 'of Ciamos' | probable | Celtic |
cnreiu | proper noun | abbreviation of a name? | probable | Celtic |
declai | verb | - | Celtic | |
dugiaua | prob. proper noun | 'Dugiava' | Celtic | |
esonius | proper noun | 'Esonius' | Celtic | |
esopnos | proper noun | 'Esopnos' | Celtic | |
etu | proper noun | 'Etu' | Celtic | |
faui | noun | "of Favos/Favus"? | Celtic Latin | |
fesia | proper noun | "Fesia" | Celtic | |
iakir | unclear | unknown | Celtic | |
iap??i | prob. proper noun | 'to/for Iap?is/Iap?a' (?) | Celtic | |
iatuini | proper noun | 'of Iatuinos' | uncertain | Celtic |