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
NonePeriodical 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).
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/
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)
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