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
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
105
OFFSET
112
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
105
OFFSET
112
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 | 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 |
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
Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 4
Sgam po pa bsod nams rin chen. Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 4. Kathmandu: Khenpo Shedup Tenzin & Lama Thinley Namgyal, 2000.
Tibetan Publications · Volume
Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 3
Sgam po pa bsod nams rin chen. Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 3. Kathmandu: Khenpo Shedup Tenzin & Lama Thinley Namgyal, 2000.
Tibetan Publications · Volume
Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 2
Sgam po pa bsod nams rin chen. Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 2. Kathmandu: Khenpo Shedup Tenzin & Lama Thinley Namgyal, 2000.
Tibetan Publications · Volume
Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 1
Sgam po pa bsod nams rin chen. Khams gsum chos kyi rgyal po mnyam med sgam po pa 'gro mgon bsod nams rin chen mchog gi gsung 'bum yid bzhin nor bu - Vol. 1. Kathmandu: Khenpo Shedup Tenzin & Lama Thinley Namgyal, 2000.
Tibetan Publications · Volume
Dpal ldan phag gru rdo rje rgyal po mchog gi gsung 'bum rin po che - Vol. 1
Phag mo gru pa rdo rje rgyal po. Dus gsum sangs rgyas thams cad kyi thugs rje'i rnam rol dpal ldan phag gru rdo rje rgyal po mchog gi gsung 'bum rin po che - Vol. 1. Kathmandu: Khenpo Shedup Tenzin & Lama Thinley Namgyal, 2003.