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:Clubs||Ballgames]] [[First in Location::+]] [[Borough::+]]
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_wikipage` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   (t2.o_id=7808 OR t2.o_id=681)
   AND (t4.p_id=10779)
   AND (t7.p_id=18595)
  )
  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
1SIMPLEt7refs_id, p_id, s_id_2, s_id_3p_id4const5472100.00Using index; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4protoballdb.t7.s_id150.00Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id4protoballdb.t7.s_id140.94Using where; Distinct
1SIMPLEt4refs_id, p_id, s_id_2, s_id_3s_id_38protoballdb.t7.s_id, const1100.00Using index; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
Type / Page Club / Match Date City Borough State First in
Club Liberty Club of Nyack 1866 Nyack Rockland County NY Nyack, NY
Club Lone Star Club of Garnerville 1868 Garnerville Rockland County NY Garnerville, NY
Club Lone Star Club of Melrose 1860-06-03 Melrose The Bronx NY Melrose, NY
Ballgame Mattano Club of Astoria v Crescent Club of Flushing 19 - 26 1859-09-10 Astoria Queens NY Astoria, NY
Ballgame Mazeppa Club of White Plains v National Club of White Plains 49 - 18 1860-06-23 White Plains Westchester County NY White Plains, NY
Club Meitawak Club of Flatbush 1859-11-06 Flatbush Brooklyn NY Flatbush, NY
Club Metamora Club of Fordham 1859-05-29 Fordham The Bronx NY Fordham, NY
Club Minnisceongo Club of Haverstraw 1870 Haverstraw Rockland County NY Haverstraw, NY
Club Momoweta Club of Greenport 1867 Greenport Suffolk County NY Greenport, NY
Club Moneka Club of Sag Harbor 1867 Sag Harbor Suffolk County NY Sag Harbor, NY
Club Monitor Club of Cedar Grove 1867-09-11 Cedar Grove Essex County NJ Cedar Grove, NJ
Club Mt. Hermon Club of Tottenville 1867 Tottenville Staten Island NY Tottenville, NY
Club Mutual Club of White Plains 1860 White Plains Westchester County NY White Plains, NY
Club Mutuals Club of Cranbury 1867-06-27 Cranbury Middlesex County NJ Cranbury, NJ
Club National Club of Farmingdale 1867 Farmingdale Nassau County NY Farmingdale, NY
Club Neosho Club of New Utrecht 1859-05-29 New Utrecht Brooklyn NY New Utrecht, NY
Club Newark Club 1855-06-16 Newark Essex County NJ Newark, NJ
Club Nonpareil Club of City Island 1865-09 City Island The Bronx NY City Island, NY
Club Norwood Club of Norwood 1870-08-26 Norwood Bergen County NJ Norwood, NJ
Club Ocean Club of Rockaway 1867 Rockaway Queens NY Rockaway, NY
Club Oriental Club of Rye 1868 Rye Westchester County NY Rye, NY
Club Oriental Club of Upper Piermont 1868 Upper Piermont Rockland County NY Upper Piermont, NY
Club Orientals Club of Montclair 1866-06-11 Montclair Essex County NJ Montclair, NJ
Club Our Own Club of East New York 1860-07-08 East New York Brooklyn NY East New York, NY
Club Pacific Club of South Amboy 1866-08-09 South Amboy Middlesex County NJ South Amboy, NJ
Club Passaic Club of Belleville 1860-07-07 Belleville Essex County NJ Belleville, NJ
Ballgame Passaic Club of Passaic v Alert Club of Paterson 30 - 45 1867-06-10 Passaic Passaic County NJ Passaic, NJ
Ballgame Pastime Club of Brooklyn v Neosho Club of New Utrecht 40 - 17 1859-07-14 New Utrecht Brooklyn NY New Utrecht, NY
Club Pastimes Club of High Bridge 1870 High Bridge The Bronx NY High Bridge, NY
Club Pavonia Club of Jersey City 1855-07-15 Jersey City Hudson County NJ Hudson County
Club Pioneer Club of Allendale 1870-06-27 Allendale Bergen County NJ Allendale, NJ
Club Pioneer Club of Sloatsburg 1869 Sloatsburg Rockland County NY Sloatsburg, NY
Club Pomona Club of New Brighton 1866 New Brighton Staten Island NY New Brighton, NY
Club Quickstep Club of Bergen 1859-08-11 Bergen Hudson County NJ Bergen, NJ
Club Quickstep Club of Lafayette 1861-10-28 Lafayette Hudson County NJ Lafayette, NJ
Club Quickstep Club of Tomkinsville 1859-06-19 Staten Island Staten Island NY Staten Island
Ballgame Quickstep Club of Tomkinsville v Unknown 1859-09-15 Staten Island Staten Island NY Staten Island
Club Rahway City Club of Rahway 1858-11-09 Rahway Union County NJ Rahway, NJ
Club Resolute (Jr.) Club of Greenville 1860-08-03 Greenville Hudson County NJ Greenville, NJ
Ballgame Resolute (Jr.) Club of Greenville v Mechanics Club of Jersey City 39 - 34 1860-08-16 Greenville Hudson County NJ Greenville, NJ
Club Rhakahova Club of Perth Amboy 1864-06-02 Perth Amboy Middlesex County NJ Perth Amboy, NJ
Club Riverside Club of Montrose 1870 Montrose Westchester County NY Montrose, NY
Club Star Base Ball Club of Sing Sing (Ossining) 1857-11-19 Ossining Westchester County NY Westchester County
Club Star Club of Creskill 1866-08-07 Creskill Bergen County NJ Creskill, NJ
Club Star Club of Pleasantville 1868 Pleasantville Westchester County NY Pleasantville, NY
Club Star Club of Riverdale 1867 Riverdale The Bronx NY Riverdale, NY
Club Suffolk Club of Babylon 1858 Babylon Suffolk County NY Suffolk County
Club Suffolk Club of Huntington 1867 Huntington Suffolk County NY Huntington, NY
Club Suffolk Club of Patchogue 1860 Patchogue Suffolk County NY Patchogue, NY
Ballgame Suffolk Club of Patchogue v Lafayette Club of Hempstead 10 - 30 1860-11-01 Patchogue Suffolk County NY Suffolk County