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
  • The part "]]" of the query was not understood. Results might not be as expected.
  • Some subquery has no valid condition.
Debug output SQLStore
ASK Query
[[Category:Ballgames]]
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 t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.o_id=681)
  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
1SIMPLEt1refs_id, o_id, s_id_2, o_id_2o_id5const7545100.00Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4protoballdb.t1.s_id150.00Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
The part "]]" of the query was not understood. Results might not be as expected.
Some subquery has no valid condition.
Page Date City Borough State Team 1 Team 2 Score First in Contributor
Ballgame 1865-05-05 Philadelphia PA Active Club of Philadelphia Satterlee Club of Philadelphia 30 - 14 Bob Tholkes
Ballgame 1864-09-21 Portland ME Active Club of Portland Osceola Club of Portland 13 - 11 Bruce Allardice
Ballgame 1864-08-31 Troy NY Active Club of Troy Union Club of Lansingburgh Bruce Allardice
Ballgame 1865-05-13 Utica NY Active Club of Utica Clipper Club of Clinton 16 - 23 Bob Tholkes
Ballgame 1865-05-27 Utica NY Active Club of Utica Eckford Club of Utica 7 - 21 Bob Tholkes
Ballgame 1864-10-01 Utica NY Active Club of Utica Empire Club of Whitestown 18 - 7 Bob Tholkes
Ballgame 1865-10-24 Washington DC Active Club of Washington American Club of Washington 21 - 7 Bruce Allardice
Ballgame 1865-11-27 Washington DC Active Club of Washington Olympic Club of Washington 23 - 16 Bob Tholkes
Ballgame 1865-11-14 Washington DC Active Club of Washington Waverly Club of Washington 29 - 17 Bruce Allardice
Ballgame 1865-10-05 Washington DC Active Club of Washington Waverly Club of Washington 38 - 27 Bruce Allardice
Ballgame 1865-12-07 Washington DC Active Club of Washington Waverly Club of Washington 52 - 14 Bruce Allardice
Ballgame 1860-09-05 Brooklyn Brooklyn NY Active Club of Brooklyn Clifton Club of Brooklyn 14 - 9 Craig Waff
Ballgame 1860-11-17 West Troy NY Active Excelsior Club of West Troy 22 - 20 Craig Waff
Ballgame 1861-10-19 New York Manhattan NY Active Mount Vernon 30 - 12 Craig Waff
Ballgame 1874-06-07 Fort Lincoln ND Actives Club of Fort Lincoln 'A picked nine' 17 - 10 Fort Lincoln, ND Bruce Allardice
Ballgame 1874-07-31 SD Actives Benteens 11 - 6 Terry Bohn
Ballgame 1865-10-04 Philadelphia PA Adelphi Club of Philadelphia Quickstep Club of Philadelphia 34 - 22 Bob Tholkes
Ballgame 1865-10-05 Gloucester NJ Adelphi Club of Philadelphia Quickstep Club of Philadelphia 37 - 22 Gloucester, NJ Bob Tholkes
Ballgame 1863-10-30 Brooklyn Brooklyn NY Adriatic Club of Brooklyn Americus Club of New York 15 - 24 Bob Tholkes
Ballgame 1863-09-10 Brooklyn Brooklyn NY Adriatic Club of Brooklyn Bergen Club of Brooklyn 21 - 6 Bob Tholkes
Ballgame 1863-08-06 Brooklyn Brooklyn NY Adriatic Club of Brooklyn Ironside Club of Brooklyn 23 - 12 Bob Tholkes
Ballgame 1860-08-11 Adriatic Club of Brooklyn Mystic Club of New York 21 - 18 Bob Tholkes
Ballgame 1865-10-05 Mott Haven The Bronx NY Adriatic Club of Mott Haven Arctic Club of West Farms 24 - 18 Bob Tholkes
Ballgame 1865-10-10 Mott Haven The Bronx NY Adriatic Club of Mott Haven Central Club of Brooklyn 27 - 25 Bob Tholkes
Ballgame 1865-09-16 NY Adriatic Club of Mott Haven Clinton Club of New York 37 - 29 Bob Tholkes
Ballgame 1865-09-01 NY Adriatic Club of Mott Haven Pathfinder Club of West Farms 20 - 27 Bob Tholkes
Ballgame 1861-09-26 Mott Haven The Bronx NY Adriatic Club of Mott Haven Unknown Club of New York 18 - 20 Bob Tholkes
Ballgame 1860-08-15 Jersey City Hudson County NJ Adriatic Club of Newark Hamilton Club of Jersey City 31 - 19 Craig Waff
Ballgame 1859-09-28 Elizabeth Union County NJ Adriatic Club of Newark Live Oak Club of Orange 16 - 15 Elizabeth, NJ Craig Waff
Ballgame 1858-09-09 Newark Essex County NJ Adriatic Club of Newark Lone Star Club of Jersey City 42 - 19 Craig Waff
Ballgame 1861-07-11 Newark Essex County NJ Adriatic Club of Newark Newark Club 11 - 25 Bob Tholkes
Ballgame 1857-09-10 Newark Essex County NJ Adriatic Club of Newark Newark Club 24 - 8 Craig Waff
Ballgame 1857-07-27 Newark Essex County NJ Adriatic Club of Newark Newark Club 20 - 18 Craig Waff
Ballgame 1859-08-01 Bedford, Long Island Brooklyn NY Adriatic Club of Newark Pastime Club of Brooklyn 14 - 10 Craig Waff
Ballgame 1858-10-28 Brooklyn Brooklyn NY Adriatic Club of Newark Pastime Club of Brooklyn 45 - 13 Craig Waff
Ballgame 1858-10-08 Newark Essex County NJ Adriatic Club of Newark Pastime Club of Brooklyn 45 - 13 Craig Waff
Ballgame 1858-11-14 Newark Essex County NJ Adriatic Club of Newark Pioneer Club of Orange 43 - 20 Bob Tholkes
Ballgame 1860-07-31 Newark Essex County NJ Adriatic Club of Newark Union Club of Morrisania Craig Waff
Ballgame 1862-06-20 Philadelphia PA Adriatic Club of Philadelphia Keystone Club of Philadelphia 41 - 18 Bruce Allardice
Ballgame 1865-10-14 Philadelphia PA Adriatic Club of Philadelphia United Club of Philadelphia Bob Tholkes
Ballgame 1865-09-15 Hoboken Hudson County NJ Adriatic Club Defiance Club of New York 46 - 6 Bob Tholkes
Ballgame 1865-10-18 New York Manhattan NY Adriatic Club Putnam Club of New York 14 - 19 Bob Tholkes
Ballgame 1865-09-28 NY Adriatic Club Unity Club 40 - 10 Bob Tholkes
Ballgame 1858-10-09 Newark Essex County NJ Adriatic Jr/Niagara Club of Newark Arctic Club of Brooklyn 25 - 14 Craig Waff
Ballgame 1860-08-07 Brooklyn Brooklyn NY Adriatic Club of Brooklyn Free and Easy Club of Brooklyn 34 - 24 Craig Waff
Ballgame 1865-09-16 Brooklyn Brooklyn NY Aetna Club of Brooklyn Union Club of Brooklyn 65 - 16 Bob Tholkes
Ballgame 1865-06-01 South Orange Essex County NJ Aetna Club of Jersey City Alert Club of Seton Hall of South Orange 11 - 38 Bob Tholkes
Ballgame 1867-06-10 Jersey City Hudson County NJ Aetna Club of Jersey City Mystic Club of Paterson 66 - 18 John Zinn
Ballgame 1865-09-30 New Haven CT Agallian Club of Middletown Yale University Club of New Haven 13 - 39 Bob Tholkes
Ballgame 1865-09-16 Philadelphia PA Agile Club of Philadelphia Alert Jr. Club of Philadelphia 51 - 11 Bob Tholkes