Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Dissertations]] [[Classification::Dissertations]] [[:+]]
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, t8.o_sortkey
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_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_object_ids` AS t6 ON t2.s_id=t6.smw_id) ON t0.smw_id=t2.s_id
INNER JOIN
`tsd_smw_fpt_cdat` AS t8 ON t0.smw_id=t8.s_id
WHERE
(
((t4.o_hash='Dissertations') AND t4.p_id=394252)
AND (t6.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t8.o_sortkey DESC
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, t8.o_sortkey
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_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_object_ids` AS t6 ON t2.s_id=t6.smw_id) ON t0.smw_id=t2.s_id
INNER JOIN
`tsd_smw_fpt_cdat` AS t8 ON t0.smw_id=t8.s_id
WHERE
(
((t4.o_hash='Dissertations') AND t4.p_id=394252)
AND (t6.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t8.o_sortkey DESC
LIMIT
25
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ALL | PRIMARY | 4 | 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 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | wiki.t2.s_id, const | 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 | |
1 | SIMPLE | t8 | ref | s_id | s_id | 4 | wiki.t2.s_id | 1 |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (572).
SELECT s_id FROM `tsd_smw_fpt_subc` WHERE o_id=572 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneDissertations · PhD diss.
Sacred Illusion: On Purity and Creation in Je Tsongkhapa's Philosophy of Tantra (Natanya 2017)
Natanya, Eva. "Sacred Illusion: On Purity and Creation in Je Tsongkhapa's Philosophy of Tantra." PhD diss., University of Virginia, 2017. https://doi.org/10.18130/V3ZW5V
Dissertations · MA Thesis
The Carefree Dzogchen Yogi of Dolpo, Tadru Orgyan Tenzin (1657-1737): A Partial Translation and Study of The Condensed Life of the Old Beggar Orgyan Tenzin (sprang rgan o rgyan bstan 'dzin pa'i rnam thar bsdus pa) (Smith 2023)
Smith, Michael D. "The Carefree Dzogchen Yogi of Dolpo, Tadru Orgyan Tenzin (1657-1737): A Partial Translation and Study of The Condensed Life of the Old Beggar Orgyan Tenzin (sprang rgan o rgyan bstan 'dzin pa'i rnam thar bsdus pa). MA thesis, Kathmandu University, 2023.
Dissertations · MA Thesis
Who Is the Author? Mangtö Ludrup Gyatso's Essential Nectar in the Collected Works of Jamyang Khyentse Wangpo (Fregiehn 2023)
Fregiehn, Claudia. "Who Is the Author? Mangtö Ludrup Gyatso's Essential Nectar in the Collected Works of Jamyang Khyentse Wangpo: A Case Study of the Attribution of Authorship in Tibetan Buddhism." MA thesis, Kathmandu University, 2023.
Dissertations · PhD diss.
Contributions to the Development of Tibetan Buddhist Epistemology from the Eleventh to the Fifteenth Century (Kuijp 1979)
Kuijp, Leonard W. J. van der. "Contributions to the Development of Tibetan Buddhist Epistemology from the Eleventh to the Fifteenth Century." PhD diss., Universität Hamburg, 1979.
Dissertations · PhD diss., Academic Publications, Scholarly Editions
On the Bodhisattva Path in Gandhāra (Schlosser 2016)
Schlosser, Andrea. "On the Bodhisattva Path in Gandhāra: Edition of Fragment 4 and 11 from the Bajaur Collection of Kharoṣṭhī Manuscripts". PhD diss., Free University of Berlin, 2016.
Dissertations · PhD diss.
Recognizing Purity: Space, Non-change, Luminosity, and Effort in Longchen Rabjam's Presentation of the Great Completeness (rdzogs chen)
Kelley, Justin J. "Recognizing Purity: Space, Non-change, Luminosity, and Effort in Longchen Rabjam’s Presentation of the Great Completeness (rdzogs chen)." PhD diss., Rice University, 2022.
Dissertations · PhD diss.
A Study of the Daśabhūmika-sūtra: Its Relation to Previous Buddhist Traditions and the Development of Bodhisattva Practice
Chun, Jang-Kil. "A Study of the Daśabhūmika-sūtra: Its Relation to Previous Buddhist Traditions and the Development of Bodhisattva Practice." PhD diss., University of Wisconsin-Madison, 1993.
Dissertations · MA Theses
Samādhi and Patient Acceptance: Four Chapters of the Samādhirāja-sūtra Translated from the Sanskrit and Tibetan
Rockwell, John, Jr. "Samādhi and Patient Acceptance: Four Chapters of the Samādhirāja-sūtra Translated from the Sanskrit and Tibetan." M.A. thesis, The Naropa Institute, 1980.
Dissertations · MA Theses
"Revelation" in Mādhyamika Buddhism: Chapter Eleven of the Samādhirāja Sūtra
Tatz, Mark. "'Revelation' in Mādhyamika Buddhism: Chapter Eleven of the Samādhirāja Sūtra ('On Mastering the Sūtra'); Translated from the Tibetan with Commentary." MA thesis, University of Washington, 1972. https://u1lib.org/book/2064265/12d311.
Dissertations · PhD diss.
A Less Traveled Path: Meditation and Textual Practice in the Saddharmasmrtyupasthana(sutra)
Stuart, Daniel Malinowski. "A Less Traveled Path: Meditation and Textual Practice in the Saddharmasmrtyupasthana(sutra)." PhD diss., UC Berkeley, 2012. https://escholarship.org/content/qt9nk367zn/qt9nk367zn.pdf?t=odydrr.