Semantic search
From Lexicon Leponticum
Jump to navigationJump to search
Debug output SQLStore
ASK Query
[[Category:Morpheme]] [[language::Lepontic]] OR [[Category:Morpheme]] [[language::Cisalpine Gaulish]] OR [[Category:Morpheme]] [[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, t18.o_hash
FROM
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`lexlep_smw_di_blob` AS t18 ON t0.smw_id=t18.s_id
WHERE
(t18.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t18.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, t18.o_hash
FROM
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`lexlep_smw_di_blob` AS t18 ON t0.smw_id=t18.s_id
WHERE
(t18.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t18.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 | t1 | ALL | PRIMARY | 152 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | lexlepwebu54.t1.id | 1 | Using where | |
1 | SIMPLE | t18 | ref | s_id, p_id, s_id_2 | s_id | 8 | lexlepwebu54.t1.id, const | 1 |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `lexlep_t1` SELECT DISTINCT t3.s_id FROM `lexlep_smw_fpt_inst` AS t3 INNER JOIN `lexlep_smw_di_blob` AS t5 ON t3.s_id=t5.s_id WHERE t3.o_id=1494 AND ((t5.o_hash='Lepontic') AND t5.p_id=899)
INSERT IGNORE INTO `lexlep_t1` SELECT DISTINCT t8.s_id FROM `lexlep_smw_fpt_inst` AS t8 INNER JOIN `lexlep_smw_di_blob` AS t10 ON t8.s_id=t10.s_id WHERE t8.o_id=1494 AND ((t10.o_hash='Cisalpine Gaulish') AND t10.p_id=899)
INSERT IGNORE INTO `lexlep_t1` SELECT DISTINCT t13.s_id FROM `lexlep_smw_fpt_inst` AS t13 INNER JOIN `lexlep_smw_di_blob` AS t15 ON t13.s_id=t15.s_id WHERE t13.o_id=1494 AND ((t15.o_hash='Celtic') AND t15.p_id=899)
Query Metrics
Query-Size:9Query-Depth:1
Errors and Warnings
NoneMorpheme | Type | Meaning | Function | Language |
---|---|---|---|---|
-ā | inflectional | nom. sg. (ā-stem) | Celtic | |
-ā- | derivational | composition vowel | Celtic | |
-a- | derivational | composition vowel | Celtic | |
ad- | lexical | 'to; very' | intensifying | Celtic |
ag- | lexical | 'battle'; 'lead, do'(?) | Celtic | |
aged- | lexical | unknown | Celtic | |
-āi̯ | inflectional | dat. sg. (ā-stem) | Celtic | |
ai̯u- | lexical | 'lifeforce, lifetime' | Celtic | |
-āk- | derivational | adjectival (hypocoristic?, patronymic?) | Celtic | |
-al- | derivational | patronymic | Lepontic | |
alk- | lexical | 'elk' (?) | Celtic | |
-ām | inflectional | acc. sg. (ā-stem) | Celtic | |
ambi- | lexical | 'around' | Celtic | |
an- | lexical | unknown | Celtic | |
an- (privative) | derivational | privative | Celtic | |
ande- | lexical | '(with)in, beneath; very' (?) | Celtic | |
are- | lexical | 'in front, before, near, east of' | Celtic | |
art- | lexical | 'bear' | Celtic | |
-ās | inflectional | gen. sg. (ā-stem) | Celtic | |
ass- | lexical | unknown | Celtic | |
-at- | derivational | unknown | Celtic | |
ate- | lexical | 'again; very' | intensifying | Celtic |
ater- | lexical | 'father' | Celtic | |
at(t)- | lexical | unknown | Celtic | |
au̯- | lexical | 'grandson, descendant' | Celtic | |
banu̯- | lexical | 'young pig' | Celtic | |
belg- | lexical | 'proud / wrathful' (?) | Celtic | |
bi- | lexical | 'strike, hit' | Celtic | |
bir(r)- | lexical | 'short' (?) | Celtic | |
bit- | lexical | 'world, age, life' | Celtic | |
biu̯- | lexical | 'alive, vital' | Celtic | |
brig- | lexical | 'height, mountain, fortress' | Celtic | |
brīg- | lexical | 'worth, honour' | Celtic | |
brist- | lexical | 'fight' | Celtic | |
brū- | lexical | uncertain | Celtic | |
brog- | lexical | 'border, territory' | Celtic | |
buđ- | lexical | unknown | Celtic | |
bog- | lexical | 'break' | Celtic | |
bou̯- | lexical | 'cow, cattle' | Celtic | |
bou̯d- | lexical | 'victory' | Celtic | |
dall- | lexical | 'blind' | Celtic | |
dēu̯- | lexical | 'god' | Celtic | |
dī- | lexical | 'from' | privative, intensifying | Celtic |
dubn- | lexical | 'deep; world' | Celtic | |
dūr- | lexical | 'hard' ('long'?) | Celtic | |
dut- | lexical | unknown | Celtic | |
-e | inflectional | 3rd person singular past | Celtic | |
-e- | derivational | composition vowel | Celtic | |
-ed- | derivational | unclear | Celtic | |
-ei̯ | inflectional | dat. sg. (i-stem) | Celtic |