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:Ballgames]][[City::New York]][[Borough::Manhattan]][[State::NY]][[Country::United States]]
 |?Type of Date
 |?Date
 |?Modern Address
 |?Country
 |?State
 |?City
 |?Home Team
 |?Away Team
 |?Home Score
 |?Away Score
 |?First in Location
 |?First in Location Note
 |?Crown
 |?Reviewed
 |?Submitted by
 |?Borough
 |format=template
 |limit=50
 |offset=200
 |link=none
 |sort=
 |order=asc
 |template=Display Games Row
 |introtemplate=Display Games Header
 |outrotemplate=Display Table Footer
}}

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

JSON CSV RSS RDF

Query log

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

Debug output SQLStore

ASK Query

[[Category:Ballgames]] [[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, t0.smw_sort
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
WHERE
(t2.o_id=681
   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 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	t4	ref	s_id, o_hash, s_id_2, p_id	p_id	262	const, const	1038	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	s_id	8	protoballbetadb.t4.s_id, const	1	5.00	Using where
1	SIMPLE	t9	ref	s_id, o_hash, s_id_2, p_id	s_id	8	protoballbetadb.t4.s_id, const	1	5.00	Using where
1	SIMPLE	t11	ref	s_id, o_hash, s_id_2, p_id	s_id	8	protoballbetadb.t4.s_id, const	1	21.85	Using where
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id	4	protoballbetadb.t4.s_id	1	9.47	Using where
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	protoballbetadb.t4.s_id	1	50.00	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:9
Query-Depth:1

Errors and Warnings

None

Page	Date	City	Borough	State	Team 1	Team 2	Score	First in	Contributor
Ballgame	1860-07-07	New York	Manhattan	NY	Excelsior Club of Brooklyn	Putnam Club of Brooklyn			Craig Waff
Ballgame	1858-04-29	New York	Manhattan	NY	Excelsior Club of New York	Excelsior Club of New York	49 - 19		Craig Waff
Ballgame	1865-06-01	New York	Manhattan	NY	Excelsior Club of New York	Grammercy Club of New York	31 - 8		Bob Tholkes
Ballgame	1858-10-23	New York	Manhattan	NY	Excelsior Jr.	Mohawk	24 - 15		Craig Waff
Ballgame	1860-06-25	New York	Manhattan	NY	Excelsior M	Putnam M	55 - 45		Craig Waff
Ballgame	1859-10-03	New York	Manhattan	NY	Excelsior	Clinton	34 - 5		Craig Waff
Ballgame	1859-09-22	New York	Manhattan	NY	Excelsior	Pastime			Craig Waff
Ballgame	1859-12-10	New York	Manhattan	NY	Excelsior	Wayne Club of New York			Craig Waff
Ballgame	1857-11-14	New York	Manhattan	NY	Excelsior	Wayne			Craig Waff
Ballgame	1859-08-25	New York	Manhattan	NY	Exercise Jr.	Albion	32 - 26		Craig Waff
Ballgame	1859-09-08	New York	Manhattan	NY	Exercise	Morphy	33 - 26		Craig Waff
Ballgame	1860-09-28	New York	Manhattan	NY	Exercise	Vigilant	29 - 14		Craig Waff
Ballgame	1859-09-03	New York	Manhattan	NY	Expert	Liberty	27 - 5		Craig Waff
Ballgame	1859-09-26	New York	Manhattan	NY	Favorita 2	Alert 1	17 - 10		Craig Waff
Ballgame	1859-11-25	New York	Manhattan	NY	Favorita Club of Brooklyn	Favorita Club of Brooklyn	31 - 18		Craig Waff
Ballgame	1859-09-22	New York	Manhattan	NY	Favorita	Alert			Craig Waff
Ballgame	1860-07-21	New York	Manhattan	NY	First Nine	Muffin Nine	47 - 2		Craig Waff
Ballgame	1862-05-10	New York	Manhattan	NY	First Nine	Second Nine	33 - 15		Craig Waff
Ballgame	1862-04-14	New York	Manhattan	NY	First Nine	Second Nine			Craig Waff
Ballgame	1862-04-19	New York	Manhattan	NY	First Nine	Second Nine	17 - 9		Craig Waff
Ballgame	1862-05-03	New York	Manhattan	NY	First Nine	Second Nine	35 - 17		Craig Waff
Ballgame	1859-09-08	New York	Manhattan	NY	First Nine	Second Nine	38 - 10		Craig Waff
Ballgame	1860-04-21	New York	Manhattan	NY	First Nine	Second nine			Craig Waff
Ballgame	1832	New York	Manhattan	NY	First Ward Of New York	Ninth and Fifteenth Ward of New York		United States	Ralph Carhart
Ballgame	1865-11-25	New York	Manhattan	NY	Flushing Institute Club of New York	Phoenix Club of New York	34 - 17		Bob Tholkes
Ballgame	1859-11-03	New York	Manhattan	NY	Fordham College	College of St. Francis Xavier
Ballgame	1859-06-11	New York	Manhattan	NY	Franklin 1	Vernon 2			Craig Waff
Ballgame	1858-10-23	New York	Manhattan	NY	Franklin Club of New York	Astoria	24 - 21		Bob Tholkes
Ballgame	1863-09-01	New York	Manhattan	NY	Franklin Club of New York	Everett Club of New York	31 - 10		Bob Tholkes
Ballgame	1860-05-21	New York	Manhattan	NY	Franklin Club of New York	Liberty Club of New York	36 - 36		Bob Tholkes
Ballgame	1860-04-27	New York	Manhattan	NY	Franklin Club of New York	Unknown Club of Paterson	40 - 40		Craig Waff
Ballgame	1860-05-05	New York	Manhattan	NY	Franklin Club of New York	Unknown Club of Paterson	42 - 36		Craig Waff
Ballgame	1859-11-11	New York	Manhattan	NY	Franklin	Vernon	8 - 6		Craig Waff
Ballgame	1860-06-14	New York	Manhattan	NY	Free Academy Club of New York	Club of New York University	19 - 4		Craig Waff
Ballgame	1860-06-28	New York	Manhattan	NY	Free Academy Club of New York	Free Academy Club of New York	29 - 27		Craig Waff
Ballgame	1860-11-09	New York	Manhattan	NY	Free Academy Club of New York	Free Academy Club of New York	13 - 5		Craig Waff
Ballgame	1857-09-22	New York	Manhattan	NY	Free Academy Club of New York	Monument Club of New York	29 - 11		Craig Waff
Ballgame	1865-10-25	New York	Manhattan	NY	Free Academy Club of New York	New York University Club of New York	35 - 11		Bob Tholkes
Ballgame	1860-06-21	New York	Manhattan	NY	Free Academy Club of New York	Free Academy Club of New York	23 - 19		Craig Waff
Ballgame	1860-11-19	New York	Manhattan	NY	Free and Easy	Columbia	17 - 6		Craig Waff
Ballgame	1859-08-25	New York	Manhattan	NY	Free and Easy	Dusty	52 - 36		Craig Waff
Ballgame	1859-11-09	New York	Manhattan	NY	Friendship Club of New York	Niagara Club of Brooklyn	16 - 29		Bob Tholkes
Ballgame	1860-06-06	New York	Manhattan	NY	Friendship Club of New York	Niagara Club of New York	33 - 23		Craig Waff
Ballgame	1857-11-26	New York	Manhattan	NY	Friendship	Independent Ex-Volunteers	31 - 26		Craig Waff
Ballgame	1864-07-11	New York	Manhattan	NY	Frontier Club of Brooklyn	Unknown Club of New York	45 - 37		Bob Tholkes
Ballgame	1864-10-03	New York	Manhattan	NY	Fulton Club of New York	Oriental Club of New York	30 - 5		Bob Tholkes
Ballgame	1860-11-20	New York	Manhattan	NY	Gazelle Club of New York	Montauk Club of New York	38 - 6		Bob Tholkes
Ballgame	1860-10-27	New York	Manhattan	NY	Gazelle Club of New York	Ringgold Club of Brooklyn	31 - 23		Bob Tholkes
Ballgame	1860-11-17	New York	Manhattan	NY	Gazelle Club of New York	Tuscarora Club of New York	29 - 7		Bob Tholkes
Ballgame	1860-09-29	New York	Manhattan	NY	Gazelle Club of New York	Tuscarora Club of New York	25 - 24		Craig Waff

Semantic search

Query log

Navigation menu

Search