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::MA]] [[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='MA') 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
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4refs_id, o_hash, s_id_2, p_idp_id262const, const1821100.00Using index condition; Using temporary; Using filesort
1SIMPLEt6refs_id, o_hash, s_id_2, p_ids_id8protoballdb.t4.s_id, const124.63Using 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_id130.96Using where; Distinct
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 Club of Mansfield 1859 Mansfield MA Bruce Allardice
American Club of Sandwich 1867 Sandwich MA Bruce Allardice
American Club of South Dedham 1858 Dedham MA Dedham, MA Bruce Allardice
Amherst College Club of Amherst 1859 Amherst MA Amherst, MA Bruce Allardice
Anawan Base Ball Club of Mansfield 1866-08-04 Mansfield MA Paul Johnson
Anawan Club of Fall River 1866-07 Fall River MA Fall River, MA Bruce Allardice
Anawan Club of Mansfield 1858-07-07 Mansfield MA Mansfield, MA Bruce Allardice
Anawan Club of New Bedford 1867-09-14 New Bedford MA Kyle DeCicco-Carey
Anderson Club of Lynn 1868 Lynn MA Bruce Allardice
Anonymous Club of Haverhill 1868 Haverhill MA Bruce Allardice
Aquila Club of Boston 1866 Boston MA Bruce Allardice
Aquila Club of Lexington 1867-07-04 Lexington MA Brian Sheehy
Archon Club of Stoughton 1868 Stoughton MA Bruce Allardice
Arctic Club of Boston 1868 Boston MA Bruce Allardice
Arctic Club of Chelsea 1868 Chelsea MA Bruce Allardice
Arctic Club of East Woburn 1868 Woburn MA Bruce Allardice
Assawampsett Club of Middelborough Academy and High School 1867 Abington MA Bruce Allardice
Atalanta Club of Boston 1859 Boston MA Bruce Allardice
Atalanta Club of Stoneham 1866 Stoneham MA Bruce Allardice
Athletic Club of Grafton 1870 Grafton MA Bruce Allardice
Athletic Club of New Bedford 1867-10-25 New Bedford MA Kyle DeCicco-Carey
Athletic Club of Newburyport 1869 Newburyport MA Bruce Allardice
Athletic Jr. Club of Cambridge 1868 Cambridge MA Bruce Allardice
Athletics Club of Boston 1866 Boston MA Bruce Allardice
Athletics of North Adams 1870 North Adams MA Larry Moore
Atlanta Club of Waltham 1870 Waltham MA Bruce Allardice
Atlanta Club of Watertown 1866 Watertown MA Watertown, MA Bruce Allardice
Atlantic Club of Beverly 1867 Beverly MA Bruce Allardice
Atlantic Club of Clinton, MA 1868 Clinton MA Bruce Allardice
Atlantic Club of East Hampton 1863 East Hampton MA Bob Tholkes
Atlantic Club of Lawrence 1867 Lawrence MA Bruce Allardice
Atlantic Club of New Bedford 1867-09-02 New Bedford MA Kyle DeCicco-Carey
Atlantic Club of Springfield 1867 Springfield MA Bruce Allardice
Atlantic Club of Stoneham 1868 Stoneham MA Bruce Allardice
Atlantic Club of Tapleyville 1868 Danvers MA Bruce Allardice
Atlantic Jr. Club of Boston 1865 Boston MA Bruce Allardice
Atwater Club of Westfield, MA 1858-06-01 Westfield MA Westfield, MA Eric Miklich
Aurora Ball Club of Boston 1853-07 Boston MA Bruce Allardice
Aurora Club of Chelsea 1870 Chelsea MA Bruce Allardice
Aurora Club of New Bedford 1869 New Bedford MA Bruce Allardice
Bachelors Club of Pittsfield 1870 Pittsfield MA Bruce Allardice
Baltic Club of Boston 1866 Boston MA Bruce Allardice
Bankers Club of Boston 1866-06-20 Boston MA Bruce Allardice
Bay State Club I of New Bedford 1867-08-12 New Bedford MA Kyle DeCicco-Carey
Bay State Club II of New Bedford 1867-10-11 New Bedford MA Kyle DeCicco-Carey
Bay State Club of Boston 1856 Boston MA Bruce Allardice
Bay State Club of Farnumsville 1867 Farnumsville MA Farnumsville, MA Bruce Allardice
Bay State Club of Lynn 1868 Lynn MA Bruce Allardice
Bay State Club of Northampton 1860 Northampton MA Bruce Allardice
Bay State Club of Roxbury 1867 Roxbury MA Bruce Allardice