Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Books]] [[Istranslation::true]] [[Pubdate::2020]]
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_di_bool` AS t4 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
(
((t4.o_value=1) AND t4.p_id=381284)
AND (
(t6.o_hash='2020') 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
55
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
`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_di_bool` AS t4 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
(
((t4.o_value=1) AND t4.p_id=381284)
AND (
(t6.o_hash='2020') 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
55
OFFSET
0
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 | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t6 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | wiki.t2.s_id, const | 1 | Using where; Distinct | |
1 | SIMPLE | t4 | ref | s_id, o_value | s_id | 8 | wiki.t2.s_id, const | 1 | Using where; 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
Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
NoneBooks · Translations
Jonang: The One Hundred and Eight Teaching Manuals
Dorje, Gyurme, trans. Jonang: The One Hundred and Eight Teaching Manuals. Vol. 18 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, 2020.
Books · Translations
Les Systèmes Philosophiques Bouddhistes (Charrier 2020)
Charrier, Christian, trans. Trésor de connaissances: Les systèmes philosophiques bouddhistes - Volume 1. By Jamgön Kongtrul Lodrö Tayé ('jam mgon kong sprul blo gros mtha' yas). Collection Tsadra. Le Plantou, France: Éditions Padmakara, 2020.
Books · Translations
Music of the Sphere of Definitive Meaning
Karmapa, 3rd, and Sangye Nyenpa. Music of the Sphere of Definitive Meaning: Detailed Explanation of the Mahamudra Prayer in Accordance with the Philosophy of the Great Emptiness-of-Other. Translated by David Molk. Kathmandu: Benchen Publications, 2020.
Books · Translations
The Blazing Lamp Tantra and The Threaded String of Pearls
Smith, Malcolm, trans. The Blazing Lamp Tantra and The Threaded String of Pearls: A Translation of the Drönma Barwai Gyü and Its Commentary. The Seventeen Dzogchen Tantras, Volume 4. Edited by Osa Karen Manell and Michael Tweed. Somerville, MA: Wisdom Publications, 2020.
Books · Academic Publications, Translations
The Buddhist Nun's Ordination in the Tibetan Canon
Roloff, Carola. The Buddhist Nun's Ordination in the Tibetan Canon: Possibilities of the Revival of the Mūlasarvāstivāda Bhikṣuṇī Lineage. Hamburg Buddhist Studies 15. Bochum, Germany: Projektverlag, 2020.
Books · Translations, Digital Publications
The Diamond Prajna Paramita Sutra
Chung Tai Translation Committee, comp. and trans. The Diamond Prajna Paramita Sutra. Puli, Taiwan: Chung Tai Shan Buddhist Foundation, 2020. https://www.ctworld.org.tw/Buddhist%20e-Books/Books01/index.html.
Books · Translations, Digital Publications
The Rice Seedling: Śālistamba (Raktrul, 6th)
Ngawang Kunga, Raktrul, Rebecca Hufen, Jason Sanche, Arne Schelling, and Sonam Spitz (Dharmasāgara Translation Group), trans. The Rice Seedling (Śālistamba). 84000: Translating the Words of the Buddha, 2020. https://read.84000.co/translation/toh210.html.
Books · Translations, Digital Publications
The Strength of the Elephant: Hastikakṣya (Forgues, G.)
Forgues, Gregory (Buddhavacana Translation Group), trans. The Strength of the Elephant (Hastikakṣya). 84000: Translating the Words of the Buddha, 2020. https://read.84000.co/translation/toh207.html.