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
NoneLanguage | adapted to | Type | Meaning | |
---|---|---|---|---|
a?( | unknown | undeterminable | unknown | |
a? | unknown | undeterminable | unknown | |
aasin | unknown | unclear | unknown | |
)ae?( | unknown | undeterminable | unknown | |
aev | unknown | beginning of alphabet | ||
ai | unknown | undeterminable | undeterminable | |
aiero | unknown | prob. proper noun | 'Aiero' (?) | |
)ais( | unknown | undeterminable | unknown | |
)akle( | unknown | undeterminable | unknown | |
akplu | unknown | undeterminable | unknown | |
alauki | unknown | proper noun | "of Alaukos" | |
amu? | unknown | undeterminable | unknown | |
an | unknown | undeterminable | unknown | |
)?an | unknown | undeterminable | unknown | |
anask | unknown | undeterminable | - | |
aś | unknown | undeterminable | unknown | |
aśoip( | unknown | undeterminable | unknown | |
aśu? | unknown | undeterminable | unknown | |
ari | unknown | undeterminable | abbreviation of a name? | |
as | unknown | undeterminable | unknown | |
as( | unknown | undeterminable | unknown | |
aus | unknown | undeterminable | unknown | |
cinis | unknown | unknown | ||
cnren | unknown | unclear | abbreviation of a name? | |
ds | unknown | undeterminable | probably an abbreviation | |
ea | unknown | undeterminable | unknown | |
)ei( | unknown | undeterminable | unknown | |
)?ele( | unknown | undeterminable | undeterminable | |
es | unknown | undeterminable | unknown | |
eu | unknown | undeterminable | unknown | |
eui | unknown | undeterminable | unknown | |
ev?( | unknown | undeterminable | unknown | |
ezuiíχaizi | unknown | unknown | ||
i? | unknown | undeterminable | unknown | |
ial | unknown | undeterminable | unknown | |
iam | unknown | undeterminable | unknown | |
)ias( | unknown | undeterminable | unknown | |
iiuotove | unknown | unclear | unknown | |
il | unknown | prob. proper noun | abbreviation (?) | |
ila( | unknown | prob. proper noun | 'for the son of Ila°' (?) | |
?i?mi | unknown | undeterminable | unknown | |
in | unknown | undeterminable | unknown | |
ina | unknown | prob. proper noun | "Ina"? | |
)??ipaitit( | unknown | undeterminable | unknown | |
)iunθanaχa | unknown | prob. proper noun | unknown | |
k?? | unknown | undeterminable | unknown | |
ka( | unknown | undeterminable | unknown | |
kar | unknown | undeterminable | unknown | |
keputus | unknown | proper noun | "Keputus" | |
kia | unknown | undeterminable | unknown |