Semantic search
From Rinchen Terdzö
Debug output SQLStore
ASK Query
[[-Cycle::
[[Category:Tibetan Texts]] [[Sourcerevealer::'jam dbyangs mkhyen brtse'i dbang po]]]]
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=31461)
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
OFFSET
0
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=31461)
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
OFFSET
0
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_3 | 9 | const, const | 353 | 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
- 'chi med 'ja' lus rdo rje'i srog sgrub (0 of 3 Texts)
- 'chi med 'phags ma'i snying thig (0 of 27 Texts)
- 'chi med mtsho skyes snying tig (0 of 8 Texts)
- 'jam pa'i dbyangs dngos chos rgyal tshangs pa lha'i me tog gi bla sgrub ye shes snang ba rgyas pa (0 of 4 Texts)
- Bal po'i glang chen bcas chog rab zab (0 of 1 Texts)
- Bal po'i yak+sha dzaM nag (0 of 6 Texts)
- Bka' brgyad yang gsang dregs pa kun 'dul (0 of 5 Texts)
- Bla ma bde mchog 'khor lo (0 of 4 Texts)
- Bla ma bstan gnyis skor gsum (0 of 4 Texts)
- Bla ma tshe lha rnam gsum skor (0 of 5 Texts)
- Dag snang rgya can chos sde rta mchog rol pa gnyen po lha bzhi (0 of 2 Texts)
- Dag snang sku gsum rigs 'dus zab tig (0 of 7 Texts)
- Dpal bka' 'dus chos kyi rgya mtsho (0 of 17 Texts)
- Dpal chen yang dag zab tig (0 of 4 Texts)
- Dpal gsang ba'i bdag po rdo rje me 'bar (0 of 2 Texts)
- Dpal rdo rje bdud rtsi bde ba chen po (0 of 12 Texts)
- Dpal rta mgrin gnyen po lha lnga snyan brgyud snying po'i yang zhun (0 of 3 Texts)
- Grub thob chen po'i thugs tig (0 of 24 Texts)
- Khrag 'thung bde gshegs 'dus pa (0 of 12 Texts)
- Kun bzang thugs gter (0 of 11 Texts)
- Lce btsun snying thig (0 of 8 Texts)
- Mkha' 'gro gsang ba kun 'dus (0 of 38 Texts)
- Mkhyen brtse'i dag snang tshogs mchod (0 of 1 Texts)
- Nyang gter thugs chen 'gro 'dul (0 of 5 Texts)
- Pad+ma tshe yi snying tig (0 of 3 Texts)
- Phag dkar ye shes 'khor lo gsang chen thugs tig (0 of 3 Texts)
- Rdzogs chen a ti chig chod kun grol gyi chos sde (0 of 3 Texts)
- Rgyud sde bzhi dang rjes su 'brel ba'i rje btsun sgrol ma (0 of 2 Texts)
- Rje btsun sgrol ma'i snying tig (0 of 1 Texts)
- Rjes dran tshe sgrub bai ro'i thugs tig gsang ba'i rgya can (0 of 3 Texts)
- Rta mchog rol pa'i snying tig (0 of 5 Texts)
- Rta mgrin dpa' bo gcig pa gnam lcags me'i 'khor lo (0 of 2 Texts)
- Rta mgrin dregs pa kun sgrol (0 of 16 Texts)
- Rtsa gsum 'od gsal snying tig (0 of 20 Texts)
- Rtsa gsum bde gshegs 'dus pa (0 of 3 Texts)
- Rtsa gsum dril sgrub (0 of 7 Texts)
- Rtsa gsum sgyu 'phrul drwa ba (0 of 3 Texts)
- Rtsa gsum spyi 'dus snying tig (0 of 3 Texts)
- Seng gdong dkar mo'i shu dag dkar po'i bcud len (0 of 1 Texts)
- Sgrol ma 'jigs pa kun skyob (0 of 3 Texts)
- Sgrub thabs snying po skor lnga (0 of 5 Texts)
- Snyan brgyud bdud rtsi'i mchog tig (0 of 2 Texts)
- Snyan brgyud gshin rje'i thugs tig (0 of 7 Texts)
- Snyan brgyud phrin las phur pa'i gnad tig (0 of 15 Texts)
- Snyan brgyud srid pa ma mo'i gnad tig (0 of 8 Texts)
- Thugs rje chen po don gsal sgron me (0 of 5 Texts)
- Thugs rje chen po ngan song kun skyob (0 of 2 Texts)
- Thugs rje chen po pad+ma rgyal po zhi khro rnam par rol pa (0 of 4 Texts)
- Thugs rje chen po sems nyid ngal gso (0 of 2 Texts)
- Thugs rje chen po yi ge drug pa'i gsol 'debs (0 of 2 Texts)
- Tshe sgrub ye shes snying po (0 of 3 Texts)
- Yang gter pad+ma mkha' 'gro ma rig byed rtsal (0 of 8 Texts)
- Yang phur sbrags ma'i zab tig (0 of 8 Texts)
- Yang zab rtsa gsum snying po'i skor (0 of 2 Texts)
- Yang zab thugs rje chen po rgyal ba rgya mtsho ye shes 'od kyi snying po (0 of 9 Texts)
- Zab gsang seng gdong snyan brgyud (0 of 2 Texts)
- Zab lam bla ma'i thugs sgrub yid bzhin nor bu (0 of 5 Texts)
- Zhal gdams lam rim ye shes snying po (0 of 2 Texts)