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
0
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
0
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
A Commentary on Shantideva's Engaging in the Conduct of the Bodhisattvas
Gyaltsen, Lama Kalsang, and Ani Kunga Chodron, trans. A Commentary on Shantideva's Engaging in the Conduct of the Bodhisattvas Written by Sazang Mati Panchen: Known as An Extremely Clear Illumination of the Meaning of the Text. Walden, NY: Tsechen Kunchab Ling, 2019. First edition published by The Yeshe Dorje Foundation in 2006.
Books · Translations
Brilliantly Illuminating Lamp of the Five Stages (2019)
Thurman, Robert A. F., trans. Brilliantly Illuminating Lamp of the Five Stages (rim lnga rab tu gsal ba'i sgron me): Practical Instruction in the King of Tantras, The Glorious Esoteric Community. By Tsong Khapa Losang Drakpa. Edited by Thomas F. Yarnall. Treasury of the Buddhist Sciences Series, Tengyur Translation Initiative, and Complete Works of Jey Tsong Khapa and Sons Collection. 2nd ed. New York: American Institute of Buddhist Studies; Somerville, MA: Wisdom Publications, 2019.
Books · Translations
Buddha Mind - Christ Mind
Schmidt-Leukel, Perry. Buddha Mind - Christ Mind: A Christian Commentary on the Bodhicaryāvatāra. With a new translation by Ernst Steinkellner and Cynthia Peck-Kubaczek. Christian Commentaries on Non-Christian Sacred Texts 9. Leuven, Belgium: Peeters Publishers, 2019. https://scholarblogs.emory.edu/buddhistwomen2020/files/2020/03/BCA_Translation.pdf.
Books · Translations, Academic Publications, Scholarly Editions
Buddha Nature Reconsidered - Vol 2
Higgins, David, and Martina Draszczyk. Buddha Nature Reconsidered: The Eighth Karma pa's Middle Path. Vol. 2, An Anthology of His Writings: Critical Texts and Annotated Translations. Vienna: Arbeitskreis für Tibetische und Buddhistische Studien Universität Wien, 2019.
Books · Translations
Illumination of the Hidden Meaning Part 2
Gray, David B., trans. Illumination of the Hidden Meaning: Yogic Vows, Conduct, and Ritual Praxis (sbas don kun gsal); Part II: Chapters 25–51. By Tsong Khapa Losang Drakpa. Treasury of the Buddhist Sciences Series, Tengyur Translation Initiative, and Complete Works of Jey Tsong Khapa and Sons Collection. New York: American Institute of Buddhist Studies and Wisdom Publications, 2019.