Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

import-annotation:

Additional annotated data are to be copied during the parsing of a subject

propsep:

The separator between the properties of a result entry

valuesep:

The separator between the values for a property of a result

template:

The name of a template with which to display the printouts

named args:

Name the arguments passed to the template

userparam:

A value passed into each template call, if a template is used

class:

An additional CSS class to set for the list

introtemplate:

The name of a template to display before the query results, if there are any

outrotemplate:

The name of a template to display after the query results, if there are any

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[HPB SB page item::+]] [[HPB SB volume::3]]
 |?HPB SB item ID=ID
 |?HPB SB volume page=page
 |?HPB SB page item=item
 |?HPB SB item continues on pages=continues
 |?HPB SB item title=title
 |?HPB SB item subtitle=subtitle
 |?HPB SB item untitled=untitled
 |?HPB SB item author=author
 |?HPB SB item status=status
 |?HPB SB item source title=source
 |?HPB SB item source details=details
 |?HPB SB item publication date=publication
 |?HPB SB item original date=original date
 |?HPB SB item type=type
 |?HPB SB item notes=notes
 |?#=wiki page
 |format=plainlist
 |limit=50
 |offset=500
 |link= none
 |sort=
 |order=asc
 |mainlabel=
 |searchlabel=next
 |template= HPB-SB TOC records
 |named args= yes
 |userparam= 3
 |introtemplate= HPB-SB TOC header
 |outrotemplate= HPB-SB table ending
}}

Results 501 – 550 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[HPB SB page item::+]] [[HPB SB volume::3]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0216",
    "from_cache": false
}

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
500

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:3
Query-Depth:1

Errors and Warnings

None

Table of contents
Page	Title	Author	Source	Date	Type	Notes
46	The Aviary ID: 03-046-04				image
46	<untitled> (With the heart of a woman...) ID: 03-046-05				article	Original in Old Russian: “Съ сердцемъ женщины”
47	Wissahickon Creek ID: 03-047-01				image
47	Universality of Spirit Influence ID: 03-047-02		Spiritual Scientist, v. 1, No. 5, October 8, 1874, p. 53	1874-10-08	article
47	<untitled> (Theism declares that God dispenses...) ID: 03-047-03	Bradlaugh, C.	Spiritual Scientist, v. 1, No. 5, October 8, 1874, p. 53	1874-10-08	article
47	A Seance with Mrs. Everitt ID: 03-047-04	Kislingbury, Emily			article
47	<untitled> (<untitled>...) ID: 03-047-05				image
48	The Wissahickon – The Hermit's Pool ID: 03-048-01				image
48, 49, 50	The Clinical View of Spiritual Phenomena ID: 03-048-02	Fairfield, F. G.	Library Table, The, p.104-106	1877-07-19	article	Under the title there is a Note in italic: Lights and Shadows of Spiritualism by D. D. Home, New York: George W. Carleton & Co.
5, 6	Mrs. Denton Again in the Field ID: 03-005-01	Denton E.M.F.	Banner of Light, The, v. 39, No. 21, August 19, 1876, p. 2	1876-08-19 (1876-08-02)	article
50, 51	The Land of the Incas – Explorations in Peru ID: 03-050-01	M.W.H.			article
51	Love’s Land ID: 03-051-01	Moulton, L. C.			poem
52	<untitled> (Two in the boat on the lake...) ID: 03-052-01				image	Decoration partly appended by HPB
52	Partly Duck and Partly Rat ID: 03-052-02		Spiritual Scientist, v. 1, No. 5, October 8, 1874, p. 56	1874-10-08	article	Signed: Approximation to Truth
52, 53	Spirit Photography ID: 03-052-03	Moses, W. S.	Spiritual Scientist, v. 1, No. 5, October 8, 1874, pp. 56-7	1874-10-08	article
53	<untitled> (<untitled>...) ID: 03-053-01				image
53, 54	Hugo's "Art of Being a Grandfather" ID: 03-053-02				article
53	<untitled> (<untitled>...) ID: 03-053-03				image
54	And thus spake on that ancient man ID: 03-054-01				image
54	A Curiosity of Crime ID: 03-054-02				article
55	<untitled> (<untitled>...) ID: 03-055-01				image	Collage
55, 56, 57	Recent Materialistic Speculations Viewed in the Light of Spiritualism ID: 03-055-02	Moses, W. S.	Spiritual Scientist, v. 1, No. 6, October 15, 1874, pp. 61-3	1874-10-15	article
57	<untitled> (<untitled>...) ID: 03-057-01				image
57	A Clerical View of Spiritualism ID: 03-057-02		London Spiritualist, No. 277, December 14, 1877, pp. 279-81	1877-12-14	article
57	<untitled> (The Theosiphical Society failed in their project...) ID: 03-057-03				article	Signed: R. P. Journal. Probably The Religio-Philosophical Journal
57	Comte Zichy, Austria ID: 03-057-04				image
58	Literary ID: 03-058-01				review
58	Among the Trees ID: 03-058-02	Bryant, W. C.	Buffalo Courier, Sunday Morning	1877-06-17	poem	From the National Repository for July
58	<untitled> (<untitled>...) ID: 03-058-03				image	Child
59	Freemasonry in Ceylon ID: 03-059-01	Examiner			article
59	Up the Schuylkill, from Columbia Bridge ID: 03-059-02				image
59	A Nation of Lairs ID: 03-059-03				article	From The Liverpool News
59	The Island of Java ID: 03-059-04		Telegram, New York, Thursday	1878-01-31	article
59	What the Blind See ID: 03-059-05				article	Signed: London Globe
59	Rev. M'Carthy expelled again ID: 03-059-06				article
59	<untitled> (The Druid worship and religion...) ID: 03-059-07				notice
59	<untitled> (A Neapolitan court has sentenced...) ID: 03-059-08				notice
59	<untitled> (Oh, grand and mystic brotherhood...) ID: 03-059-09	Rhine, Alice Hyneman			poem
6	Cruelty to Women ID: 03-006-01	Practical Christianity	Banner of Light, The, v. 39, No. 21, August 19, 1876, p. 2	1876-08-19	article
6	Dr. Buchanan on Speculative Vagaries ID: 03-006-02	Buchanan, J. R.	Banner of Light, The, v. 39, No. 24, September 9, 1876, p. 5	1876-09-09 (1876-08-27)	article
6	Elementary Spirits, Art-Magic, &e ID: 03-006-03	Britten, E. H.	Banner of Light, The	1876-08-27	article
6	What is a Dream? ID: 03-006-04		Banner of Light, The (?)		article
60	<untitled> (There is great activity in the small...) ID: 03-060-01				article
60	The "Double" or Apparition of Embodied Spirits ID: 03-060-02		Spiritual Scientist, v. 3, No. 15, December 16, 1875, p. 178	1875-12-16	article
60	<untitled> (<untitled>...) ID: 03-060-03				image	A boy is eating
60	<untitled> (<untitled>...) ID: 03-060-04				image	A boy with saber
60, 61	Spiritualism and "Eternal Torments" ID: 03-060-05		Spiritual Scientist, v. 1, No. 6, October 15, 1874, pp. 66-7	1874-10-15	article
61	<untitled> (<untitled>...) ID: 03-061-01				image	Two padres in front of fruit kiosk
61	The Animal Soul, again ID: 03-061-02		Spiritual Scientist, v. 1, No. 7, October 22, 1874, p. 74	1874-10-22	article
61	<untitled> (<untitled>...) ID: 03-061-03				image	Two men moving the boat on the river