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
26
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
26
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 · MA Theses
La Pittura Religiosa Newar del XX Secolo: Tradizione ed Innovazione - Analisi della Pittura Tradizionale Contemporanea nella Valle del Nepal
Soranzo, Anna. La pittura religiosa newar del XX secolo: Tradizione ed innovazione - Analisi della pittura tradizionale contemporanea nella Valle del Nepal. M. A. thesis, Università di Bologna, 2002.
Dissertations · MA Theses
A Holistic Theory of Non-Dual Union: The Eighth Karmapa's Mahamudra Vision as Reaction, Re-Appropriation, and Resolution
Faria, Joseph. A Holistic Theory of Non-Dual Union: The Eighth Karmapa's Mahāmudrā Vision as Reaction, Re-Appropriation, and Resolution. MA Thesis, Rangjung Yeshe Institute, Centre for Buddhist Studies, Kathmandu University, 2015.
Dissertations · PhD diss.
Die Bhadracari, eine probe buddhistisch-religiöser lyrik
Watanabe, Kaikioku, ed. "Die Bhadracari, eine probe buddhistisch-religiöser lyrik." PhD diss., Kaiser Wilhelms-Universität. Leipzig: Druck von G. Kreysing, 1912. https://babel.hathitrust.org/cgi/pt?id=njp.32101061610976&view=1up&seq=1&skin=2021.
Dissertations · PhD diss.
Sacred Literature into Liturgy: Jingyuan (1011–1088) and the Development of the Avataṁsaka Liturgy in Song China
Sure, Heng. "Sacred Literature into Liturgy: Jingyuan (1011–1088) and the Development of the Avataṁsaka Liturgy in Song China." PhD diss., Graduate Theological Union, 2003.
Dissertations · PhD diss.
A Structuralist Examination of the Origins of the Māra Mytheme and Its Function in the Narrative of the Dàoxíng Bōrě Jīng, the Earliest Complete Recension of the Aṣṭasāhasrikā-prajñā-pāramitā-sūtra
Giddings, William James. "A Structuralist Examination of the Origins of the Māra Mytheme and Its Function in the Narrative of the Dàoxíng Bōrě Jīng, the Earliest Complete Recension of the Aṣṭasāhasrikā-prajñā-pāramitā-sūtra." PhD diss., King's College London. https://kclpure.kcl.ac.uk/portal/files/44453723/2014_Giddings_William_0838811_ethesis.pdf.
Dissertations · PhD diss.
The Bodhisattvapiṭaka: Its Doctrines, Practices and their Position in Mahāyāna Literature (Pagel 1992)
Pagel, Ulrich. "The Bodhisattvapiṭaka: Its Doctrines, Practices and their Position in Mahāyāna Literature." PhD diss., School of Oriental and African Studies (University of London), 1992. https://eprints.soas.ac.uk/29691/1/10752663.pdf.
Dissertations · PhD diss.
Daśabhūmikasūtra (Rahder, J.)
Rahder, Johannes, ed. "Daśabhūmikasūtra." (PhD diss., University of Utrecht.) Leuven, Belgium: J. B. Istas, 1926. https://objects.library.uu.nl/reader/index.php?obj=1874-286038&lan=en#page//39/03/15/39031524648488413764695835551980116855.jpg/mode/1up.
Dissertations · PhD diss.
The Bhaiṣajyaguru-Sūtra and the Buddhism of Gilgit
Schopen, Gregory. "The Bhaiṣajyaguru-Sūtra and the Buddhism of Gilgit." PhD diss., Australian National University, 1978. https://openresearch-repository.anu.edu.au/handle/1885/109328.
Dissertations · PhD diss.
The Buddhist Roots of Secular Compassion Training: A Comparative Study of Compassion Cultivation in Indian and Tibetan Mahāyāna Sources with the Contemporary Secular Program of Compassion Cultivation Training (CCT)
Stenzel, Julia Caroline. "The Buddhist Roots of Secular Compassion Training: A Comparative Study of Compassion Cultivation in Indian and Tibetan Mahāyāna Sources with the Contemporary Secular Program of Compassion Cultivation Training (CCT)." PhD diss., McGill University, 2018. https://escholarship.mcgill.ca/downloads/wm117r14g?locale=en.
Dissertations · BA Honors Thesis
A Dialogue between Thomas Merton on Agape and Shantideva on Karuna: Some Moral Dimensions of a Catholic and Mahayana Exchange
Lam, Raymond Sze Hon H. "A Dialogue between Thomas Merton on Agape and Shantideva on Karuna: Some Moral Dimensions of a Catholic and Mahayana Exchange." BA Honors thesis, University of Queensland, 2009.