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
24
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
24
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
The Precious Treasury of the Fundamental Nature
Blankleder, Helena, and Wulstan Fletcher (Padmakara Translation Group), trans. The Precious Treasury of the Fundamental Nature. By Longchenpa. With a commentary by Khangsar Tenpa'i Wangchuk. Boulder, CO: Shambhala Publications, 2022.
2022
Books · Translations, Digital Publications
The Questions of Rāṣṭrapāla (1): Rāṣṭrapālaparipṛcchā (Brockhausen, K.)
Brockhausen, Konstantin, Jamie Gordon Creek, Susanne Fleischmann, Daniel Gratzer, Georgi Krastev, Katrin Querl, and Julika Weber (Vienna Buddhist Translation Studies Group), trans. The Questions of Rāṣṭrapāla (1) (Rāṣṭrapālaparipṛcchā). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh62.html.
2022
Books · Translations, Digital Publications
The Questions of Sāgaramati: Sāgaramatiparipṛcchā (Hinkle, T.)
Hinkle, Timothy (Dharmachakra Translation Committee) trans. The Questions of Sāgaramati (Sāgaramatiparipṛcchā). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh152.html.
2022
Books · Translations, Digital Publications
The Questions of the Nāga King Sāgara (2): Sāgaranāgarājaparipṛcchā (Ewing, B.)
Ewing, Benjamin (Dharmachakra Translation Committee), trans. The Questions of the Nāga King Sāgara (2) (Sāgaranāgarājaparipṛcchā). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh154.html.
2022
Books · Translations, Digital Publications
The Questions of the Nāga King Sāgara (3): Sāgaranāgarājaparipṛcchā (Gyaltsen, Kalsang)
Gyaltsen, Khenpo Kalsang, and Reverend Dr. Chodrung Kunga Chodron (Sakya Pandita Translation Group), trans. The Questions of the Nāga King Sāgara (3) (Sāgaranāgarājaparipṛcchā). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh155.html.
2022
Books · Translations, Digital Publications
The Seal of Engagement in Awakening the Power of Faith: Śraddhābalādhānāvatāramudrā (Beer, Z.)
Beer, Zachary (Dharmachakra Translation Committee), trans. The Seal of Engagement in Awakening the Power of Faith (Śraddhābalādhānāvatāramudrā). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh201.html.
2022
Books · Translations
The Single Intention: The Root Text, a Commentary by Khenpo Kunpal, and an Overview by Rinchen Jangchub
Nielsen, Solvej Hyveled, trans. The Single Intention: The Root Text, a Commentary by Khenpo Kunpal, and an Overview by Rinchen Jangchub. Munich, Germany: Garchen Sriftung, 2022.
2022
Books · Translations, Digital Publications
The Stem Array: Gaṇḍavyūha (Roberts, P.)
Roberts, Peter Alan, trans. The Stem Array (Gaṇḍavyūha). Edited by Emily Bower. 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh44-45.html.
2022
Books · Translations, Digital Publications
The Teaching of Akṣayamati: Akṣayamatinirdeśa (Braarvig, J.)
Braarvig, Jens, trans. The Teaching of Akṣayamati (Akṣayamatinirdeśa). Revised and edited by David Welsh. 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh175.html.
2022
Books · Translations, Digital Publications
The Teaching of Vimalakīrti: Vimalakīrtinirdeśa (Thurman, R.)
Thurman, Robert A. F., trans. The Teaching of Vimalakīrti (Vimalakīrtinirdeśa). 84000: Translating the Words of the Buddha, 2022. https://read.84000.co/translation/toh176.html.