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, t8.o_sortkey
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
INNER JOIN
`tsd_smw_fpt_cdat` AS t8 ON t0.smw_id=t8.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
t8.o_sortkey DESC
LIMIT
255
OFFSET
6
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, t8.o_sortkey
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
INNER JOIN
`tsd_smw_fpt_cdat` AS t8 ON t0.smw_id=t8.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
t8.o_sortkey DESC
LIMIT
255
OFFSET
6
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 | t4 | ref | s_id, p_id, s_id_2, o_hash | s_id | 8 | wiki.t2.s_id, const | 1 | Using where | |
1 | SIMPLE | t6 | 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 | t8 | ref | s_id | s_id | 4 | wiki.t2.s_id | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NonePeriodical Issues · Art Catalogues
Sotheby's Catalogue/May 1973
Sotheby's. Catalogue of Egyptian, Western Asiatic, Greek, Etruscan and Roman Antiquities, Islamic and Isnik Pottery, Tibetan Tankas, Nepalese, Tibetan, Indian, Thailand, Khmer and Indonesian Art. Location: New Bond Street, London. Day of Sale Monday, 14th May 1983.
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
Periodical Issues · Journal Issues
Tibet Journal/Vol. 34 No. 3 & 4 - Vol. 35 No. 1 & 2 (2009 & 2010)
Vitali, Roberto. The Tibet Journal. Autumn 2009 Vol. 34 No. 3 - Summer 2010 Vol. 35 No. 2: The Earth Ox Papers - Proceedings of the International Seminar on Tibetan and Himalayan Studies, Held at the Library of Tibetan Works and Archives, September 2009 on the Occasion of the 'Thank you India' Year. Dharamsala, India: Library of Tibetan Works and Archives, 2009.