Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[HPB SB item status::wanted]]
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 t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='wanted') AND t1.p_id=880)
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
200
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 t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='wanted') AND t1.p_id=880)
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
200
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, s_id_2, o_hash | p_id | 262 | const, const | 1740 | 100.00 | Using index condition; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | en_teopedia_org.t1.s_id | 1 | 50.05 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneVol. | Page | Title | Author | Source | Date | Type | Notes |
---|---|---|---|---|---|---|---|
10 | 7 | The Theosophist ID: 10-007-02
|
news | ||||
10 | 7 | The Theosophist ID: 10-007-03
|
The Deccan Star, Sunday August 14th, 1879 | news | |||
10 | 7 | Pundit Dayanand Saraswati appears to be ID: 10-007-04
|
notice | ||||
10 | 7 | A leading German paper aunounces ID: 10-007-05
|
news | ||||
10 | 70, 73, 74 | New Discoveries in Spiritualism ID: 10-070-01
|
Harrison, William H. | Spiritualist,The, October 17, 1879 | 1879-10-17 | article | |
10 | 71 | Fig.1 ID: 10-071-01
|
image | ||||
10 | 71 | Fig.2 ID: 10-071-02
|
image | ||||
10 | 71 | Fig.3 ID: 10-071-03
|
image | ||||
10 | 71 | Fig.4 ID: 10-071-04
|
image | ||||
10 | 71 | Fig.5 ID: 10-071-05
|
image | ||||
10 | 74 | <untitled> ID: 10-074-01
|
Spiritualist,The, October 17, 1879 | 1879-10-17 | notice | ||
10 | 74 | <untitled> ID: 10-074-02
|
image | ||||
10 | 74 | The Self-recorded Diagram ID: 10-074-03
|
Spiritualist,The, October 17, 1879 | 1879-10-17 | notice | ||
10 | 74 | <untitled> ID: 10-074-04
|
Spiritualist,The, October17, 1879 | 1879-10-17 | notice | ||
10 | [[HPB-SB-10-75#HPB_SB_item_10--|]] | The Diagram to Which This Table relates is on Page 190 ID: Lua error in Module:SB at line 18: bad argument #2 to 'format' (number expected, got string).
|
Spiritualist, The, October 17, 1879 | 1879-10-17 | diagram | ||
10 | 76 | By Col. Henry S. Olcott to the Aria Samaj of Meerut ID: 10-076-01
|
address | ||||
10 | 77 | Government of India and the Press ID: 10-077-01
|
Indian Spectator, The, Sunday, October 26, 1879 | 1879-10-26 | article | ||
10 | 77 | Typical Indian Characters ID: 10-077-02
|
Indian Spectator, The, Sunday, October 26, 1879 | 1879-10-26 | article | ||
10 | 78 | <untitled> ID: 10-078-01
|
Indian Spectator, The, Sunday, October 26, 1879 | 1879-10-26 | notice | ||
10 | 79 | "Hulloa, Charly! What's the Matter? Training for a Race?" " No , Tom. Racing for a Train!" ID: 10-079-01
|
image | ||||
10 | 79 | Baroda Administration Report: IV ID: 10-079-02
|
Bombay Review and Indian Advertiser, October 25, 1879 | 1879-10-25 | article | ||
10 | 79 | <untitled> ID: 10-079-03
|
image | ||||
10 | 79 | A Pair of Exemplary School Boys: ID: 10-079-04
|
Bear-Leader | Bombay Review and Indian Advertiser, October 25, 1879 | 1879-10-25 | article | |
10 | 79, 80 | Street-Preaching Analysed ID: 10-079-05
|
Athanase | Bombay Review and Indian Advertiser, October 25, 1879 | 1879-10-25 | article | |
10 | 8 | Spirit Rapping ID: 10-008-02
|
Native Opinion, Sunday, 21st Sept. 1879 | article | |||
10 | 8 | Here is then... ID: 10-008-05
|
Native Opinion | article | |||
10 | 80 | A Stocking Full ID: 10-080-01
|
image | ||||
10 | 80 | A Quibble Brushed Away ID: 10-080-02
|
Massey, C.C. | Spiritualist, The, Oct. 10, 1879 | 1879-10-10 | article | |
10 | 81, 82 | An Appeal to the Parsees ID: 10-081-01
|
Indian Spectator, The, Sunday, November 2, 1879 | 1879-11-02 | article | ||
10 | 82, 82 | Typical Indian Characters ID: 10-082-01
|
Indian Spectator, The, Sunday, November 2, 1879 | 1879-11-02 | article | ||
10 | 83 | Letters from the People ID: 10-083-01
|
Daily Times, The, Jiartford, Wednesday, Oct. 22, 1879 | 1879-10-22 | article | ||
2 | 25 | Asia's Mussulman Pope ID: 02-025-01
|
World, The | article | |||
2 | 25, 26 | The Manifestations of the Invisibles through the Medium Mansfield ID: 02-025-02
|
article | ||||
2 | 26 | The Phenomena of Mind-Reading ID: 02-026-01
|
R.J. | Daily Graphic, The | 1877-10-25 (?) | article | |
2 | 27, 28 | A Description of the Inhabitants of the Moon ID: 02-027-01
|
1877-10-14 | article | |||
2 | 28 | A Phantom Girl ID: 02-028-01
|
St. Louis «Republican» | article | |||
2 | 29, 30 | A Musical Apparition ID: 02-029-01
|
Tapp, Geo. Robert | article | |||
2 | 30 | Katie King ID: 02-030-01
|
article | Reprinted from Chicago Daily Tribune | |||
2 | 31 | Clinging to the Clay ID: 02-031-01
|
Isonbergen (?) | article | Reprinted from Dayton Journal | ||
2 | 31 | Ghostly Gold Seekers ID: 02-031-02
|
Blavatsky, H. P. (?) | article | Reprinted from The Eatern Pa. Free Press | ||
2 | 32 | Isis Unveiled ID: 02-032-01
|
notice | ||||
2 | 32 | Mme. Blavatskay's book ID: 02-032-02
|
notice | ||||
2 | 32 | Isis Unveiled ID: 02-032-03
|
notice | ||||
2 | 32 | J. W. Bouton is the publisher ID: 02-032-04
|
notice | ||||
2 | 32 | Isis Unveiled ID: 02-032-05
|
notice | ||||
2 | 32 | Madame Blavatzky ID: 02-032-06
|
notice | ||||
2 | 32 | J. W. Bouton will soon ID: 02-032-07
|
notice | ||||
2 | 32 | Madame Blavatsky has finished ID: 02-032-08
|
notice | ||||
2 | 32 | Madame Blavatksy's new work ID: 02-032-09
|
notice | ||||
2 | 33 | Advance sheets of the preface ID: 02-033-01
|
Republican, The, Springfield | 1877-09-04 | notice |