Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Articles]] [[:+]]
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, t6.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_object_ids` AS t4 ON t2.s_id=t4.smw_id) ON t0.smw_id=t2.s_id
INNER JOIN
`tsd_smw_fpt_cdat` AS t6 ON t0.smw_id=t6.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
t6.o_sortkey DESC
LIMIT
55
OFFSET
12
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, t6.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_object_ids` AS t4 ON t2.s_id=t4.smw_id) ON t0.smw_id=t2.s_id
INNER JOIN
`tsd_smw_fpt_cdat` AS t6 ON t0.smw_id=t6.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
t6.o_sortkey DESC
LIMIT
55
OFFSET
12
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ALL | PRIMARY | 152 | 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 | |
1 | SIMPLE | t6 | ref | s_id | s_id | 4 | wiki.t2.s_id | 1 |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (1818).
SELECT s_id FROM `tsd_smw_fpt_subc` WHERE o_id=1818 LIMIT 1
Query Metrics
Query-Size:2Query-Depth:0
Errors and Warnings
NoneArticles · Chapters in a Book
Can We Know Whether Śāntideva was a Consequentialist? (Goodman 2023)
Goodman, Charles. "Can We Know Whether Śāntideva was a Consequentialist?" In Reasons and Empty Persons: Mind, Metaphysics and Morality. Essays in Honor of Mark Siderits. Edited by Christian Coseru, 437–57. Cham, Switzerland: Springer Publishing, 2023.
Articles · Journal Articles
Kategorien der Wirklichkeit im frühen Yogācarā : der Fünf-vastu-Abschnitt in der Viniścayasaṃgrahaṇī der Yogācārabhūmi (Kramer 2005)
Kramer, Jowita. "Kategorien der Wirklichkeit im frühen Yogācarā : der Fünf-vastu-Abschnitt in der Viniścayasaṃgrahaṇī der Yogācārabhūmi." Contributions to Tibetan Studies, Vol. 4 (2005)
Articles · Chapters in a Book
Ratnäkaraśãnti's Hevajrasahajasadyoga (Studies in Ratnäkaraśãnti's Tantric Work I) (Isaacson 2001)
Isaacson, Harunaga. "Ratnäkaraśãnti's Hevajrasahajasadyoga (Studies in Ratnäkaraśãnti's Tantric Work I)." In Le Parole e i Marmi: Studi in Onore di Raniero Gnoli nel suo 70° Compleanno, edited by Raffaele Torella, 457–487. Rome: Istituto italiano per l'Africa e lOriente, 2001.
Articles · Chapters in a Book
Du Récit au Rituel dans les Manuscrits Tibétains de Touen-Houang (Stein 1971)
Stein, R. A. "Du Récit au Rituel dans les Manuscrits Tibétains de Touen-Houang." In Études Tibétaines Dédiées à la Mémoire de Marcelle Lalou, edited by Ariane MacDonald, 479–547. Paris: Adrien Maisonneuve, 1971.
Articles · Chapters in a Book
The Lhan Kar Ma as a Source for the History of Tantric Buddhism (Herrmann-Prandt 2002)
Hermann-Pfandt, Adelheid. "The Lhan Kar Ma as a Source for the History of Tantric Buddhism." In The Many Canons of Tibetan Buddhism: Proceedings of the Ninth Seminar of the International Association for Tibetan Studies, Leiden 2000. edited by Helmut Eimer and David Germano, 129–149. Leiden: Brill, 2002.
Articles · Journal Articles
Le Tantra des Vingt-Deux Perles de l'Esprit de Parfaite Pureté: un exemple d'intertextualité entre les traditions Bon po et rNying ma pa
Achard, Jean-Luc. "Le Tantra des Vingt-Deux Perles de l'Esprit de Parfaite Pureté: un exemple d'intertextualité entre les traditions Bon po et rNying ma pa". Cahiers d'Extrême-Asie 15 (2005): 59-106.
Articles · Journal Articles
La liste des Tantras du rNying ma'i rgyud 'bum selon l'édition établie par Kun mkhyen 'Jigs med gling pa
Achard, Jean-Luc. "La liste des Tantras du rNying ma'i rgyud 'bum selon l'édition établie par Kun mkhyen 'Jigs med gling pa". Revue d'Etudes Tibétaines 1 (2002): 62-89.
Articles · Journal Articles
A Preliminary Report on Investigations into (Bon nyid) 'Od gsal and Zhi khro bar do in Earlier Zhang zhung sNyan rgyud and sNyan rgyud Literature
Blezer, Henk. "A Preliminary Report on Investigations into (Bon nyid) 'Od gsal and Zhi khro bar do in Earlier Zhang zhung sNyan rgyud and sNyan rgyud Literature". Revue d'Etudes Tibétaines 17 (2009): 21-50.
Articles · Unpublished, Digital Publications
Index des citations dans les œuvres de Klong-chen rab-'byams
Arguillère, Stéphane. Index des citations dans les œuvres de Klongchen rab’byams. Blog Post Published on June 26, 2008. https://www.arguillere.org/article-20779457.html
Articles · Chapters in a Book
Rnying ma Tantras (Mayer)
Mayer, Robert. "Rnying ma Tantras" In Brill's Encyclopedia of Buddhism. In Vol. 1 of Brill's Encyclopedia of Buddhism: Literature and Languages, edited by Jonathan A. Silk, Oskar von Hinüber, and Vincent Eltschinger 390-97. Leiden: Brill, 2015.
Articles · Chapters in a Book
Vergleichende Analyse des Catuṣpariṣatsūtra (Waldschmidt 1951)
Waldschmidt, Ernst. "Vergleichende Analyse des Catuṣpariṣatsūtra." In Beiträge zur indischen Philologie und Altertumskunde: Walther Schubring zum 70. Geburtstag dargebracht von der deutschen Indologie, edited by Gerhard Oberhammer and Ernst Steinkellner, 84-122. Alt- und neu-indische Studien 7. Hamburg: Cram, DeGruyter, 1951.