Semantic search
From Lexicon Leponticum
Jump to navigationJump to search
Debug output SQLStore
ASK Query
[[Category:Word]] [[language::unknown]]
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, t7.o_hash
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
INNER JOIN
`lexlep_smw_di_blob` AS t7 ON t0.smw_id=t7.s_id
WHERE
(t2.o_id=1170
AND (
(t4.o_hash='unknown') AND t4.p_id=899)
)
AND (t7.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_hash 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, t7.o_hash
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
INNER JOIN
`lexlep_smw_di_blob` AS t7 ON t0.smw_id=t7.s_id
WHERE
(t2.o_id=1170
AND (
(t4.o_hash='unknown') AND t4.p_id=899)
)
AND (t7.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_hash ASC
LIMIT
55
OFFSET
0
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|filter | s_id, p_id, o_hash, s_id_2 | s_id|o_hash | 8|258 | lexlepwebu54.t2.s_id, const | 1 (6%) | Using where; Using rowid filter | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | lexlepwebu54.t2.s_id | 1 | Using where | |
1 | SIMPLE | t7 | ref | s_id, p_id, s_id_2 | s_id | 8 | lexlepwebu54.t2.s_id, const | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneWord | Word type | Translation | Status | Language |
---|---|---|---|---|
a?( | undeterminable | unknown | unknown | |
a? | undeterminable | unknown | unknown | |
aasin | unclear | unknown | unknown | |
)ae?( | undeterminable | unknown | uncertain | unknown |
aev | beginning of alphabet | unknown | ||
ai | undeterminable | undeterminable | uncertain | unknown |
aiero | prob. proper noun | 'Aiero' (?) | uncertain | unknown |
)ais( | undeterminable | unknown | unknown | |
)akle( | undeterminable | unknown | unknown | |
akplu | undeterminable | unknown | unknown | |
alauki | proper noun | "of Alaukos" | unknown | |
amu? | undeterminable | unknown | probable | unknown |
an | undeterminable | unknown | unknown | |
)?an | undeterminable | unknown | unknown | |
anask | undeterminable | - | uncertain | unknown |
aś | undeterminable | unknown | dubious | unknown |
aśoip( | undeterminable | unknown | dubious | unknown |
aśu? | undeterminable | unknown | unlikely | unknown |
ari | undeterminable | abbreviation of a name? | probable | unknown |
as | undeterminable | unknown | unknown | |
as( | undeterminable | unknown | unknown | |
aus | undeterminable | unknown | unknown | |
cinis | unknown | unknown | ||
cnren | unclear | abbreviation of a name? | probable | unknown |
ds | undeterminable | probably an abbreviation | unknown | |
ea | undeterminable | unknown | unknown | |
)ei( | undeterminable | unknown | unknown | |
)?ele( | undeterminable | undeterminable | probable | unknown |
es | undeterminable | unknown | uncertain | unknown |
eu | undeterminable | unknown | unknown | |
eui | undeterminable | unknown | unknown | |
ev?( | undeterminable | unknown | unknown | |
ezuiíχaizi | unknown | unknown | ||
i? | undeterminable | unknown | unknown | |
ial | undeterminable | unknown | unknown | |
iam | undeterminable | unknown | unknown | |
)ias( | undeterminable | unknown | unknown | |
iiuotove | unclear | unknown | unknown | |
il | prob. proper noun | abbreviation (?) | uncertain | unknown |
ila( | prob. proper noun | 'for the son of Ila°' (?) | uncertain | unknown |
?i?mi | undeterminable | unknown | uncertain | unknown |
in | undeterminable | unknown | unknown | |
ina | prob. proper noun | "Ina"? | unknown | |
)??ipaitit( | undeterminable | unknown | unknown | |
)iunθanaχa | prob. proper noun | unknown | unknown | |
k?? | undeterminable | unknown | unknown | |
ka( | undeterminable | unknown | unknown | |
kar | undeterminable | unknown | unknown | |
keputus | proper noun | "Keputus" | unknown | |
kia | undeterminable | unknown | unknown |