Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[HPB SB page item::+]] [[HPB SB volume::3]]
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
`lib__smw_object_ids` AS t0
INNER JOIN
(`lib__smw_di_blob` AS t2
INNER JOIN
`lib__smw_di_number` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id=839
AND (
(t4.o_sortkey='3') AND t4.p_id=993)
)
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
0
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
`lib__smw_object_ids` AS t0
INNER JOIN
(`lib__smw_di_blob` AS t2
INNER JOIN
`lib__smw_di_number` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id=839
AND (
(t4.o_sortkey='3') AND t4.p_id=993)
)
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, p_id, o_sortkey, p_id_2, s_id_2 | p_id | 13 | const, const | 955 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | en_teopedia_org.t4.s_id | 1 | 50.06 | Using where |
1 | SIMPLE | t2 | ref | s_id, p_id, s_id_2 | s_id | 8 | en_teopedia_org.t4.s_id, const | 1 | 100.00 | Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NonePage | Title | Author | Source | Date | Type | Notes |
---|---|---|---|---|---|---|
1 | <untitled> (<untitled>...) ID: 03-001-01
|
image | ship in the open sea | |||
1 | <untitled> (<untitled>...) ID: 03-001-02
|
image | Belfry | |||
1, 2, 4 | Materialism's Last Assault ID: 03-001-03
|
Sargent, Epes | 1875-12-11 | article | Reprinted from the New York Sun of Dec. 12, 1875 | |
10, 11 | The Firman Fiasco in Paris ID: 03-010-01
|
Firman, E. M., Firman A. | London Spiritualist, No. 142, May 14, 1875, pp. 234-5 | 1875-05-14 | article | |
100 | Spiritualism in England ID: 03-100-01
|
Moses, W. S. | article | |||
100 | Relenting ID: 03-100-02
|
poem | Source unknown, also published in Mount Alexander Mail, August 14, 1874, p.2 | |||
100 | Psychometry ID: 03-100-03
|
article | ||||
101 | <untitled> (The following document...) ID: 03-101-01
|
Markov, V. | St. Petersburg Vedomosti | 1876 | letter | Protest against conclusion of the scientific Commission (headed by D.I. Mendeleev) on spiritualism phenomena, signed by 130 persons. In Russian, without a title. Published in St. Petersburg News (С.-Петербургскiя Вҍдомости). HPB has translated main part of this article and published in Spiritual Scientist as Spiritualism in Russia; it is pasted in SB 1:157. |
102 | Spiritualism ID: 03-102-01
|
Boston Herald (?) | article | |||
102 | Madame Blavatsky on Home ID: 03-102-02
|
Boston Herald (?) | notice | |||
102 | The Fight Between Spiritualism and Occultism ID: 03-102-03
|
Bloede, G. | Boston Herald (?) | notice | ||
102 | Sil as a Cure for Insanity ID: 03-102-04
|
Boston Herald (?) | notice | |||
102 | The Theory of a German Investigator ID: 03-102-05
|
Boston Herald (?) | notice | |||
102 | Notes and Extracts ID: 03-102-06
|
Boston Herald (?) | notice | |||
102 | <untitled> (Watkins, the state writer...) ID: 03-102-07
|
Boston Herald, Sunday, November 4, 1877 | note | |||
102 | Ullman`s Wonderful Dog ID: 03-102-08
|
Veritas | Sun, The | 1874-02-04 | article | |
102 | Another Batch of Facts and Opinions from D.D.Home – Buguet, Leymarie, Ellifas Levi, etc. ID: 03-102-09
|
1874-12 (?) | article | |||
103 | Letter from Mme. Leymarie in Contradiction of the Statements of Mr. Home ID: 03-103-01
|
Leymarie, Marina, Leymarie, Jeanne | Boston Herald | 1876-03-31 | article | |
103 | A Wonderful Entertainment ID: 03-103-10
|
Harttord Journal, Sunday Morning, December 20 | 1875-12-20 (?) | article | ||
103 | Snake Mary`s Tactics ID: 03-103-11
|
article | ||||
103 | <untitled> (<untitled>...) ID: 03-103-12
|
image | ||||
103 | <untitled> (Spiritualists do not deny...) ID: 03-103-02
|
Cornell, Elder M. E. | notice | |||
103 | Light Wanted ID: 03-103-03
|
H.N.S. | article | |||
103 | <untitled> (Mr. Home is identified with the Catholic church...) ID: 03-103-04
|
J.R.B. | note | |||
103 | The pusillanimity of the men of science ID: 03-103-05
|
Olcott, H. S. | note | |||
103 | <untitled> (Dr. G. Bloede has found the columns of the Herald open...) ID: 03-103-06
|
note | Signed: Spiritual Scientist | |||
103 | <untitled> (The great conjuring word...) ID: 03-103-07
|
Sargent, Epes | note | |||
103 | <untitled> (At the recent meeting of the Grand Lodge...) ID: 03-103-08
|
note | ||||
103 | Light Wanted ID: 03-103-09
|
H.N.S. | 1875 | article | ||
104 | <untitled> (<untitled>...) ID: 03-104-01
|
image | ||||
104, 105 | A Chapter of Naturalism ID: 03-104-02
|
Hitchman, William | Spiritual Scientist, v. 1, No. 17, December 31, 1874, pp. 200-1 | 1874-12-31 (1874-12-05) |
article | |
105 | <untitled> (<untitled>...) ID: 03-105-01
|
image | ||||
105, 106 | Strange Powers of Spirits of Sleeping Mortals ID: 03-105-02
|
Moses, W. S. | London Spiritualist, No. 132, March 5, 1875, p. 119 | 1875-03-05 (1875-02) |
article | |
106 | Ill-Fated Houses ID: 03-106-01
|
Spiritual Scientist, v. 1, No. 25, February 25, 1875, p. 297 | 1875-02-25 | notice | ||
106 | English Notes ID: 03-106-02
|
Spiritual Scientist, v. 1, No. 23, February 11, 1875, p. 267 | 1875-02-11 | article | ||
106 | Unscientific Scientists ID: 03-106-03
|
Cridge, Alfred | Spiritual Scientist, v. 1, No. 23, February 11, 1875, p. 267 | 1875-02-11 | article | |
107 | Chinese Spirits as Described in Chinese Fiction ID: 03-107-01
|
London Spiritualist, No. 182, February 18, 1876, p. 84 | 1876-02-18 | article | From "The Globe" | |
107 | Another Child Medium ID: 03-107-02
|
Spiritual Scientist, v. 1, No. 23, February 11, 1875, p. 267 | 1875-02-11 | article | ||
108 | The Mysteries of Necromancy ID: 03-108-01
|
Spiritual Scientist, v. 1, No. 23, February 11, 1875, p. 272 | 1875-02-11 | article | In section "Phenomenal" | |
108 | Spider Amulet ID: 03-108-02
|
Spiritual Scientist, v. 1, No. 23, February 11, 1875, p. 272 | 1875-02-11 | article | ||
109 | Charity ID: 03-109-01
|
Kathlfen | Spiritualist, The, September 11, 1874, p.103 | 1874-09-11 | poem | |
109 | Climatic Influence of England ID: 03-109-02
|
Davy, Humphrey | Spiritualist, The, September 11, 1874, p.103 | 1874-09-11 | article | |
109 | <untitled> (<untitled>...) ID: 03-109-03
|
notice | ||||
109 | Astrology, – Its Good and Evil Stars ID: 03-109-04
|
Spiritualist, The, September 11, 1874, p.103 | 1874-09-11 | article | ||
109 | <untitled> (A little nonsense now and then...) ID: 03-109-05
|
notice | ||||
109, 110 | Professor Huxley on Mesmerism ID: 03-109-06
|
Spiritualist, The, September 11, 1874, p.103 | 1874-09-11 | article | ||
11 | Important Caution to Slanderers ID: 03-011-01
|
Britten, E. H. | Banner of Light | 1875-05-14 | article | |
11 | <untitled> (The London Spiritual Magazine, in noticing D. D. Home's book...) ID: 03-011-02
|
notice | ||||
11 | Little Things ID: 03-011-03
|
Bush, E. T. | poem | |||
110 | The Doctrine of Immortality Among the Ancient Egyptians ID: 03-110-01
|
Constant, C. | Spiritualist, The, September 11, 1874, p. 104 | 1874-09-11 | article |