Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Books]] [[Istranslation::true]] [[Pubdate::2019]]
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_bool` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_di_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(
((t4.o_value=1) AND t4.p_id=381284)
AND (
(t6.o_hash='2019') AND t6.p_id=2642312)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
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, 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_bool` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_di_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(
((t4.o_value=1) AND t4.p_id=381284)
AND (
(t6.o_hash='2019') AND t6.p_id=2642312)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
24
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ALL | PRIMARY | 6 | 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 | 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, p_id, s_id_2, o_hash | s_id | 8 | wiki.t2.s_id, const | 1 | Using where; Distinct | |
1 | SIMPLE | t4 | ref | s_id, o_value | s_id | 8 | wiki.t2.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (2642320).
SELECT s_id FROM `tsd_smw_fpt_subc` WHERE o_id=2642320 LIMIT 1
Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
NoneBooks · Translations, Edited Dharma Teaching
Perfecting Wisdom
Dalai Lama, 14th. Perfecting Wisdom: How Things Appear and How They Truly Are; A Commentary on the Wisdom Chapter of A Guide to the Bodhisattva Way of Life. Translated, edited, and annotated by B. Alan Wallace. Core Teachings of the Dalai Lama. Boulder, CO: Shambhala Publications, 2019.
Books · Translations, Scholarly Editions
Ratnakīrti's Kṣaṇabhaṅgasiddhi-Anvayātmikā: Critical Edition and Annotated Translation
Woo, Jeson. Ratnakīrti's Kṣaṇabhaṅgasiddhi-Anvayātmikā: Critical Edition and Annotated Translation. Wiener Studien zur Tibetologie und Buddhismuskunde No. 96. Vienna: Arbeitskreis für Tibetische und Buddhistische Studien Universität Wien, 2019.
Books · Translations
Self-Arising Three-Fold Embodiment of Enlightenment
Gurung, Geshe Sonam and Daniel P. Brown, trans. Self-Arising Three-Fold Embodiment of Enlightenment of Bon Great Completion Meditation. By Shardza Tashi Gyaltsen (Shar rdza bkra shis rgyal mtshan). Occidental, CA: Bright Alliance, 2019.
Books · Translations
The Clear Realisation of the Quintessential Instructions on All Dharma Practices
Bajetta, Nicola. The Clear Realisation of the Quintessential Instructions on All Dharma Practices. A Critical Edition and Annotated Translation of
the *Sarvadharmacaryopadeśābhisamayatantra (Chos spyod thams cad kyi man ngag mngon par rtogs pa’i rgyud) Based on Two Unpublished Manuscripts from the ’Bras-spungs-gnas-bcu-lha-khang. Hamburg Indian and Tibetan Studies 6. Hamburg: Department of Indian and Tibetan Studies, Universität Hamburg, 2019.
Books · Translations
The Essence of the Ocean of Attainments
Bentor, Yael and Penpa Dorjee, trans. The Essence of the Ocean of Attainments: The Creation Stage of the Guhyasamāja Tantra according to Panchen Losang Chökyi Gyaltsen. Studies in Indian and Tibetan Buddhism. Somerville: Wisdom Publications, 2019.
Books · Translations
The Tantra Without Syllables and The Blossoming Lotus
Smith, Malcolm, trans. The Tantra Without Syllables and The Blossoming Lotus: A Translation of the Yigé Mepai Gyü and Its Commentary. The Seventeen Dzogchen Tantras, Volume 3. Edited by Osa Karen Manell and Michael Tweed. Somerville, MA: Wisdom Publications, 2019.
Books · Translations
Traité de la Continuité suprême du Grand Véhicule
Charrier, Christian, and Patrick Carré, trans. Traité de la Continuité suprême du Grand Véhicule (Mahāyānottaratantraśāstra). By Maitreya. Avec le commentaire de Jamgön Kongtrul Lodreu Thayé ('jam mgon kong sprul blo gros mtha' yas) L'Incontestable Rugissement du lion. Collection Tsadra. Plazac, France: Éditions Padmakara, 2019.
Books · Translations
Zhije: The Pacification of Suffering
Harding, Sarah, trans. Zhije: The Pacification of Suffering. Vol. 13 of The Treasury of Precious Instructions: Essential Teachings of the Eight Practice Lineages of Tibet (gdams ngag rin po che'i mdzod), compiled by Jamgön Kongtrul Lodrö Taye ('jam mgon kong sprul blo gros mtha' yas). Boulder, CO: Snow Lion, 2019.