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]] [[State::IL]] [[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_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=681
   AND (
   (t4.o_hash='IL') AND t4.p_id=568)
   AND (
   (t6.o_hash='United States') AND t6.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_hash, s_id_2, p_idp_id262const, const2397100.00Using index condition; Using temporary; Using filesort
1SIMPLEt6refs_id, o_hash, s_id_2, p_ids_id8protoballbetadb.t4.s_id, const121.85Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id4protoballbetadb.t4.s_id19.47Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4protoballbetadb.t4.s_id150.00Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:5
Query-Depth:1
Errors and Warnings
None
Page Date City Borough State Team 1 Team 2 Score First in Contributor
Ballgame 1868-10 Maroa IL Maroa, IL Bruce Allardice
Ballgame 1868 Naperville IL Naperville, IL Bruce Allardice
Ballgame 1871 Nauvoo IL Nauvoo, IL Bruce Allardice
Ballgame 1863-06-25 New Lenox IL New Lenox, IL Bruce Allardice
Ballgame 1859-07-04 Oak Forest IL Oak Forest, IL Bruce Allardice
Ballgame 1892 Palos Park IL Palos Park, IL Bruce Allardice
Ballgame 1878 Pingree Grove IL Pingree Grove, IL Bruce Allardice
Ballgame 1866-06-23 Quincy IL Quincy, IL Bruce Allardice
Ballgame 1888-07-21 River Grove IL River Grove, IL Bruce Allardice
Ballgame 1881 Riverdale IL Riverdale, IL Bruce Allardice
Ballgame 1877-08 South Chicago IL South Chicago, IL Bruce Allardice
Ballgame 1861-05 Springfield IL Springfield, IL Bruce Allardice
Ballgame 1863-05-27 Springfield IL Bruce Allardice
Ballgame 1876 St. Joseph IL St. Joseph, IL Bruce Allardice
Ballgame 1879 Tampico IL Tampico, IL Bruce Allardice
Ballgame 1869-07-05 Washington Heights IL Washington Heights, IL Bruce Allardice
Ballgame 1877 Watson IL Watson, IL Bruce Allardice
Ballgame 1862-07-24 Waukegan IL Waukegan, IL Bruce Allardice
Ballgame 1877 Willow Springs IL Willow Springs, IL Bruce Allardice
Ballgame 1883 Willow Springs IL Bruce Allardice
Ballgame 1866-08 Winnetka IL Winnetka, IL Bruce Allardice
Ballgame 1877-06-02 Zion IL Zion, IL Bruce Allardice
Ballgame 1889-08-25 Matteson IL John M. Smyth Furniture Club Candymakers Club Matteson, IL Bruce Allardice
Ballgame 1871-06-01 North Evanston IL Knights of St. Crispin Molders 19 - 13 North Evanston, IL Bruce Allardice
Ballgame 1867-05 Waukegan IL Lake Shore Club of Waukegan Waukegan Base Ball Club Bruce Allardice
Ballgame 1877-06-29 Effingham IL Lawyers Doctors 32 - 20 Bruce Allardice
Ballgame 1869-08 Chicago IL Lumber Inspectors Lumber Brokers 27 - 17 Bruce Allardice
Ballgame 1896 Lyons IL Lyons Club George P. Gore Co. club Lyons, IL Bruce Allardice
Ballgame 1870-08 Rockford IL Married Ladies Single Ladies 6 - 30 Bruce Allardice
Ballgame 1895-07-04 Evergreen Park IL Married Men of Evergreen Park Single Men of Evergreen Park Bruce Allardice
Ballgame 1909 Hazel Crest IL Marrieds Singles 4 - 2 Bruce Allardice
Ballgame 1867 Decatur IL McPherson Club of Decatur Excelsior Base Ball Club of Pana 20 - 58 Decatur, IL Bruce Allardice
Ballgame 1877-07-14 Orion IL Mudstrikers Club of Orion Skylifters Club of Orion 11 - 10 Orion, IL Bruce Allardice
Ballgame 1866-08-21 Springfield IL National BBC of Springfield IL Olympic BBC of Springfield IL Bruce Allardice
Ballgame 1867-08-07 Chicago IL Newspaper Reporters and Editors Printers 90 - 80 Bruce Allardice
Ballgame 1860-06-09 Chicago IL Niagara Base Ball Club of Chicago Atlantic, Jr. Club of Chicago 27 - 19 Craig Waff
Ballgame 1860-08-23 Chicago IL Niagara Base Ball Club of Chicago Excelsior Jr. Club of Chicago Craig Waff
Ballgame 1860-10-20 Chicago IL Niagara Base Ball Club of Chicago Ossawatamie Club of Chicago 28 - 11 Craig Waff
Ballgame 1867-07-04 Ottawa IL O.K. Club of Ottawa Black Crook touring company Ottawa, IL Bruce Allardice
Ballgame 1869-10-13 Quincy IL Occidental (Juniors) Club of Quincy Red Stockings Club of Cincinnati 7 - 51 Bruce Allardice
Ballgame 1865-08 Chicago IL Ogden Club of Chicago Atlantic Club of Chicago Bruce Allardice
Ballgame 1862-05-17 Peoria IL Olympic Club of Peoria Olympic Club of Peoria 39 - 39 Peoria, IL Bruce Allardice
Ballgame 1860-05-19 Chicago IL Osceola Club of Chicago Excelsior Jr. Club of Chicago Craig Waff
Ballgame 1863-09-14 Chicago IL Osceola Club of Chicago Garden City Base Ball Club of Chicago 19 - 16 Bruce Allardice
Ballgame 1863-08-21 Chicago IL Osceola Club of Chicago Garden City Base Ball Club of Chicago Bruce Allardice
Ballgame 1860-08-11 Chicago IL Osceola Club of Chicago Osceola Club of Chicago Craig Waff
Ballgame 1860-09-29 Chicago IL Osceola Jr. Club of Chicago Niagara Jr. Club of Chicago 43 - 17 Craig Waff
Ballgame 1860-07-20 Chicago IL Ossawatamie Club of Chicago Niagara Base Ball Club of Chicago 23 - 51 Craig Waff
Ballgame 1860-08-01 Chicago IL Ossawatamie Jr. Club of Chicago Wide Awake Sr. Club of Chicago 62 - 12 Craig Waff
Ballgame 1865-11-16 Chicago IL Pacific Club of Chicago Excelsior Club of Chicago 19 - 15 Bob Tholkes