Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be 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

prefix:

Control display of namespace in printouts

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

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

{{#ask: [[Category:Clubs]][[City::New York]][[Borough::Manhattan]][[State::NY]][[Country::United States]]
 |?Type of Date
 |?Date
 |?Modern Address
 |?Country
 |?State
 |?City
 |?Name
 |?First in Location
 |?First in Location Note
 |?Reviewed
 |?Submitted by
 |?Borough
 |format=template
 |limit=100
 |offset=0
 |link=none
 |sort=_dat
 |order=ASC
 |template=Display Clubs Row
 |introtemplate=Display Clubs Header
 |outrotemplate=Display Table Footer
}}

Results 1 – 100 previous 100 20 50 100 250 500 next 100

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Clubs]][[City::New York]][[Borough::Manhattan]][[State::NY]][[Country::United States]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0788",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Clubs]] [[City::New York]] [[Borough::Manhattan]] [[State::NY]] [[Country::United States]]

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, t14.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_wikipage` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
`smw_di_blob` AS t9 ON t2.s_id=t9.s_id
INNER JOIN
`smw_di_blob` AS t11 ON t2.s_id=t11.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_time` AS t14 ON t0.smw_id=t14.s_id
WHERE
(t2.o_id=7808
   AND (
   (t4.o_hash='New York') AND t4.p_id=566)
   AND (t6.p_id=18595 AND t6.o_id=19149)
   AND (
   (t9.o_hash='NY') AND t9.p_id=568)
   AND (
   (t11.o_hash='United States') AND t11.p_id=618)
  )
   AND (t14.p_id=558)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t14.o_sortkey ASC
LIMIT
105
OFFSET
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t4	ref	s_id, o_hash, s_id_2, p_id	p_id	262	const, const	948	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	t6	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	p_id	8	const, protoballdb.t4.s_id	1	5.00	Using where
1	SIMPLE	t9	ref	s_id, o_hash, s_id_2, p_id	s_id	8	protoballdb.t4.s_id, const	1	5.00	Using where
1	SIMPLE	t14	ref	s_id, p_id, p_id_2, s_id_2	s_id	8	protoballdb.t4.s_id, const	1	100.00
1	SIMPLE	t11	ref	s_id, o_hash, s_id_2, p_id	s_id	8	protoballdb.t4.s_id, const	1	24.38	Using where
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	protoballdb.t4.s_id	1	50.00	Using where
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id	4	protoballdb.t4.s_id	1	30.91	Using where; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:9
Query-Depth:1

Errors and Warnings

None

Club	Date	City	Borough	State	First in	Contributor
Sons of Diagoras of Columbia College	1805	New York	Manhattan	NY		Ralph Carhart
Gymnastics of Columbia College	1805	New York	Manhattan	NY	United States	Ralph Carhart
Ninth and Fifteenth Ward of New York	1832	New York	Manhattan	NY		Ralph Carhart
First Ward Of New York	1832	New York	Manhattan	NY		Ralph Carhart
Gothams Club of New York	1837	New York	Manhattan	NY
New York Base Ball Club	1843	New York	Manhattan	NY
Magnolia Ball Club of New York	1843	New York	Manhattan	NY		Ralph Carhart
Knickerbocker Base Ball Club of New York	1845-09-23	New York	Manhattan	NY		Richard Hershberger
Washington Base Ball Club	1850	New York	Manhattan	NY		Ralph Carhart
Gotham Club of New York	1853	New York	Manhattan	NY		Richard Hershberger
Eagle Base Ball Club of New York	1854-04	New York	Manhattan	NY		Richard Hershberger
Empire Club of New York	1854-10-23	New York	Manhattan	NY		Richard Hershberger
Young America Club of New York	1854-10-30	New York	Manhattan	NY
Stuyvesant Club of New York	1855-05-28	New York	Manhattan	NY		Richard Hershberger
Baltic Club of New York	1855-06-01	New York	Manhattan	NY
Harlem Club of New York	1856-03	New York	Manhattan	NY		Richard Hershberger
Active Base Ball Club of New York	1856-10	New York	Manhattan	NY		Ralph Carhart
Independent Club of New York	1857-01	New York	Manhattan	NY		Richard Hershberger
Metropolitan Club of New York	1857-03-04	New York	Manhattan	NY
Champion Club of New York	1857-04-14	New York	Manhattan	NY
St. Nicholas Club of New York	1857-05-27	New York	Manhattan	NY		Richard Hershberger
Mutual Club of New York	1857-06-24	New York	Manhattan	NY
Pioneer Club of New York	1858	New York	Manhattan	NY		Bruce Allardice
Columbian Club of New York	1858	New York	Manhattan	NY		Bruce Allardice
Willoughby Club of Brooklyn	1858	New York	Manhattan	NY		Bruce Allardice
Waverly Club of New York	1858	New York	Manhattan	NY		Bruce Allardice
Trainor Club of New York City	1858	New York	Manhattan	NY		Bruce Allardice
Morning Star Club of New York	1858	New York	Manhattan	NY		Richard Hershberger
Franklin Club of New York	1858	New York	Manhattan	NY		Richard Hershberger
Wayne Club of New York	1858-05-15	New York	Manhattan	NY		Bruce Allardice
Young Wayne Club of New York	1858-06-05	New York	Manhattan	NY		Richard Hershberger
Live Oak Club of New York	1858-06-24	New York	Manhattan	NY
Lady Washington Club of New York	1858-07-24	New York	Manhattan	NY
Marion Club I of New York	1858	New York	Manhattan	NY		Richard Hershberger
Leroy Club of New York	1859	New York	Manhattan	NY		Bruce Allardice
Social Club of New York	1859	New York	Manhattan	NY		Bruce Allardice
National Club of New York	1859	New York	Manhattan	NY		Bruce Allardice
Club of New York University	1859	New York	Manhattan	NY		Bruce Allardice
Phantom Club of New York	1859-01-09	New York	Manhattan	NY		Richard Hershberger
Friendly Club of New York	1859-03-13	New York	Manhattan	NY		Richard Hershberger
Tiger Club of New York	1859-03-13	New York	Manhattan	NY		Richard Hershberger
Amity Club of New York	1859-04-24	New York	Manhattan	NY		Richard Hershberger
Americus Club of New York	1859-05-22	New York	Manhattan	NY		Richard Hershberger
Irving Club of New York	1859-05-22	New York	Manhattan	NY		Richard Hershberger
Alert Club of New York	1859-05-29	New York	Manhattan	NY		Richard Hershberger
Onalaska Club of New York	1859-05-29	New York	Manhattan	NY		Richard Hershberger
Excelsior Club of New York	1859-06-05	New York	Manhattan	NY		Richard Hershberger
Hamilton Club of New York	1859-06-05	New York	Manhattan	NY		Richard Hershberger
Hiawatha Club of New York	1859-06-05	New York	Manhattan	NY		Richard Hershberger
Jefferson Club of New York	1859-06-12	New York	Manhattan	NY		Richard Hershberger
Juniata Club of New York	1859-06-12	New York	Manhattan	NY		Richard Hershberger
Waverley Jr. Club of New York	1859-06-12	New York	Manhattan	NY		Richard Hershberger
Young Eckford Club of New York	1859-06-19	New York	Manhattan	NY		Richard Hershberger
Lexington Club of New York	1859-06-26	New York	Manhattan	NY		Richard Hershberger
Manhattan Club of New York	1859-06-26	New York	Manhattan	NY		Richard Hershberger
Clinton Club of New York	1859-06-26	New York	Manhattan	NY		Richard Hershberger
Marion (Jr.) Club of New York	1859-07-03	New York	Manhattan	NY		Richard Hershberger
Monument Club of New York	1859-07-03	New York	Manhattan	NY		Richard Hershberger
Young Clinton Club of New York	1859-07-03	New York	Manhattan	NY		Richard Hershberger
Prospect Club of New York	1859-07-03	New York	Manhattan	NY		Richard Hershberger
Uncas Club of New York	1859-07-10	New York	Manhattan	NY		Richard Hershberger
Independent Jr. Club of New York	1859-07-17	New York	Manhattan	NY		Richard Hershberger
Morphy Club of New York	1859-07-17	New York	Manhattan	NY		Richard Hershberger
Harmony Club of New York	1859-07-17	New York	Manhattan	NY		Richard Hershberger
Yorkville Club of New York	1859-07-17	New York	Manhattan	NY		Richard Hershberger
Seneca Club of New York	1859-07-17	New York	Manhattan	NY		Richard Hershberger
Mohawk Club of New York	1859-07-24	New York	Manhattan	NY		Richard Hershberger
American Club of New York	1859-07-24	New York	Manhattan	NY		Richard Hershberger
Wyndauk Club of New York	1859-07-24	New York	Manhattan	NY		Richard Hershberger
Debeyoise Club of New York	1859-07-31	New York	Manhattan	NY		Richard Hershberger
Crystal Club of New York	1859-07-31	New York	Manhattan	NY		Richard Hershberger
Cataract Club of New York	1859-08-07	New York	Manhattan	NY		Richard Hershberger
Chelsea Club of New York	1859-08-07	New York	Manhattan	NY		Richard Hershberger
Union Club of New York	1859-08-07	New York	Manhattan	NY		Richard Hershberger
Expert Club of New York	1859-08-14	New York	Manhattan	NY		Richard Hershberger
Mercury Club of New York	1859-08-14	New York	Manhattan	NY		Richard Hershberger
Enterprise Club of New York	1859-08-14	New York	Manhattan	NY		Richard Hershberger
Belvedere Club of New York	1859-08-21	New York	Manhattan	NY		Richard Hershberger
Exercise Jr. Club of New York	1859-08-28	New York	Manhattan	NY		Richard Hershberger
Friendship Club of New York	1859-08-28	New York	Manhattan	NY		Richard Hershberger
Fulton Club of New York	1859-08-28	New York	Manhattan	NY		Richard Hershberger
Ottawa Club of New York	1859-08-28	New York	Manhattan	NY		Richard Hershberger
Sagoyewatha Club of New York	1859-08-28	New York	Manhattan	NY		Richard Hershberger
Bedford Club of New York	1859-09-04	New York	Manhattan	NY		Richard Hershberger
Herculaneum Club of New York	1859-09-04	New York	Manhattan	NY		Richard Hershberger
Sylvan Start Club of New York	1859-09-04	New York	Manhattan	NY		Richard Hershberger
Henry Eckford Club of New York	1859-09-04	New York	Manhattan	NY		Richard Hershberger
Equitable Club of New York	1859-09-11	New York	Manhattan	NY		Richard Hershberger
Waverley Club of New York	1859-09-11	New York	Manhattan	NY		Richard Hershberger
Sumpter Club of New York	1859-09-11	New York	Manhattan	NY		Richard Hershberger
Robert Irwin Club of New York	1859-09-11	New York	Manhattan	NY		Richard Hershberger
Piccolomini Club of New York	1859-09-11	New York	Manhattan	NY		Richard Hershberger
Okephenokel Club of New York	1859-09-11	New York	Manhattan	NY		Richard Hershberger
Social Club II of New York	1859-09-18	New York	Manhattan	NY		Richard Hershberger
Pocahontas Club of New York	1859-09-25	New York	Manhattan	NY		Richard Hershberger
Murray Hill Club of New York	1859-09-25	New York	Manhattan	NY		Richard Hershberger
Niagara Jr. Club of New York	1859-09-25	New York	Manhattan	NY		Richard Hershberger
Webster Club of New York	1859-10-02	New York	Manhattan	NY		Richard Hershberger
Ashland Club of New York	1859-10-02	New York	Manhattan	NY		Richard Hershberger
Excelsior Club II of New York	1859-10-02	New York	Manhattan	NY		Richard Hershberger

Semantic search

Query log

Navigation menu

Search