Semantic search

Jump to navigation Jump to search
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
Debug output SQLStore
ASK Query
[[Category:Ballgames]] [[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_wikipage` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `smw_di_blob` AS t7 ON t2.s_id=t7.s_id
INNER JOIN
  `smw_di_blob` AS t9 ON t2.s_id=t9.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=681
   AND (t4.p_id=18595 AND t4.o_id=19149)
   AND (
   (t7.o_hash='NY') AND t7.p_id=568)
   AND (
   (t9.o_hash='United States') AND t9.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
  100
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, const1010100.00Using temporary; Using filesort
1SIMPLEt7refs_id, o_hash, s_id_2, p_ids_id8protoballdb.t4.s_id, const15.00Using where
1SIMPLEt9refs_id, o_hash, s_id_2, p_ids_id8protoballdb.t4.s_id, const124.62Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4protoballdb.t4.s_id150.00Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id4protoballdb.t4.s_id19.88Using where; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:7
Query-Depth:1
Errors and Warnings
None
Page Date City Borough State Team 1 Team 2 Score First in Contributor
Ballgame 1858-06-19 New York Manhattan NY Champion Club of Yorkville, NYC Young America Club of Harlem 37 - 17 Craig Waff
Ballgame 1858-09-25 New York Manhattan NY Champion Club of Yorkville, NYC Young America Club of Harlem 24 - 18 Craig Waff
Ballgame 1859-08-20 New York Manhattan NY Champion Club of New York Enterprise Club of Brooklyn 21 - 8 Craig Waff
Ballgame 1859-08-10 New York Manhattan NY Charter Oak Club of Brooklyn Excelsior Club of Brooklyn 25 - 22 Craig Waff
Ballgame 1859-10-07 New York Manhattan NY Charter Oak Club of Brooklyn Manhattan Club of New York 14 - 17 Bob Tholkes
Ballgame 1859-11-21 New York Manhattan NY Charter Oak Club of New York Eagle Jr. Club of New York 38 - 28 Bob Tholkes
Ballgame 1858-09-30 New York Manhattan NY Charter Oak Club of Brooklyn Esculapian Club of Brooklyn 37 - 22 Craig Waff
Ballgame 1858-11-18 New York Manhattan NY Charter Oak Excelsior Craig Waff
Ballgame 1858-11-18 New York Manhattan NY Charter Oak Club of Brooklyn Independent Base Ball Club of Brooklyn 23 - 7 Craig Waff
Ballgame 1864-10-08 New York Manhattan NY Chatham Club of New York Lenord Club of New York 35 - 24 Bob Tholkes
Ballgame 1861-08-13 New York Manhattan NY Chieftain Underhill 33 - 13 Craig Waff
Ballgame 1858-11-01 New York Manhattan NY Cinderella Club of Brooklyn Pastime Jr. Club of Brooklyn 17 - 4 Craig Waff
Ballgame 1858-11-27 New York Manhattan NY Clayton Club of Hoboken Independent Club of New York 34 - 20 Craig Waff
Ballgame 1860-10-17 New York Manhattan NY Clifton Club of Staten Island St. George’s Cricket Club 24 - 7 Craig Waff
Ballgame 1858-11-18 New York Manhattan NY Clifton Club of Brooklyn Mohawk Club of Brooklyn 18 - 15 Craig Waff
Ballgame 1865-07-04 New York Manhattan NY Clinton Club of New York Amity Club of New York 37 - 40 Bob Tholkes
Ballgame 1861-11-30 New York Manhattan NY Clinton Club of New York Baltic Club of New York 15 - 19 Bob Tholkes
Ballgame 1857-10-17 New York Manhattan NY Clinton Club of New York Eureka Club of New York Craig Waff
Ballgame 1861-12-14 New York Manhattan NY Clinton Baltic 25 - 19 Craig Waff
Ballgame 1859-06-11 New York Manhattan NY Clinton Jr. Club of Brooklyn Nassau Club of Brooklyn 19 - 14 Craig Waff
Ballgame 1864-08-17 New York Manhattan NY Newark Club Union Club of Morrisania 10 - 5 Bob Tholkes
Ballgame 1855-11-29 New York Manhattan NY Columbia Club of Brooklyn Columbia Club of Brooklyn Craig Waff
Ballgame 1856-09-20 New York Manhattan NY Columbia Club of New York Union Craig Waff
Ballgame 1865-07-04 New York Manhattan NY Columbus Club of New York Amity Club of New York 14 - 31 Bob Tholkes
Ballgame 1861-10-23 New York Manhattan NY Constellation Club of Brooklyn Active Base Ball Club of New York 12 - 9 Craig Waff
Ballgame 1860-11-08 New York Manhattan NY Constellation Club of Mott Haven Buena Club of Mott Haven 19 - 9 Craig Waff
Ballgame 1859-06-04 New York Manhattan NY Contest Club of Brooklyn Nassau Club of Brooklyn 19 - 10 Craig Waff
Ballgame 1858-10-04 New York Manhattan NY Contest Club of Brooklyn Superior Club of Brooklyn 30 - 17 Craig Waff
Ballgame 1858-06-19 New York Manhattan NY Contest Club of Brooklyn Young America Club of New York 31 - 17 Craig Waff
Ballgame 1858-06-02 New York Manhattan NY Continental Club of Brooklyn Washington Club of Brooklyn 25 - 13 Craig Waff
Ballgame 1860-06-06 New York Manhattan NY Continental Club of Brooklyn Champion Club of Yorkville, NYC 29 - 22 Craig Waff
Ballgame 1858-11-10 New York Manhattan NY Continental Club of Brooklyn Eckford Club of Brooklyn 26 - 27 Eric Miklich
Ballgame 1858-07-08 New York Manhattan NY Continental Club of Brooklyn Metropolitan Club of New York 32 - 25 Craig Waff
Ballgame 1857-08-27 Harlem Manhattan NY Continental Club of Brooklyn Baltic Club of New York 32 - 24 Craig Waff
Ballgame 1856-10-08 Harlem Manhattan NY Continental Club of Brooklyn Harlem Club of New York 21 - 13 Craig Waff
Ballgame 1858-08-31 New York Manhattan NY Continental Olympic Craig Waff
Ballgame 1865-09-29 New York Manhattan NY Crescent Club of Brooklyn Putnam Club of New York Bob Tholkes
Ballgame 1859-11-26 New York Manhattan NY Crescent Jr. Club of Flushing Union Club of New York 55 - 8 Craig Waff
Ballgame 1858-10-27 New York Manhattan NY Croton Club of New York Una Club of Brooklyn Craig Waff
Ballgame 1859-05-08 New York Manhattan NY Croton Club of New York Neptune Club of Brooklyn 24 - 21 Craig Waff
Ballgame 1859-09-01 New York Manhattan NY Crystal Club of Brooklyn Wild Wave Club of Brooklyn 28 - 8 Craig Waff
Ballgame 1865-11-08 New York Manhattan NY Crystal Club of New York Forsyth Club of New York 12 - 7 Bob Tholkes
Ballgame 1865-11-15 New York Manhattan NY Crystal Club of New York Muffin Club of New York Bob Tholkes
Ballgame 1859-09-29 New York Manhattan NY Crystal Club of Brooklyn Lone Star Club of Brooklyn 20 - 15 Craig Waff
Ballgame 1860-08-29 New York Manhattan NY Defiance Club of New York Aurora Club of Brooklyn 10 - 24 Bob Tholkes
Ballgame 1860-08-24 New York Manhattan NY Defiance Club of New York Eckford Jr. Club of Brooklyn 23 - 17 Craig Waff
Ballgame 1860-09-18 New York Manhattan NY Defiance Club of New York Lone Star Club of New York 30 - 18 Bob Tholkes
Ballgame 1860-10-20 New York Manhattan NY Defiance Club of New York Seneca Club of New York 31 - 13 Bob Tholkes
Ballgame 1860-08-21 New York Manhattan NY Defiance Club of New York Unknown Club of New York 10 - 33 Bob Tholkes
Ballgame 1860-10-19 New York Manhattan NY Delta Club of New York Columbia Club of Brooklyn 5 - 8 Bob Tholkes