Semantic search
From Rinchen Terdzö
Debug output SQLStore
ASK Query
[[-Cycle::
[[Category:Tibetan Texts]] [[Sourcerevealer::Mchog gyur gling pa]]]]
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
`rtzsmw_object_ids` AS t0
INNER JOIN
(`rtzsmw_di_wikipage` AS t1
INNER JOIN
(`rtzsmw_fpt_inst` AS t4
INNER JOIN
`rtzsmw_di_wikipage` AS t6 ON t4.s_id=t6.s_id) ON t1.s_id=t4.s_id) ON t0.smw_id=t1.o_id
WHERE
(t1.p_id=314314
AND (t4.o_id=314388
AND (t6.p_id=314320 AND t6.o_id=36271)
))
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
50
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
`rtzsmw_object_ids` AS t0
INNER JOIN
(`rtzsmw_di_wikipage` AS t1
INNER JOIN
(`rtzsmw_fpt_inst` AS t4
INNER JOIN
`rtzsmw_di_wikipage` AS t6 ON t4.s_id=t6.s_id) ON t1.s_id=t4.s_id) ON t0.smw_id=t1.o_id
WHERE
(t1.p_id=314314
AND (t4.o_id=314388
AND (t6.p_id=314320 AND t6.o_id=36271)
))
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t6 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | const | 689 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 8 | const, wiki.t6.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | wiki.t6.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t1.o_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:2
Errors and Warnings
NoneList of Cycles Associated with this Person
- Rdor sems thugs kyi thig le (0 of 10 Texts)
- Rdzogs chen bka' 'dus rtsa ba snying thig (0 of 8 Texts)
- Rdzogs chen lta ba klong yangs (0 of 7 Texts)
- Rdzogs chen ma rgyud mkha' 'gro gsang ba lam khyer (0 of 10 Texts)
- Rgyal chen rnam sras sgrub thabs yid bzhin nor bu (0 of 2 Texts)
- Rig 'dzin 'dzam gling rgyan mchog yang dag he ru ka (0 of 2 Texts)
- Rig 'dzin rak+sha thod phreng (0 of 8 Texts)
- Rig 'dzin rdzu 'phrul mthu chen rdo rje gro lod (0 of 3 Texts)
- Rigs gsum snying thig (0 of 14 Texts)
- Rin chen mkha' 'gro so sor 'brang ma (0 of 2 Texts)
- Rta mgrin snying po don 'dus (0 of 2 Texts)
- Sgrub chen bka' brgyad bde gshegs kun 'dus (0 of 3 Texts)
- Sngags gso bdud rtsi'i rol mtsho (0 of 5 Texts)
- Thugs dam zab pa skor bdun (0 of 48 Texts)
- Thugs rje chen po pad+ma gar dbang sgyu 'phrul drwa ba (0 of 11 Texts)
- Thugs rje chen po rgyal ba rgya mtsho (0 of 4 Texts)
- Thugs rje chen po spyan ras gzigs 'khor ba dong sprug (0 of 6 Texts)
- Thugs rje chen po yid bzhin 'khor lo (0 of 5 Texts)
- Tshe sgrub rdo rje'i phreng ba (0 of 3 Texts)
- Tshe skor phrin las rgyas pa (0 of 2 Texts)
- Yang gsang thugs kyi phur gcig (0 of 10 Texts)
- Yi dam bka' 'dus snying po (0 of 3 Texts)
- Zab bdun mngon spyod phur pa (0 of 13 Texts)
- Zab bdun rgyud zab sgyu 'phrul (0 of 10 Texts)
- Zab bdun rtsa gsum tshe'i zab pa (0 of 39 Texts)
- Zab bdun tshe dkar (0 of 7 Texts)
- Zhal gdams lam rim ye shes snying po (0 of 2 Texts)
- Zhal gdams snying po 'dus pa (0 of 1 Texts)
- Zhi byed lha mo bdun (0 of 4 Texts)
- Zhi khro na rak dong sprugs (0 of 4 Texts)
- Zur bza'i thugs dam skor drug (0 of 5 Texts)