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
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_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
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 | 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 · Scholarly Editions
'Gos Lo tsā ba gZhon nu dpal's Commentary on the Ratnagotravibhāgavyākhyā
Mathes, Klaus-Dieter, ed. 'Gos Lo tsā ba gZhon nu dpal's Commentary on the Ratnagotravibhāgavyākhyā (Theg pa chen po rgyud bla ma'i bstan bcos kyi 'grel bshad de kho na nyid rab tu gsal ba'i me long). Nepal Research Centre Publications 24. Stuttgart, Germany: Franz Steiner Verlag, 2003.
Books · Translations, Dharma Practice Booklets
32nd Kalachakra Initiation, Bodhgaya, 2012: Texts for the Preliminary Teaching
Organizing Committee of the 32nd Kalachakra Initiation. 32nd Kalachakra Initiation, Bodhgaya, 2012: Texts for the Preliminary Teaching. Translated and edited by the Organizing Committee of the 32nd Kalachakra Initiation. Bodhgaya, Bihir, India: Organizing Committee of the 32nd Kalachakra Initiation, 2012.
Books · Bibliographical Materials
A Bibliography of the Sanskrit Texts of the Saddharmapuṇḍarīkasūtra
Yuyama, Akira. A Bibliography of the Sanskrit Texts of the Saddharmapuṇḍarīkasūtra. Oriental Monograph Series 5. Canberra: Centre of Oriental Studies in association with Australian National University Press, 1970. https://openresearch-repository.anu.edu.au/bitstream/1885/114961/2/b10692678.pdf.
Books · Translations
A Biography of the Tripiṭaka Master of the Great Ci'en Monastery of the Great Tang Dynasty
Śramaṇa Huili and Shi Yancong. BDK English Tripiṭaka 77 A Biography of the Tripiṭaka Master of the Great Ci'en Monastery of the Great Tang Dynasty. Translated by Li Rongxi. BDK English Tripiṭaka Vol 77. Berkeley: Numata Center for Buddhist Translation and Research, 1995.
Books · Translations, Academic Publications, Scholarly Editions
A Buddha Within: The Tathāgatagarbhasūtra
Zimmermann, Michael. A Buddha Within: The Tathāgatagarbhasūtra; The Earliest Exposition of the Buddha-Nature Teaching in India. Biblotheca Philologica et Philosophica Buddhica 6. Tokyo: International Research Institute for Advanced Buddhology, Soka University, 2002. http://lirs.ru/lib/Tathagatagarbhasutra,Zimmermann,2002.pdf.
Books · Academic Publications, Translations
A Buddhist Bible (1938)
Goddard, Dwight, ed. A Buddhist Bible. Rev. and enl. ed. New York: E. P. Dutton, 1938. https://archive.org/details/in.ernet.dli.2015.279263/page/n2/mode/2up.
Books ·
A Buddhist Correspondence
lo chen bsod nams rgya mtsho. A Buddhist Correspondence: The Letters of Lo-Chen Bsod-Nams Rgya-Mtsho: Facsimile Edition of a 15th Century Tibetan Manuscript. Edited by Franz-Karl Ehrhard. Facsimile Edition Series Vol 3. Lumbini: Lumbini International Research Institute, 2002.
Books · Reference Works, Indexes-Catalogs
A Catalogue of the Comparative Kangyur (bka' 'gyur dpe bsdur ma)
Hackett, Paul G. A Catalogue of the Comparative Kangyur (bka' 'gyur dpe bsdur ma). Treasury of the Buddhist Sciences. Tengyur Translation Initiative Associated Texts New York: American Institute of Buddhist Studies, Columbia University's Center for Buddhist Studies, and Tibet House US, 2012.
Books · Academic Publications, Reference Works, Indexes-Catalogs
A Catalogue of the Kanjur Fragment from Bathang Kept in the Newark Museum
Eimer, Helmut. A Catalogue of the Kanjur Fragment from Bathang Kept in the Newark Museum. Wiener Studien zur Tibetologie und Buddhismuskunde No. 75. Vienna: Arbeitskreis für Tibetische und Buddhistische Studien Universität Wien, 2012.
Books · Reference Works
A Catalogue of the Sanskrit Manuscripts at Columbia University
Pingree, David. A Catalogue of the Sanskrit Manuscripts at Columbia University. Treasury of the Indic Sciences Series. New York: The American Institute of Buddhist Studies, Columbia University Center for Buddhist Studies, and Tibet House US, 2017.