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
25
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
25
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)