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
17
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
17
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.