Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Books]] [[Istranslation::true]] [[Pubdate::2022]]
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='2022') 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='2022') 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 | t6 | ref|filter | s_id, p_id, s_id_2, o_hash | s_id|o_hash | 8|258 | wiki.t2.s_id, const | 1 (0%) | Using where; Using rowid filter | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
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
None2022
Books · Translations, Academic Publications
A Splash of the Logical Reason
Steinkellner, Ernst, trans, ed. A Splash of the Logical Reason: Dharmakīrti's Hetubindu Translated. Beiträge zur Kultur- und Geistesgeschichte Asiens, 108. Sitzungsberichte der philosophisch-historischen Klasse, 925. Vienna: Österreichischen Akademie der Wissenschaften, 2022.
2022
Books · Translations, Digital Publications
Ascertaining the Vinaya: Upāli's Questions: Vinayaviniścayopāliparipṛcchā (Erdene-Ochir, B.)
Erdene-Ochir, ErdeneBaatar, Jake Nagasawa, and Jaakko Takkinen (UCSB Buddhist Studies Translation Group), trans. and ed. Ascertaining the Vinaya: Upāli's Questions (Vinayaviniścayopāliparipṛcchā). 84000: Translating the Words of the Buddha, 2021. https://read.84000.co/translation/toh68.html.
2022
Books · Translations
Bodhisattvacaryāvatāra: Entering the Way of the Bodhisattvas (2022, Khenpo Gawang and Wiener)
Gawang, Khenpo, and Gerry Wiener, trans. Bodhisattvacaryāvatāra: Entering the Way of the Bodhisattvas by Shantideva - Dunhuang Edition. Memphis, TN: Jeweled Lotus Publishing, 2022.
2022
Books · Translations
Delightful Ocean of Pith Instructions
Dudjom Rinpoche. Delightful Ocean of Pith Instructions: An Essential Meaning Commentary on the Instruction for the Supremely Profound Swift Path of the Great Transfer, Belonging to the Profound Secret Great Perfection. Translated by Heidi Nevin. Rhinebeck, NY: Lama Tharchin Rinpoche Heritage Foundation, 2022.
2022
Books · Translations, Digital Publications
Inspiring Determination: Adhyāśayasaṃcodana (Dorje, Lama Sherab)
Dorje, Lama Sherab, and Virginia Blum (Blazing Wisdom Translation Group), trans. Inspiring Determination (Adhyāśayasaṃcodana). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh69.html.
2022
Books · Translations
Mahasiddha Practice: From Mitrayogin and Other Masters
Gethin, Stephen (Padmakara Translation Group), trans. Mahāsiddha Practice: From Mitrayogin and Other Masters. Vol. 16 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). Tsadra Foundation Series. Boulder, CO: Snow Lion, 2021.
2022
Books · Translations
Sakya: The Path with its Result - Part 1 (Smith 2022)
Smith, Malcolm, trans. Sakya: The Path with its Result, Part 1. Vol. 5 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). Tsadra Foundation Series. Boulder, CO: Snow Lion, 2022.