Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Books]] [[:+]]
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_object_ids` AS t4 ON t2.s_id=t4.smw_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.smw_namespace=0)
)
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
62
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_object_ids` AS t4 ON t2.s_id=t4.smw_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.smw_namespace=0)
)
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
62
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 | t4 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where |
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:2Query-Depth:0
Errors and Warnings
NoneBooks · Translations, Dharma Practice Booklets
A Collection of Prayers for the Swift Rebirth of Kyabje Trulshik Rinpoche
Padmakara Translation Group, trans. A Collection of Prayers for the Swift Rebirth of Kyabje Trulshik Rinpoche. Kathmandu, Nepal: Dzarong Thupten Mindrol Dongak Chöling Monastery, n.d.
Books · Translations
A Commentary on Shantideva's Engaging in the Conduct of the Bodhisattvas
Gyaltsen, Lama Kalsang, and Ani Kunga Chodron, trans. A Commentary on Shantideva's Engaging in the Conduct of the Bodhisattvas Written by Sazang Mati Panchen: Known as An Extremely Clear Illumination of the Meaning of the Text. Walden, NY: Tsechen Kunchab Ling, 2019. First edition published by The Yeshe Dorje Foundation in 2006.
Books · Collections of Essays
A Companion to Buddhist Philosophy
Emmanuel, Steven M., ed. A Companion to Buddhist Philosophy. Blackwell Companions to Philosophy 50. Malden, MA: Wiley-Blackwell, 2013. http://www.ahandfulofleaves.org/documents/A%20Companion%20to%20Buddhist%20Philosophy_Emmanuel.pdf
Books · Translations
A Comparative Study of the Prātimokṣa
Pachow, W. A Comparative Study of the Prātimokṣa: On the Basis of its Chinese, Tibetan, Sanskrit and Pali Versions. Buddhist Tradition Series 31. Delhi: Motilal Banarsidass Publishers, 2007. Originally Published, Sino-Indian Studies (Santiniketan), 1951 and 1955.
Books · Translations
A Compendium of Ways of Knowing (1980)
A-kya Yong-dzin Yang-chӓn ga-wӓi lo-dr'ö. A Compendium of Ways of Knowing (1980): A Clear Mirror of what should be Accepted and Rejected ("Blo-rigs-kyi sdom-tsig blang-dor gsal-ba'i me long"). Commentary by Geshe Ngawang Dhargyey. Translated and Edited by Alexander Berzin, Sherpa Tulku, Khamlung Tulku, and Jonathan Landaw. The Wisdom of Tibet Series. Dharamsala: Library of Tibetan Works and Archives, 1980.
Books · Translations
A Compendium of Ways of Knowing (1996)
A kya yongs 'dzin dbyangs can dga' ba'i blo gros. A Compendium of Ways of Knowing: A Clear Mirror of What Should Be Accepted and Rejected ("Blo-rigs-kyi sdom-tsig blang-dor gsal-ba'i me long"). Commentary by Geshe Ngawang Dhargyey. Translated and Edited by Alexander Berzin, Sherpa Tulku, Khamlung Tulku and Jonathan Landaw. Dharamsala: Library of Tibetan Works and Archives, 1996.
Books · Translations
A Comprehensive Commentary on the Heart Sutra
K'uei-chi. BDK English Tripiṭaka 66-I: A Comprehensive Commentary on the Heart Sutra (Prajñāpāramita-hṛdaya-sūtra). Translated by Heng-ching Shih in collaboration with Dan Lusthaus BDK English Tripiṭaka Vol 66 No. 1. Berkeley: Numata Center for Buddhist Translation and Research, 2001.
Books · Scholarly Editions
A Critical Edition of Lokakṣema's Translation of the Aṣṭasāhasrikā Prajñāpāramitā
Karashima, Seishi, ed. A Critical Edition of Lokakṣema's Translation of the Aṣṭasāhasrikā Prajñāpāramitā. Bibliotheca Philologica et Philosophica Buddhica 12. Tokyo: International Research Institute for Advanced Buddhology, Soka University, 2011. Link
Books · Art Books
A Decade of Collecting
Asian Art Museum of San Francisco, and René Yvon Lefebvre d'Argencé. 1976. A decade of collecting: an exhibition celebrating the 10th anniversary of the Asian Art Museum of San Francisco, the Avery Brundage Collection, winter, 1976-spring, San Francisco: The Museum, 1977.
Books · Reference Works, Bibliographical Materials
A Descriptive Bibliography of the Sanskrit Buddhist Literature, Vol. III
Tsukamoto, Keisho, Yukei Matsunaga, and Hirofumi Isoda, eds. A Descriptive Bibliography of the Sanskrit Buddhist Literature. Vol. 3, Abhidharma, Madhyamaka, Yogācāra, Buddhist Epistemology and Logic. Kyoto: Heirakuji-Shoten, 1990.
Books · Academic Publications, Reference Works
A Descriptive Catalogue of Sanscrit Manuscripts in the Government Collection
Shastri, Hara Prasad. A Descriptive Catalogue of Sanscrit Manuscripts in the Government Collection, Under the Care of The Asiatic Society. Vol. 1, Buddhist Manuscripts. Calcutta: Asiatic Society of Bengal, 1917. https://archive.org/details/in.ernet.dli.2015.62303.
Books · Translations
A Direct Path to Enlightenment (1972)
'Jam mgon kong sprul. A Direct Path to Enlightenment Being a Commentary which will Comfortably Introduce Ordinary People to the Mahayana Teaching of the Seven Points of Mind Training. Translated by Ken McLeod. Vancouver: Kagyu Kunkhyab Chuling, 1972.
Books · Translations
A Direct Path to Enlightenment (1975)
'Jam mgon kong sprul. A Direct Path to Enlightenment Being a Commentary which will Comfortably Introduce Ordinary People to the Mahayana Teaching of the Seven Points of Mind Training. Translated by Ken McLeod. Vancouver: Kagyu Kunkhyab Chuling, Second edition 1975.
Books · Collections of Essays, Translations, Academic Publications
A Distant Mirror
Lin, Chen-kuo, and Michael Radich, eds. A Distant Mirror: Articulating Indic Ideas in Sixth and Seventh Century Chinese Buddhism. Hamburg Buddhist Studies 3. Hamburg: Hamburg University Press, 2014. https://hup.sub.uni-hamburg.de/volltexte/2014/146/pdf/HamburgUP_HBS03_LinRadich_Mirror.pdf.