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]] [[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_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=7808
   AND (
   (t4.o_hash='NY') 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
1SIMPLEt6refs_id, o_hash, s_id_2, p_ido_hash258const460681.47Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt4refs_id, o_hash, s_id_2, p_ids_id8protoballdb.t6.s_id, const15.00Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id4protoballdb.t6.s_id131.09Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4protoballdb.t6.s_id150.00Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:5
Query-Depth:1
Errors and Warnings
None
Club Date City Borough State First in Contributor
American Base Ball Club of Brooklyn 1858-07-19 Brooklyn Brooklyn NY Eric Miklich
American Club of Buffalo 1856 Buffalo NY Bruce Allardice
American Club of New York 1859-07-24 New York Manhattan NY Richard Hershberger
American Eagle Club of Brooklyn 1858-09-10 Brooklyn Brooklyn NY Bruce Allardice
American Star Club of Brooklyn 1859 Brooklyn Brooklyn NY Bruce Allardice
Americus Club of Brooklyn 1858 Brooklyn Brooklyn NY Bob Tholkes
Americus Club of New York 1859-05-22 New York Manhattan NY Richard Hershberger
Americus Club of Tremont 1868-08-23 Tremont The Bronx NY Gregory Christiano
Amity Club of New York 1859-04-24 New York Manhattan NY Richard Hershberger
Amity Club of South Brooklyn 1859-09-04 Brooklyn Brooklyn NY Richard Hershberger
Anacreon Club of Whitesboro Seminary 1864 Whitesboro NY Bruce Allardice
Ancient City Club of Schenectady 1868 Schenectady NY Bruce Allardice
Anderson Club of Mott Haven 1866 Mott Haven The Bronx NY Bruce Allardice
Antiques Club of Troy 1867 Troy NY Bruce Allardice
Apollo Club of Brooklyn 1860-11-18 Brooklyn Brooklyn NY Richard Hershberger
Apollo Club of New York 1860-10-07 New York Manhattan NY Richard Hershberger
Aquehonga Base Ball Club of Tomkinsville 1860 Staten Island Staten Island NY Ralph Carhart
Arab Club of Whitehall 1867 Whitehall NY Bruce Allardice
Arcadia (Sr.) Club of Williamsburg 1860-09-16 Williamsburg Brooklyn NY Richard Hershberger
Arcadia Club of Williamsburg 1860-07-15 Williamsburg Brooklyn NY Richard Hershberger
Arcanum Club of New York 1866 New York Manhattan NY Bruce Allardice
Arcola Club of New York 1866 New York Manhattan NY Bruce Allardice
Arctic Club of Albany 1866 Albany NY Bruce Allardice
Arctic Club of Brooklyn 1857-11-26 Brooklyn Brooklyn NY Craig Waff
Arctic Club of Buffalo 1866 Buffalo NY Bruce Allardice
Arctic Club of East Brooklyn 1859-04-24 Brooklyn Brooklyn NY Richard Hershberger
Arctic Club of Fordham 1860-09-09 Fordham The Bronx NY Richard Hershberger
Arctic Club of Goshen 1866 Goshen NY Bruce Allardice
Arctic Club of Greenwich 1867 Greenwich NY Greenwich, NY Bruce Allardice
Arctic Club of New Rochelle 1870 New Rochelle Westchester County NY Bruce Allardice
Arctic Club of New York 1859-12-18 New York Manhattan NY Richard Hershberger
Arctic Club of Springfield, NY 1866 Springfield NY Springfield, NY Bruce Allardice
Arctic Club of Syracuse 1866 Syracuse NY Bruce Allardice
Arctic Club of West Farms 1860-09-30 West Farms The Bronx NY Richard Hershberger
Arctic Jr. Club of Brooklyn 1858-09-17 Brooklyn Brooklyn NY Bruce Allardice
Argus Club of Albany 1867 Albany NY Bruce Allardice
Arion Base Ball and Social Club of New York 1864 New York Manhattan NY Bruce Allardice
Arlington Club of Brooklyn 1866 Brooklyn Brooklyn NY Bruce Allardice
Arlington Jr. Club of Melrose 1869-11-06 Melrose The Bronx NY Gregory Christiano
Armenia Club of Ellenville 1867 Ellenville NY Ellenville, NY Bruce Allardice
Armenia Club of New York 1866 New York Manhattan NY Bruce Allardice
Armenia Club of Yonkers 1859-11-20 Yonkers Westchester County NY Richard Hershberger
Armory Club of Ilion 1867 Ilion NY Ilion, NY Bruce Allardice
Arnold Club of Hoosick Falls 1867 Hoosick Falls NY Bruce Allardice
Arsenal Club of Brooklyn 1866 Brooklyn Brooklyn NY Bruce Allardice
Artisan Club of New York 1860-08-12 New York Manhattan NY Richard Hershberger
Ashland Club of New York 1859-10-02 New York Manhattan NY Richard Hershberger
Astoria Club of Brooklyn 1855-07-07 Brooklyn Brooklyn NY Richard Hershberger
Astors Club of Brooklyn 1858 Brooklyn Brooklyn NY Bruce Allardice
Atalanta Club of New York 1865 New York Manhattan NY Bob Tholkes