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, 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_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
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
t0.smw_sort ASC
LIMIT
55
OFFSET
256
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_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
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
t0.smw_sort ASC
LIMIT
55
OFFSET
256
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 | 3 | 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 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where; Distinct | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | wiki.t2.s_id, const | 1 | Using where; Distinct |
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.
Mixing Minds: Interpersonal Relationships between Tibetan Buddhist Lamas and their Western Students, and Psychoanalysts and their Analysands: A Study in Contrasts
Jennings, Pilar. Mixing Minds: Interpersonal Relationships between Tibetan Buddhist Lamas and their Western Students, and Psychoanalysts and their Analysands: A Study in Contrasts. PhD diss., Union Theological Seminary, 2009.
Dissertations · PhD diss.
Monastic Pedagogy on Emptiness in the Geluk Sect of Tibetan Buddhism - Intellectual History and Analysis of Topics Concerning Ignorance According to Svatantrika-Madhyamika in Monastic Textbooks by Jamyang Shaypa
Yi, Jongbok. "Monastic Pedagogy on Emptiness in the Geluk Sect of Tibetan Buddhism: Intellectual History and Analysis of Topics Concerning Ignorance According to Svātantrika-Mādhyamika in Monastic Textbooks by Jamyang Shaypa." PhD diss., University of Virginia, 2013.
Dissertations · MA Theses
Monism, Non-Dualism and the Mind - A Comparison of Spinoza’s Ethics and Santideva’s The Way of the Bodhisattva
Noble, Kathrine Marie. "Monism, Non-Dualism and the Mind: A Comparison of Spinoza’s Ethics and Śāntideva’s The Way of the Bodhisattva." Master's thesis, Monash University, 2016.
Dissertations · MA Theses
Multivariant Levels of Interpretations on Selected Caryās
Bhattacherjee, Rupa. "Multivariant Levels of Interpretations on Selected Caryās." MA thesis, University of Calgary, 2000. https://www.collectionscanada.gc.ca/obj/s4/f2/dsk2/ftp03/MQ55135.pdf.
Dissertations · PhD diss.
Myogenic Transformation of Emotions: A Dialectical Inquiry into Western Psychotherapy and Buddhist Psychology
Dannecker, Martina E. Myogenic Transformation of Emotions: A Dialectical Inquiry into Western Psychotherapy and Buddhist Psychology. PhD diss., California Institute of Integral Studies, 2005.
Dissertations · PhD diss.
Of Offal, Corpses, and Others: An Examination of Self, Subjectivity, and Authenticity in Two Works by Alexandra David-Neel
Jones, Robert William. Of Offal, Corpses, and Others: An Examination of Self, Subjectivity, and Authenticity in Two Works by Alexandra David-Neel. MA Thesis, Florida Atlantic University, 2010.
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.
On the Fringes of the Cold War, Shangri-La, and American Consciousness - Lowell Thomas, Lowell Thomas, Jr., and Tibet, 1949-1970
Ansley, John. "On the Fringes of the Cold War, Shangri-La, and American Consciousness: Lowell Thomas, Lowell Thomas, Jr., and Tibet, 1949-1970." PhD diss., SUNY Albany, 2016.
Dissertations · PhD diss.
Painted Books for Plaster Walls - Visual Words in the Fourteenth-century Murals at the Tibetan Buddhist Temple of Shalu
Richardson, Sarah. "Painted Books for Plaster Walls: Visual Words in the Fourteenth-century Murals at the Tibetan Buddhist Temple of Shalu." PhD diss., University of Toronto, 2016.
Dissertations · PhD diss.
Patronage and Meaning of Tibetan Buddhist Temples Decreed by the Qing Emperors in Central China in the Early and Middle Qing Dynasty
Liu, Dan. "Patronage and Meaning of Tibetan Buddhist Temples Decreed by the Qing Emperors in Central China in the Early and Middle Qing Dynasty". PhD diss., Hong Kong University, 2010.
Dissertations · PhD diss.
Penetrating the Secret Essence Tantra: Context and Philosophy in the Mahāyoga System of rNying-ma Tantra
Garson, Nathaniel Dewitt. Penetrating the Secret Essence Tantra: Context and Philosophy in the Mahāyoga System of rNying-ma Tantra. PhD diss., University of Virginia, 2004.
Dissertations · PhD diss.
Pieces of Vāc: A Study of the Letters of the Sanskrit Alphabet and Their Metaphysical Role in the Emanation of Manifest Reality as Described in Select Hindu Tantras
Dorman, Eric Robert. Pieces of Vāc: A Study of the Letters of the Sanskrit Alphabet and Their Metaphysical Role in the Emanation of Manifest Reality as Described in Select Hindu Tantras. PhD diss., California Institute of Integral Studies, 2009.
Dissertations · PhD diss.
Poetic Thought, the Intelligent Universe, and the Mystery of Self: The Tantric Synthesis of rDzogs Chen in Fourteenth Century Tibet
Germano, David Francis. "Poetic Thought, the Intelligent Universe, and the Mystery of Self: The Tantric Synthesis of rDzogs Chen in Fourteenth Century Tibet." PhD diss., University of Wisconsin-Madison, 1992.
Dissertations · PhD diss.
Politics of Tranquility - Religious Mobilities and Material Engagements of Tibetan Buddhist Nuns in Post-Mao China
Cho, Yasmin. "Politics of Tranquility: Religious Mobilities and Material Engagements of Tibetan Buddhist Nuns in Post-Mao China." PhD diss., Duke University, 2015.
Dissertations · PhD diss.
Practice and Theory of Emptiness: A Study of Jizang's Commentary on the "Refutation of Emptiness" of the Bailun
Jane, Wen-ling. Practice and Theory of Emptiness: A Study of Jizang's Commentary on the "Refutation of Emptiness" of the Bailun. PhD diss., Columbia University, 2009.
Dissertations · PhD diss.
Pratītyasamutpāda in the Abhidharmasamuccaya: Conditioned Origination in the Yogācāra Abhidharma
Kritzer, Robert Benjamin. Pratītyasamutpāda in the Abhidharmasamuccaya: Conditioned Origination in the Yogācāra Abhidharma. PhD diss., University of California at Berkeley, 1995.
Dissertations · PhD diss.
Purity, Embodiment and the Immaterial Body - An Exploration of Buddhism at a Tibetan Monastery in Karnataka, South India
Clay, Gemma. "Purity, Embodiment and the Immaterial Body: An Exploration of Buddhism at a Tibetan Monastery in Karnataka, South India." PhD diss., Brunel University, 2016.