Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Books]] [[Category:Translations]] [[Pubdate::2022]]
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
`tsd_smw_object_ids` AS t0
INNER JOIN
(`tsd_smw_fpt_inst` AS t2
INNER JOIN
`tsd_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
(`tsd_smw_fpt_inst` AS t4
INNER JOIN
`tsd_t5` AS t5 ON t4.o_id=t5.id) ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_di_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(
((t6.o_hash='2022') AND t6.p_id=2642312)
)
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
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
`tsd_smw_object_ids` AS t0
INNER JOIN
(`tsd_smw_fpt_inst` AS t2
INNER JOIN
`tsd_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
(`tsd_smw_fpt_inst` AS t4
INNER JOIN
`tsd_t5` AS t5 ON t4.o_id=t5.id) ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_di_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(
((t6.o_hash='2022') AND t6.p_id=2642312)
)
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
6
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ALL | PRIMARY | 6 | Using temporary; Using filesort | ||||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | wiki.t3.id | 5 | Using index | |
1 | SIMPLE | t6 | ref|filter | s_id, p_id, s_id_2, o_hash | s_id|o_hash | 8|258 | wiki.t2.s_id, const | 1 (0%) | Using where; Using rowid filter | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | wiki.t2.s_id | 2 | Using where; Using index; Distinct | |
1 | SIMPLE | t5 | eq_ref | PRIMARY | PRIMARY | 4 | wiki.t4.o_id | 1 | Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (2642320).
SELECT s_id FROM `tsd_smw_fpt_subc` WHERE o_id=2642320 LIMIT 1 - Temporary table t5
Recursively computed hierarchy for element(s) (338370).
SELECT s_id FROM `tsd_smw_fpt_subc` WHERE o_id=338370 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
None2022
Books · Translations
Delightful Ocean of Pith Instructions
Dudjom Rinpoche. Delightful Ocean of Pith Instructions: An Essential Meaning Commentary on the Instruction for the Supremely Profound Swift Path of the Great Transfer, Belonging to the Profound Secret Great Perfection. Translated by Heidi Nevin. Rhinebeck, NY: Lama Tharchin Rinpoche Heritage Foundation, 2022.
2022
Books · Translations, Digital Publications
Inspiring Determination: Adhyāśayasaṃcodana (Dorje, Lama Sherab)
Dorje, Lama Sherab, and Virginia Blum (Blazing Wisdom Translation Group), trans. Inspiring Determination (Adhyāśayasaṃcodana). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh69.html.
2022
Books · Translations
Mahasiddha Practice: From Mitrayogin and Other Masters
Gethin, Stephen (Padmakara Translation Group), trans. Mahāsiddha Practice: From Mitrayogin and Other Masters. Vol. 16 of The Treasury of Precious Instructions: Essential Teachings of the Eight Practice Lineages of Tibet (gdams ngag rin po che'i mdzod), compiled by Jamgön Kongtrul Lodrö Taye ('jam mgon kong sprul blo gros mtha' yas). Tsadra Foundation Series. Boulder, CO: Snow Lion, 2021.
2022
Books · Translations
Sakya: The Path with its Result - Part 1 (Smith 2022)
Smith, Malcolm, trans. Sakya: The Path with its Result, Part 1. Vol. 5 of The Treasury of Precious Instructions: Essential Teachings of the Eight Practice Lineages of Tibet (gdams ngag rin po che'i mdzod), compiled by Jamgön Kongtrul Lodrö Taye ('jam mgon kong sprul blo gros mtha' yas). Tsadra Foundation Series. Boulder, CO: Snow Lion, 2022.
2022
Books · Translations
Shangpa Kagyu: The Tradition of Khyungpo Naljor - Part 1 (Harding 2022)
Harding, Sarah, trans. Shangpa Kagyu: The Tradition of Khyungpo Naljor, Part 1. Vol. 11 of The Treasury of Precious Instructions: Essential Teachings of the Eight Practice Lineages of Tibet (gdams ngag rin po che'i mdzod), compiled by Jamgön Kongtrul Lodrö Taye ('jam mgon kong sprul blo gros mtha' yas). Tsadra Foundation Series. Boulder, CO: Snow Lion, 2022.
2022
Books · Translations, Digital Publications
Teaching How All Phenomena Are without Origin: Sarvadharmāpravṛttinirdeśa (Hinkle, T.)
Hinkle, Timothy (Dharmachakra Translation Committee), trans. Teaching How All Phenomena Are without Origin (Sarvadharmāpravṛttinirdeśa). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh180.html.
2022
Books · Translations, Digital Publications
The Application of Mindfulness of the Sacred Dharma: Saddharmasmṛtyupasthāna (Doctor, T.)
Doctor, Thomas, Benjamin Collet-Cassart, and Timothy Hinkle (Dharmachakra Translation Committee), trans. The Application of Mindfulness of the Sacred Dharma (Saddharmasmṛtyupasthāna). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh287.html.
2022
Books · Translations, Digital Publications
The Avalokinī Sūtra: Avalokinīsūtra (Collet-Cassart, B.)
Collet-Cassart, Benjamin, and Nika Jovic (Dharmachakra Translation Committee), trans. The Avalokinī Sūtra (Avalokinīsūtra). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh195.html.
2022
Books · Translations, Digital Publications
The Chapter on Going Forth: Pravrajyāvastu (Miller, R.)
Miller, Robert (Lozang Zopa), trans. The Chapter on Going Forth (Pravrajyāvastu). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh1-1.html.