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
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='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
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 | 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
Shangpa Kagyu: The Tradition of Khyungpo Naljor - Part 1 (Harding 2022)
Harding, Sarah, trans. Shangpa Kagyu: The Tradition of Khyungpo Naljor, Part 1. Vol. 11 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.
2022
Books · Translations, Digital Publications
Teaching How All Phenomena Are without Origin: Sarvadharmāpravṛttinirdeśa (Hinkle, T.)
Hinkle, Timothy (Dharmachakra Translation Committee), trans. Teaching How All Phenomena Are without Origin (Sarvadharmāpravṛttinirdeśa). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh180.html.
2022
Books · Translations, Digital Publications
The Application of Mindfulness of the Sacred Dharma: Saddharmasmṛtyupasthāna (Doctor, T.)
Doctor, Thomas, Benjamin Collet-Cassart, and Timothy Hinkle (Dharmachakra Translation Committee), trans. The Application of Mindfulness of the Sacred Dharma (Saddharmasmṛtyupasthāna). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh287.html.
2022
Books · Translations, Digital Publications
The Avalokinī Sūtra: Avalokinīsūtra (Collet-Cassart, B.)
Collet-Cassart, Benjamin, and Nika Jovic (Dharmachakra Translation Committee), trans. The Avalokinī Sūtra (Avalokinīsūtra). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh195.html.
2022
Books · Translations, Digital Publications
The Chapter on Going Forth: Pravrajyāvastu (Miller, R.)
Miller, Robert (Lozang Zopa), trans. The Chapter on Going Forth (Pravrajyāvastu). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh1-1.html.
2022
Books · Translations, Digital Publications
The Detailed Account of the Previous Aspirations of the Blessed Bhaiṣajyaguruvaiḍūryaprabha: Bhagavānbhaiṣajyaguruvaiḍūryaprabhasya pūrvapraṇidhānaviśeṣavistāra (Krug, A.)
Krug, Adam (Dharmachakra Translation Committee), trans. The Detailed Account of the Previous Aspirations of the Blessed Bhaiṣajyaguruvaiḍūryaprabha (Bhagavānbhaiṣajyaguruvaiḍūryaprabhasya pūrvapraṇidhānaviśeṣavistāra). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh504.html.
2022
Books · Translations, Digital Publications
The Dhāraṇī of the Jewel Torch: Ratnolkādhāraṇī (Jackson, D.)
Jackson, David P., trans. The Dhāraṇī of the Jewel Torch (Ratnolkādhāraṇī). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh145.html.
2022
Books · Translations, Digital Publications
The Jewel Cloud: Ratnamegha (Doctor, T.)
Doctor, Thomas (Dharmachakra Translation Committee), trans. The Jewel Cloud (Ratnamegha). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh231.html.
2022
Books · Translations, Digital Publications
The King of Samādhis Sūtra: Samādhirājasūtra (Roberts, P.)
Roberts, Peter Alan, trans. The King of Samādhis Sūtra (Samādhirājasūtra). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh127.html.
2022
Books · Translations, Digital Publications
The Play in Full: Lalitavistara (Doctor, A.)
Dahl, Cortland, Catherine Dalton, Hilary Herdman, Heidi Koppl, James Gentry, and Andreas Doctor (Dharmachakra Translation Committee), trans. The Play in Full (Lalitavistara). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh95.html.
2022
Books · Translations, Digital Publications
The Precious Discourse on the Blessed One’s Extensive Wisdom That Leads to Infinite Certainty: Niṣṭhāgatabhagavajjñānavaipulyasūtraratnānanta (Doctor, A.)
Doctor, Andreas, Zachary Beer, and Thomas Doctor (Dharmachakra Translation Committee), trans. The Precious Discourse on the Blessed One's Extensive Wisdom That Leads to Infinite Certainty (Niṣṭhāgatabhagavajjñānavaipulyasūtraratnānanta). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh99.html.