Semantic search
From Thesaurus Inscriptionum Raeticarum
Jump to navigationJump to search
Debug output SQLStore
ASK Query
[[Category:Word]] [[sortform cval::+]]
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 t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=966
AND (t4.p_id=2586468)
)
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
5
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 t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=966
AND (t4.p_id=2586468)
)
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
5
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 | 155 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | tirwebspas52.t2.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2 | s_id | 8 | tirwebspas52.t2.s_id, const | 1 | Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None- )nu&action=purge )nu 17-27
- )nuale&action=purge )nuale 17-27-01-15-05
- )s&action=purge )s 24
- )si&action=purge )si 24-12
- -ka&action=purge -ka 14-01
- asua&action=purge asua 01-24-27-01
- avaśuerasi&action=purge avaśuerasi 01-06-01-21-27-05-23-01-24-12
- azile&action=purge azile 01-08-12-15-05
- aθare&action=purge aθare 01-11-01-23-05
- aθivnuale&action=purge aθivnuale 01-11-12-06-17-27-01-15-05
- aχvil&action=purge aχvil 01-30-06-12-15
- eluku&action=purge eluku 05-15-27-14-27
- enikes&action=purge enikes 05-17-12-14-05-24
- enθus&action=purge enθus 05-17-11-27-24
- erikian&action=purge erikian 05-23-12-14-12-01-17
- esimnesi&action=purge esimnesi 05-24-12-16-17-05-24-12
- esiumninu&action=purge esiumninu 05-24-12-27-16-17-12-17-27
- esiunne&action=purge esiunne 05-24-12-27-17-17-05
- esminu&action=purge esminu 05-24-16-12-17-27
- esumnesi&action=purge esumnesi 05-24-27-16-17-05-24-12
- esθua&action=purge esθua 05-24-11-27-01
- esθuale&action=purge esθuale 05-24-11-27-01-15-05
- eθunnuale&action=purge eθunnuale 05-11-27-17-17-27-01-15-05
- helanu&action=purge helanu 10-05-15-01-17-27
- iai&action=purge iai 12-01-12
- iθθi&action=purge iθθi 12-11-11-12
- kaial&action=purge kaial 14-01-12-01-15
- kalitis&action=purge kalitis 14-01-15-12-25-12-24
- kaniśnu&action=purge kaniśnu 14-01-17-12-21-17-27
- kapaśunu&action=purge kapaśunu 14-01-20-01-21-27-17-27
- kara&action=purge kara 14-01-23-01
- karataśna&action=purge karataśna 14-01-23-01-25-01-21-17-01
- kari&action=purge kari 14-01-23-12
- kastriesi&action=purge kastriesi 14-01-24-25-23-12-05-24-12
- kaszrinuale&action=purge kaszrinuale 14-01-24-08-23-12-17-27-01-15-05
- kativates&action=purge kativates 14-01-25-12-06-01-25-05-24
- kaθiave&action=purge kaθiave 14-01-11-12-01-06-05
- ker&action=purge ker 14-05-23
- ketanuvale&action=purge ketanuvale 14-05-25-01-17-27-06-01-15-05
- kleimunθeis&action=purge kleimunθeis 14-15-05-12-16-27-17-11-05-12-24
- klevie&action=purge klevie 14-15-05-06-12-05
- klu?θurus&action=purge klu?θurus 14-15-27-11-27-23-27-24
- knuse&action=purge knuse 14-17-27-24-05
- kuninasi&action=purge kuninasi 14-27-17-12-17-01-24-12
- kusen&action=purge kusen 14-27-24-05-17
- kusenkus&action=purge kusenkus 14-27-24-05-17-14-27-24
- la&action=purge la 15-01
- laseke&action=purge laseke 15-01-24-05-14-05
- lasta&action=purge lasta 15-01-24-25-01
- lastasi&action=purge lastasi 15-01-24-25-01-24-12