Semantic search
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
INNER 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
11
OFFSET
0
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 | t4 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t6 | ref | s_id | s_id | 4 | wiki.t2.s_id | 1 |
- 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-Depth:0
A mdo bstan 'dzin bsam 'phel. Bal yul gling gsum gyi gnas bskor lam yig (A Pilgrim's Guide to the Kathmandu Valley). Kathmandu, Dra Gyur Vairo Ling, 2024.
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...
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 Shed...
se ra mkha' 'gro bde chen bde ba'i rdo rje'i gsung 'bum - Vol. 7 Chengdu: Si khron dpe skrun tshogs pa (Sichuan Ethnic Publishing House), 2015.
se ra mkha' 'gro bde chen bde ba'i rdo rje'i gsung 'bum - Vol. 6 Chengdu: Si khron dpe skrun tshogs pa (Sichuan Ethnic Publishing House), 2015.
se ra mkha' 'gro bde chen bde ba'i rdo rje'i gsung 'bum - Vol. 5 Chengdu: Si khron dpe skrun tshogs pa (Sichuan Ethnic Publishing House), 2015.