Semantic search
From Thesaurus Inscriptionum Raeticarum
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=966)
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
6
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=966)
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
6
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 | 155 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | tirwebspas52.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- )nuale: AK-1.1, AK-1.11, AK-1.19, AK-1.2, AK-1.21, AK-1.7, ST-5, ST-6
- )s: PA-1
- )si: AK-1.6, HU-7
- -ka: SZ-15.1, SZ-2.1, SZ-2.2, SZ-87, The Raetic language, VN-10
- asua: MA-17, MA-20
- avaśuerasi: -r(a), IT-5
- azile: IT-4, ST-4, The Raetic language, sletile
- aθare: PA-1, TV-1.1
- aθivnuale: ST-4
- aχvil: -l(a), BZ-4, PA-1, PU-1, SR-1, SZ-98, Script, TV-1.1, The Raetic language, VR-3, aχvil, erikian
- eluku: MA-4, SZ-14, SZ-30, Script, The Raetic language, WE-3, WE-3 antler, WE-4, eluku, like
- enikes: BZ-2, The Raetic language
- enθus: SR-2, The Raetic language
- erikian: SZ-11, TV-1.1
- esimnesi: AK-1.6, MA-14, ST-3, SZ-15.1, The Raetic language, esiumninu, esiunne, esminu, pitaunesi
- esiumninu: MA-14, esimnesi, esiunne, pitaunesi
- esiunne: MA-14, SZ-15.1, esimnesi, esiumninu, esminu, pitaunesi
- esminu: SZ-87, esimnesi, esiunne
- esumnesi: MA-14, NO-15, NO-15 rod, SZ-15.1, The Raetic language, esimnesi, esiumninu, esiunne
- esθua: MA-11, MA-13, esθuale
- esθuale: MA-12, PA-1, ST-5, esθua
- eθunnuale: ST-1, The Raetic language
- helanu: MA-1, The Raetic language
- iai: SZ-56, SZ-58, SZ-60.1
- iθθi: AS-15.1, AS-15.2, AS-2, AS-3, AS-4, Non-script notational systems
- kaial: -l(a), IT-5, PA-1, erikian
- kalitis: SZ-4.1
- kaniśnu: NO-11, The Raetic language, ś
- kapaśunu: SZ-15.1, The Raetic language
- kara: SZ-14, The Raetic language, kari
- karataśna: SZ-14, The Raetic language
- kari: VR-7, kara
- kastriesi: ST-1, The Raetic language
- kaszrinuale: ST-2, ST-3, The Raetic language
- kativates: SZ-4.1
- kaθiave: SZ-8.1, The Raetic language, esimnesi, piθiave
- ker: MA-10, MA-4, ST-5
- ketanuvale: NO-17, The Raetic language
- kleimunθeis: IT-5, θaukis
- klevie: MA-17
- klu?θurus: PU-1, The Raetic language
- knuse: MA-18
- kuninasi: SZ-9.1, The Raetic language
- kusen: CE-1.4, UG-1.1, kusenkus
- kusenkus: The Raetic language, kusen
- la: Non-script notational systems, SZ-41, SZ-44.2, SZ-45.1, SZ-45.2, SZ-46.2, SZ-47, SZ-57.1, SZ-57.2, SZ-60.2, SZ-61, SZ-62, SZ-66, SZ-76.1, SZ-76.2, SZ-77, WE-6, uθiiθi
- laseke: -ke, RN-1
- lasta: HU-5.1, SZ-1.1, SZ-15.1, The Raetic language, VR-14, lasθe, lauste
- lastasi: WE-3
- lasθe: HU-5.1, MA-19, The Raetic language, VR-14, lasta, lauste