Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Tibetan Publications]] [[:+]]
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, t6.o_sortkey
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_object_ids` AS t4 ON t2.s_id=t4.smw_id) ON t0.smw_id=t2.s_id
LEFT OUTER JOIN
`tsd_smw_fpt_cdat` AS t6 ON t0.smw_id=t6.s_id
WHERE
(
(t4.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t6.o_sortkey DESC
LIMIT
17
OFFSET
36
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, t6.o_sortkey
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_object_ids` AS t4 ON t2.s_id=t4.smw_id) ON t0.smw_id=t2.s_id
LEFT OUTER JOIN
`tsd_smw_fpt_cdat` AS t6 ON t0.smw_id=t6.s_id
WHERE
(
(t4.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t6.o_sortkey DESC
LIMIT
17
OFFSET
36
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ALL | PRIMARY | 3 | 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 | t4 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t6 | ref | s_id | s_id | 4 | wiki.t2.s_id | 1 |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (382196).
SELECT s_id FROM `tsd_smw_fpt_subc` WHERE o_id=382196 LIMIT 1
Query Metrics
Query-Size:2Query-Depth:0
Errors and Warnings
NoneTibetan Publications · Volume
Kun mkhyen go bo rab 'byams pa bsod nams seng ge'i gsung 'bum - Vol. 8 (rdzong sar khams bye'i slob gling)
Kun mkhyen go bo rab 'byams pa bsod nams seng ge'i gsung 'bum - Vol. 8. gSung ʼbum bsod nams seng ge. 15 vols. [dKar mdzes bod rigs rang skyong khul sde dge rdzong rdzong sar khams byeʼi slob gling]: rDzong sar khams byeʼi slob gling, 2004–2014.
Tibetan Publications · Volume
'gul skyod 'pho 'gyur gsar pa'i stangs 'dzin zhib 'jug dang rtsod gleng gnang phyogs skor (Benchen Publications 2023)
Skyabs rje sangs rgyas mnyan pa rin po che. Deng rabs kyi shes bya dang nang pa'i lta ba lto ba sbyar nas gzhan la phan thabs las 'gul skyod 'pho 'gyur gsar pa'i stangs 'dzin zhib 'jug dang rtsod gleng gnang phyogs skor. Benchen Shedra Publication Series 29. Kathmandu: Ban chen legs bshad rgyun skyong khang, Benchen Publications, 2023.
Tibetan Publications · Volume
Rdo rje'i gar gyi bshad pa dang mthong ba brgyud pa'i phyag bzhes skor (Benchen Publications 2023)
Skyabs rje sangs rgyas mnyan pa rin po che dang Skyabs rje bstan dga' rin po che. Rdo rje'i gar gyi bshad pa dang mthong ba brgyud pa'i phyag bzhes skor. Benchen Shedra Publication Series 30. Kathmandu: Ban chen legs bshad rgyun skyong khang, Benchen Publications, 2023.