Semantic search
From Research Library
Debug output SQLStore
ASK Query
[[Category:Periodical Issues]] [[Classification::Periodical Issues]] [[:+]]
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_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_object_ids` AS t6 ON t2.s_id=t6.smw_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=63428
AND (
(t4.o_hash='Periodical Issues') AND t4.p_id=394252)
AND (t6.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
12
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_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`tsd_smw_object_ids` AS t6 ON t2.s_id=t6.smw_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=63428
AND (
(t4.o_hash='Periodical Issues') AND t4.p_id=394252)
AND (t6.smw_namespace=0)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
12
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 737 | Using index; Using temporary; Using filesort | |
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 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | wiki.t2.s_id | 1 | Using where; Distinct | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | wiki.t2.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
None2016
Periodical Issues · Journal Issues
Buddhist Studies Review/Vol. 33 No. 1-2 (2016)
Buddhist Studies Review 33.1-2 (2016). Edited by Peter Harvey, University of Sunderland and Alice Collett, Nalanda University. doi: 10.1558/bsrv.31646. Published in May and November. ISSN:0265-2897 (print). ISSN: 1747-9681 (online).
2021
Periodical Issues · Journal Issues
Bulletin of Tibetology/Vol. 52, No. 1 (2021)
Bulletin of Tibetology Volume 51, No. 1. Gangtok, Sikkim: Namgyal Institute of Tibetology, 2021. https://namgyalinstitutesikkim.org/bulletin/
1966
Periodical Issues · Journal Issues
Bulletin of the Calcutta Philological Society/Vol. 6 (1966)
Bulletin of the Calcutta Philological Society, Vol. 6. Ācārya Sukumar Sen Felicitation Volume. Guru Pūjâñjali to Ācārya Sukumar Sen by His Students. With Blessings from Ācārya Suniti Kumar Chatterji (1966)
1990
Periodical Issues · Journal Issues
Bulletin of the Research Institute of Esoteric Buddhist Culture/Special Issue (1990)
Inui, Hitoshi, ed. Mikkyō: Kōbō Daishi Kūkai and Shingon Buddhism: Bulletin of the Research Institute of Esoteric Buddhist Culture (Mikkyō Bunka Kenkyūsho Kiyō) Special Issue October 1990. Kōyasan, Japan: Research Institute of Esoteric Buddhist Culture, 1990