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, t0.smw_sort
FROM
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1170)
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
600
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1170)
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
600
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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- uitili: BG·34, The Cisalpine Celtic Languages, ui, uitilios
- uitilios: CO·79, The Cisalpine Celtic Languages, ui, uitili
- ula: VR·16
- ulkos: NM·14
- 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ś
- uo(: CO·18
- uol: BG·12, NM·20, VR·21
- uosiu(: TI·38, TI·43
- 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
- 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
- v: NO·1, meiva
- va: BG·28.2, CO·14, CO·31, ua
- vat: MI·12, va
- ve: BS·6
- vemetuvis: MS·1, ve
- vercenas: Vs 1.87
- vesa: CO·24, ve
- vesia: VA·28.3
- vev: CO·54, ve
- viku: Cl 3.2, VA·4.2, viχu
- viχu: TI·13, VA·4.2
- z: CO·56.2
- ześu: BG·41.11, BG·41.22, BG·41.30, BG·41.5, nosarti
- ziχu: VA·4.2
- zuφni: PD·1, φanuaφi
- zv: CO·62, North Italic Script
- §: NO·1, VA·20, VB·2
- ś: none
- ś(: MS·3
- ś(...)is: MS·3
- śium: TI·24, dēu̯-
- śuksim: BG·41.16
- śuro: MI·10.6
- θina: BS·3.2
- θomezeclai: BS·3.2, karite, me
- θomezecuai: BS·3.2
- φanuaφi: PD·1
- χosioio: NO·1
- χosioiso: NO·1, VA·4.1, kośio, χosioio, χosioissi
- χosioissi: NO·1
- χoθioi: BG·21, NO·29, S, The Cisalpine Celtic Languages, kasiloi, riśoi