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
25
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, 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
25
OFFSET
12
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
Le Trésor de précieuses qualités Volume 2
'jigs med gling pa and Kangyur Rinpoche, commentary. Le Trésor de précieuses qualités Vol. II: Quintessence de l'ambroisie des Trois Véhicules, Véhicule de Vajra et Grande Perfection. Translated by the Padmakara Translation Group. Collection Tsadra. Le Plantou, FR: Padmakara, 2019.
Books · Translations
Lion de la Parole
Khyentse, Dilgo. Translated by The Padmakara Translation Group. Lion de la Parole: Lampe de merveilleuse ambroisie - Biographie essentielle de l'omniscient Mipham Jamyang Namgyal Gyatso, l'impavide Lion de l'Éloquence, Phare de l'enseignement du Grand Secret. Le Plantou: Padmakara, 2019.
Books · Translations
Manjushri's Innermost Secret
Gonsalez, David, trans. Manjushri's Innermost Secret: A Profound Commentary of Oral Instructions on the Practice of Lama Chöpa. By Kachen Yeshe Gyaltsen (Tshe mchog gling ye shes rgyal mtshan). The Dechen Ling Practice Series. Somerville: Wisdom Publications, 2019.
Books · Translations
Moonbeams of Mahāmudrā (Callahan)
Callahan, Elizabeth M., trans. Moonbeams of Mahāmudrā. By Dakpo Tashi Namgyal (dwags po bkra shis rnam rgyal). With Dispelling the Darkness of Ignorance by Wangchuk Dorje (dbang phyug rdo rje), the Ninth Karmapa. Tsadra Foundation Series. Boulder, CO: Snow Lion Publications, 2019.
Books · 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.