Semantic search
From Lexicon Leponticum
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
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`lexlep_smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=1170)
AND (t4.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
505
OFFSET
500
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
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`lexlep_smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=1170)
AND (t4.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
505
OFFSET
500
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 | 653 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | lexlepwebu54.t1.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2 | s_id | 8 | lexlepwebu54.t1.s_id, const | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- sionpiri: BG·41.19
- sla(: CO·7
- slaniai: )aniui, )nialui, TI·36.1
- snaśiouitos: VA·20
- spt: PV·2
- spuris: TI·4, atios
- stu(: CO·26
- suloikei: )ei(, )ploi(, CO·21
- sunalei: )ei(, )kionei, -al- 2, TI·37, tunal, ualaunal
- sur: BG·43, VA·12
- sura: MI·10.6, NO·6, sur, surica
- surica: VB·30, sur, sura
- sutiuakos: NO·24
- sola: NO·20, solos
- solos: BG·41.6
- ta(: CO·5, CO·70, ta
- ta: BS·1, VR·9.1, ta(
- tai: BG·36.2, ta(
- tak: none
- taka: BS·8, ta(, tak
- takos: BS·5, NO·21.2, ta(, tak
- talu: BG·31, ta(
- tanatani: BG·41.19
- tanotaliknoi: NO·21.1
- tanotalos: NO·21.1, ta(, tanotaliknoi
- tau: BG·29, pau, ta(
- te(: CO·27
- )tek: CO·63.1
- tekialui: )tek, TI·27.1, TI·39, ial, te(
- telialui: TI·27.1
- terialui: TI·27.1, ial, te(, teromui
- teromui: )rkomui, TI·26, TI·27.1, te(, terialui
- tetu: -ū (3sg.), CO·48, te(
- tetumus: BS·3.1, BS·3.2, te(
- teu: VA·6, te(
- teua: BG·41.17
- teuoχtom: VC·1.2
- teuoχtoni(o)n: VC·1.1, VC·1.2, teuoχtom
- ti: BG·41.14, BG·41.15, BG·41.21, BG·41.26, BG·41.30, CO·23.3, MI·5, isiti
- )tias: )ias(, CO·25
- tikou: NM·9, anatikou, ti
- timirios: BG·41.2
- )tiris???v?(: CO·11, ti
- tisiui: TI·36.2, ti
- )tioiso: CO·11, ti
- tiou: CO·76, ti
- tri(: CO·5
- triu: TI·17
- trutikni: PG·1.2, PG·1.4, trutiknos
- trutiknos: PG·1.2, PG·1.4, druti, trutikni
- trutitis: PG·2
- trosi: NO·16
- tu??: PV·3, VB·3.4
- tu: CO·80, TI·46, TI·52, VA·1.2, tu??, Ś
- tuit: MI·21
- tunal: -al-, GR·1, VB·26, tu, tuni
- tuni: VB·3.4, tu
- tur: NO·11, tu
- turokos: NO·10, tu, tur
- tutio(: MI·21, NO·4, tou̯t-, tu, tuit
- to: BG·40, NO·14, VA·2
- tokra: VR·18
- tokua: VR·18, to
- tonoiso: BG·41.5, to
- tośokote: VC·1.2
- tou: BG·8, to
- toutas: BG·8, NO·21.2, toutiopouos, toutoris, tou̯t-
- toutiopouos: Civico Gabinetto Numismatico e Medagliere (Milano), NM·7, pou, tou̯t-, tutio(
- toutoris: The Cisalpine Celtic Languages, VR·26, ośoris, rīg-, tou̯t-
- u(: CO·19
- ua: CO·47
- ualaunal: -al-, GR·1, The Cisalpine Celtic Languages, tunal, ua
- uarsileos: TI·40, The Cisalpine Celtic Languages, kituaretos, komoneos, ua
- uase: ua
- uasekia: VB·16, atieki, ua, uasi
- uasi: BS·19, ua, uase
- ue: MI·4, ve
- uedicou: AO·3, The Cisalpine Celtic Languages
- ueca: VB·29, ue, ueconis
- uecezusezt: GR·3
- ueconis: PV·5, ue, ueca
- uenia: )nialui, NO·18, ue, uini
- uenu: TI·10, ue, uenia, uini, Ś
- uer: VR·2, ue
- uericou: AO·3
- )ueriopoi: BG·41.19
- ueriounos: BI·4
- uerkalai: )rkomui, TI·36.1, ue, uer, uerkou, vercenas
- uerkou: AO·3, TI·38, ue, uer, uerkalai
- uesa?ai: TI·45.2
- uvamokozis: CO·48, CO·57, The Cisalpine Celtic Languages, VA·31, VA·4.1, eluveitie, kośio, kualui, kuaśoni, uvltiauiopos
- uvezaruapus: MS·2
- uvltiauiopos: CO·48, The Cisalpine Celtic Languages
- ui: VA·15, VA·17, VA·26
- )uikalai: TI·54
- uin: MI·16, NO·12, ui
- uindonus: BI·7
- uini: The Cisalpine Celtic Languages, VA·17, VA·19, VA·26, sinus, ui, uin
- uinoc: NO·17.2, ui, uin
- uinoś: VB·3.1, uinom
- uinom: VB·3.1, ui, uin, uinoś
- uipios: BI·5, BI·6
- uiru: BS·23, ui, uiro
- uiro: VR·8, ui, uiru
- uisa: MI·3, ui
- uitekiois: BG·41.7, katutiniois
- uitili: BG·34, The Cisalpine Celtic Languages, ui, uitilios
- uitilios: CO·79, The Cisalpine Celtic Languages, ui, uitili
- )?uka(: TI·35
- ula: VR·16
- ulkos: NM·14
- )ume: BG·1
- uo(: CO·18
- upa: BG·41.26
- ur: VA·1.2
- urenti: BI·4
- urnum: PG·1.1
- usol: BS·23
- ut: TI·46, TI·52, VA·1.2
- utme: VR·3.2, ut
- utśe: VR·3.2
- uol: BG·12, NM·20, VR·21
- uosiu(: TI·38, TI·43
- v: NO·1, meiva
- va: BG·28.2, CO·14, CO·31, ua
- ve: BS·6
- vev: CO·54, ve
- φanuaφi: PD·1
- χosioissi: NO·1
- χuiiie: SH·1
- χusus: GR·3, χosioiso
- χoθioi: BG·21, NO·29, S, The Cisalpine Celtic Languages, kasiloi, riśoi
- χoθios: NO·29
- χosioiso: NO·1, VA·4.1, kośio, χosioio, χosioissi
- χosioio: NO·1
- obauzana: BS·3.2
- oisapi: BG·41.8, oisenu
- oisenu: BG·41.19, oisapi
- oletu: -ed-, VB·2, kiketu, plialeθu
- omezecuai: BS·3.2
- onesi: VB·15
- )oni: TI·43, TI·44
- )onis: VB·14
- onis: VR·11
- ośoris: BG·21, CO·62, VS·1, rīg-, toutoris
- ot: BG·40, VA·2
- ot(: CO·12
- otiui: TI·34.2, ot
- )otukios: BI·3
- z: CO·56.2
- zv: CO·62, North Italic Script
- §: NO·1, VA·20, VB·2
- unknown: BE·1, BG·14, BG·2.2, BG·26.1, BG·26.2, BG·41.11, BG·41.13, BG·41.19, BG·41.22, BG·41.4, BG·41.7, BG·42, BG·44, BG·45, BG·46, BG·47, BG·48, BG·5.2, BR·1, CO·19, CO·20, CO·21, CO·23.1, CO·24, CO·31, CO·45, CO·53, CO·54, CO·69, GR·2, MI·10.3, MI·10.4, MI·10.5, MI·10.7, MI·10.8, MI·16, MI·7.2, MS·4, NM·19, NO·20, NO·3, PG·1.1, TI·14, TI·15, TI·20, TI·29, TI·38, TI·45.1, TI·50, TI·51, TI·6, VA·17, VA·25, VA·9, VR·25, VR·30, VR·34, VS·1, natoś, ośoris, uinoś