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::NJ]] [[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='NJ') 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
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4refs_id, o_hash, s_id_2, p_idp_id262const, const2633100.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
Academy Club of Trenton 1865 Trenton NJ Bob Tholkes
Active Club of Belleville 1867-09-12 Belleville Essex County NJ John Zinn
Active Club of Burlington 1865-12-16 Burlington NJ Burlington, NJ
Active Club of Elizabeth 1861 Elizabeth Union County NJ Bruce Allardice
Active Club of Hackettstown 1866-09-13 Hackettstown NJ Hackettstown, NJ John Zinn
Active Club of Hampton Junction, NJ 1868-07-31 Hampton NJ Hampton, NJ
Active Club of Hoboken 1870-05-18 Hoboken Hudson County NJ John Zinn
Active Club of Hudson City 1866-06-27 Hudson City Hudson County NJ John Zinn
Active Club of Jersey City 1865-07-11 Jersey City Hudson County NJ John Zinn
Active Club of Lafayette 1870-05-18 Jersey City Hudson County NJ John Zinn
Active Club of Little Falls 1868-08-24 Little Falls NJ John Zinn
Active Club of Newark 1863-10-03 Newark Essex County NJ John Zinn
Active Club of Newton 1867-08-08 Newton NJ John Zinn
Active Club of Paterson 1864-08-22 Paterson Passaic County NJ John Zinn
Active Club of Summit 1867-07-25 Summit Union County NJ Summit, NJ John Zinn
Active Club of Verona 1869-07-22 Verona NJ John Zinn
Active Club of Washington, NJ 1866-09-07 Washington NJ John Zinn
Active Junior Club of Newark 1867-07-20 Newark Essex County NJ John Zinn
Adelphia Club of Bloomfield 1870-07-20 Belleville Essex County NJ John Zinn
Adriatic Club of Hudson City 1868-08-08 Hudson City Hudson County NJ John Zinn
Adriatic Club of Newark 1859-07-24 Newark Essex County NJ Richard Hershberger
Adriatic Club of South Amboy 1866-09-13 South Amboy Middlesex County NJ John Zinn
Adriatic Jr/Niagara Club of Newark 1857-10-20 Newark Essex County NJ John Zinn
Adriatics Club of Irvington 1866-06-20 Irvington Essex County NJ John Zinn
Advance Club of New Brunswick 1869-08-17 New Brunswick Middlesex County NJ John Zinn
Advance Club of Trenton 1867-09-17 Trenton NJ John Zinn
Advance Junior of New Brunswick 1869-09-29 New Brunswick Middlesex County NJ John Zinn
Aeolians Club of Newark 1867-07-02 Newark Essex County NJ John Zinn
Aerial Club of Jersey City 1870-05-27 Jersey City Hudson County NJ
Aetna Club II of Jersey City 1867 Jersey City Hudson County NJ John Zinn
Aetna Club of Bergen 1869-08-17 Bergen Hudson County NJ John Zinn
Aetna Club of Elizabeth 1860-07-22 Elizabeth Union County NJ Richard Hershberger
Aetna Club of Jersey City 1860-06-23 Jersey City Hudson County NJ John Zinn
Aetna Club of Newark 1866-06-16 Newark Essex County NJ John Zinn
Aetna Club of Union Hill 1868-09-29 Union Hill NJ Union Hill, NJ John Zinn
Alert Club of Belleville 1869-06-14 Belleville Essex County NJ John Zinn
Alert Club of Belleville3 1869-06-14 Belleville Essex County NJ
Alert Club of East Orange 1870-07-11 East Orange Essex County NJ John Zinn
Alert Club of English Neighborhood 1866-09-14 English Neighborhood Bergen County NJ English Neighborhood, NJ John Zinn
Alert Club of Greenville, NJ 1868-08-03 Greenville Hudson County NJ John Zinn
Alert Club of Hackensack 1868-08-07 Hackensack Bergen County NJ John Zinn
Alert Club of Hudson City 1865-10-11 Hudson City Hudson County NJ John Zinn
Alert Club of Irvington 1861-07-17 Irvington Essex County NJ John Zinn
Alert Club of Jamesburg 1868-06-18 Jamesburg Middlesex County NJ Jamesburg, NJ John Zinn
Alert Club of Jersey City 1857-09-19 Jersey City Hudson County NJ John Zinn
Alert Club of Newark 1865-09-08 Newark Essex County NJ John Zinn
Alert Club of Paterson 1866-09-23 Paterson Passaic County NJ Bruce Allardice
Alert Club of Seton Hall of South Orange 1864-03-21 South Orange Essex County NJ South Orange, NJ John Zinn
Alert Jr. Club of Camden 1865 Camden NJ Bruce Allardice
Alert Juniors Club of Elizabeth 1869-08-20 Elizabeth Union County NJ John Zinn