Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Tibetan Volumes]] [[Creation date::≥2022]] [[Pubdate::≥2021]] [[Tsadraitem::true]]
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_smw_fpt_cdat` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_di_blob` AS t5 ON t2.s_id=t5.s_id
INNER JOIN
`tsd_smw_di_bool` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=436043
AND (
(t4.o_sortkey>='2459580.5')
)
AND (
(t5.o_hash>='2021') AND t5.p_id=2642312)
AND (
(t7.o_value=1) AND t7.p_id=1444643)
)
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_smw_fpt_cdat` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_di_blob` AS t5 ON t2.s_id=t5.s_id
INNER JOIN
`tsd_smw_di_bool` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=436043
AND (
(t4.o_sortkey>='2459580.5')
)
AND (
(t5.o_hash>='2021') AND t5.p_id=2642312)
AND (
(t7.o_value=1) AND t7.p_id=1444643)
)
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 | t5 | range | s_id, p_id, s_id_2, o_hash | p_id | 262 | 1011 | Using index condition; Using temporary; Using filesort | ||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | wiki.t5.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t5.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_sortkey | s_id | 4 | wiki.t5.s_id | 1 | Using where; Distinct | |
1 | SIMPLE | t7 | ref | s_id, o_value | s_id | 8 | wiki.t5.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:7Query-Depth:1
Errors and Warnings
None2021
Tibetan Publications · Volume
Spyod 'jug shes rab le'i 'grel ba
Zhe chen rgyal tshab 'gyur med padma rnam rgyal ཞེ་ཆེན་རྒྱལ་ཚབ་འགྱུར་མེད་པདྨ་རྣམ་རྒྱལ་. Byang chub sems dpa'i spyod pa la 'jug pa'i shes rab le'u'i mchan 'grel don gsal me long dang. Spyod 'jug sher le'i 'bru 'grel kun mkhyen bla ma'i gsung las btus pa rab gsal nor bu'i sgron me. བྱང་ཆུབ་སེམས་དཔའི་སྤྱོད་པ་ལ་འཇུག་པའི་ཤེས་རབ་ལེའུའི་མཆན་འགྲེལ་དོན་གསལ་མེ་ལོང་དང་སྤྱོད་འཇུག་ཤེར་ལེའི་འབྲུ་འགྲེལ་ཀུན་མཁྱེན་བླ་མའི་གསུང་ལས་བཏུས་པ་རབ་གསལ་ནོར་བུའི་སྒྲོན་མེ་ Presentations of the Ninth Chapter of the Way of the Bodhisattva. Shechen Practice Series Vol. 12. New Delhi: Zhe chen dpe mdzod khang ཞེ་ཆེན་དཔེ་མཛོད་ཁང་ Shechen Publications, 2021.
2023
Tibetan Publications · Volume
Spyon 'jug shes rab le'u dka' 'grel lung rigs 'od snang (Shechen Reprint 2023)
Rme ba mkhan chen bsod nams chos 'grub. Spyon 'jug shes rab le'u+i dka' 'grel lung rigs 'od snang. New Delhi: Shechen Publications and Tsadra Foundation, 2023. Reprint of Glag bla bsod nams chos 'grub. Spyod 'jug shes rab le'u'i dka' 'grel. kaHthog rdo rje gdan gyi par khang: Pema Norbu Rinpoche, 1985.
2021
Tibetan Publications · Volume
Yid bzhin mdzod kyi 'grel chung dang sems nyid ngal gso'i mchan 'grel
Zhe chen rgyal tshab 'gyur med pad+ma rnam rgyal. Theg pa chen po man ngag gi ba stan bcos yid bzhin rin po che'i mdzod kyi 'grel chung pad+ma dkar po'i 'khri shing dang rdzogs pa chen po sems nyid ngal gso'i mchan 'gre' pad+ma dkar po'i phreng ba. Presentations of Longchempa's Wish Fulfilling Treasury and Resting In Mind Itself. Shechen Practice Series Vol. 13. New Delhi: Shechen Publications, 2021.
2021
Tibetan Publications · Volume
Zab mo nang don gyi tshig 'grel zab don snang byed
'jam mgon kong sprul yon tan rgya mtsho. Zab mo nang don gyi tshig 'grel zab don snang byed. Blo gros mtha' yas pa'i mdzod deb phreng so brgyad pa, Rigpe Dorje Study Series - Vol. 38. Kalimpong: Rigpe Dorje Publications, 2021.
2021
Tibetan Publications · Volume
Zhal gdams dang gsung mgur sna tshogs kyi skor kun phan bdud rtsi'i sprin chen bden gnyis bsal bzhag dang bral ba'i don gyi dgongs bshad glog gi sgron ma sem don dngos gzhi sogs
Zhe chen rgyal tshab 'gyur med padma rnam rgyal ཞེ་ཆེན་རྒྱལ་ཚབ་འགྱུར་མེད་པདྨ་རྣམ་རྒྱལ་. Zhal gdams dang gsung mgur sna tshogs kyi skor kun phan bdud rtsi'i sprin chen bden gnyis bsal bzhag dang bral ba'i don gyi dgongs bshad glog gi sgron ma sem don dngos gzhi sogs ཞལ་གདམས་དང་གསུང་མགུར་སྣ་ཚོགས་ཀྱི་སྐོར་ཀུན་ཕན་བདུད་རྩིའི་སྤྲིན་ཆེན་བདེན་གཉིས་བསལ་བཞག་དང་བྲལ་བའི་དོན་གྱི་དགོངས་བཤད་གློག་གི་སྒྲོན་མ་སེམས་དོན་དངོས་གཞིའི་. The collected spiritual advice of Shechen Gyaltsab along with his presentation of the Two-Truths and writings on the Ultimate Nature. Shechen Practice Series Vol. 14. New Delhi: Zhe chen dpe mdzod khang ཞེ་ཆེན་དཔེ་མཛོད་ཁང་ Shechen Publications, 2021.