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
25
OFFSET
24
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
25
OFFSET
24
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
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.
