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]] [[Borough::Hudson County]] [[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_wikipage` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `smw_di_blob` AS t7 ON t2.s_id=t7.s_id
INNER JOIN
  `smw_di_blob` AS t9 ON t2.s_id=t9.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=7808
   AND (t4.p_id=18595 AND t4.o_id=18596)
   AND (
   (t7.o_hash='NJ') AND t7.p_id=568)
   AND (
   (t9.o_hash='United States') AND t9.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_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id_39const, const1135100.00Using temporary; Using filesort
1SIMPLEt7refs_id, o_hash, s_id_2, p_ids_id8protoballdb.t4.s_id, const15.00Using where
1SIMPLEt9refs_id, o_hash, s_id_2, p_ids_id8protoballdb.t4.s_id, const122.73Using 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_id131.08Using where; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:7
Query-Depth:1
Errors and Warnings
None
Club Date City Borough State First in Contributor
Hibernian Club of Jersey City 1870-08-05 Jersey City Hudson County NJ John Zinn
Hoboken Club of Hoboken 1859-06-20 Hoboken Hudson County NJ John Zinn
Hope Club of Hoboken 1868-08-17 Hoboken Hudson County NJ John Zinn
Hudson Club of East Newark 1868-08-20 East Newark Hudson County NJ John Zinn
Hudson Club of Hoboken 1857-11-21 Hoboken Hudson County NJ John Zinn
Hudson Club of Hudson City 1866-06-18 Hudson City Hudson County NJ John Zinn
Hudson Club of Jersey City 1859-05-28 Jersey City Hudson County NJ John Zinn
Hunkey Dorey Club of Jersey City 1865-07-15 Jersey City Hudson County NJ John Zinn
Idler Club of Jersey City 1870-08-20 Jersey City Hudson County NJ John Zinn
Independent Club of Jersey City 1859-08-16 Jersey City Hudson County NJ John Zinn
Iola Club of Jersey City 1867-11-11 Jersey City Hudson County NJ John Zinn
Ivanhoe Club of Jersey City 1870-05-31 Jersey City Hudson County NJ John Zinn
Jackson Club of Jersey City 1866-07-06 Jersey City Hudson County NJ John Zinn
Jefferson Club of Hoboken 1859-08-09 Hoboken Hudson County NJ John Zinn
Jefferson Club of Hudson City 1870-06-06 Hudson City Hudson County NJ John Zinn
Jefferson Club of Jersey City 1868-08-25 Jersey City Hudson County NJ John Zinn
Jersey Lightning Club of Jersey City 1869-08-02 Hudson City Hudson County NJ John Zinn
Juniata Club of Hoboken 1860-06-10 Hoboken Hudson County NJ Richard Hershberger
Kearsarge Club of Hoboken 1864 Hoboken Hudson County NJ Bruce Allardice
Keystone Club of Jersey City 1870-09-21 Jersey City Hudson County NJ John Zinn
Keystone Jr. Club of Jersey City 1868-09-19 Jersey City Hudson County NJ John Zinn
Knock Down Club of Jersey City 1865-08-30 Jersey City Hudson County NJ John Zinn
Latourette Club of Bergen Point 1870-04-29 Bergen Hudson County NJ John Zinn
Let Up Club of Jersey City 1865-08-30 Jersey City Hudson County NJ John Zinn
Liberty Club of Jersey City 1868-06-11 Jersey City Hudson County NJ John Zinn
Liberty Club of Jersey City2 1867-06-20 Jersey City Hudson County NJ John Zinn
Lightning Club of Jersey City 1869-08-17 Jersey City Hudson County NJ John Zinn
Lincoln Club of Jersey City 1869-08-07 Jersey City Hudson County NJ John Zinn
Little Mac Club of Brooklyn 1864 Jersey City Hudson County NJ Bruce Allardice
Little Rock Club of Bergen 1860-07-08 Bergen Hudson County NJ Richard Hershberger
Live Oak Club of Jersey City 1866-10-02 Jersey City Hudson County NJ John Zinn
Locas Club of Bergen 1860-09-09 Bergen Hudson County NJ Richard Hershberger
Lone Star Club II of Jersey City 1870-08-02 Jersey City Hudson County NJ John Zinn
Lone Star Club of Jersey City 1857 Jersey City Hudson County NJ
Marion Club of Hoboken 1864-08-16 Hoboken Hudson County NJ John Zinn
Marion Club of Jersey City 1865-10-10 Jersey City Hudson County NJ John Zinn
Mazeppa Club of Jersey City 1866-06-19 Jersey City Hudson County NJ John Zinn
Meadow Lark Club of Jersey City 1869-08-20 Jersey City Hudson County NJ John Zinn
Mechanics Club of Jersey City 1859-06-12 Jersey City Hudson County NJ Richard Hershberger
Merry Club of Jersey City 1869-07-03 Jersey City Hudson County NJ John Zinn
Merry Nine Club of Hoboken 1870-07-22 Hoboken Hudson County NJ John Zinn
Metamora Club of Hudson City 1857-09-18 Hudson City Hudson County NJ John Zinn
Mohawk Club of Hoboken 1868-08-14 Hoboken Hudson County NJ John Zinn
Mohawk Club of Jersey City 1866-07-27 Jersey City Hudson County NJ John Zinn
Moneka Club of Jersey City 1868-07-06 Jersey City Hudson County NJ John Zinn
Monitor Club of Bergen 1868-07-31 Bergen Hudson County NJ John Zinn
Monitor Club of East Newark 1866-08-01 East Newark Hudson County NJ John Zinn
Monitor Club of Jersey City 1865-10-18 Jersey City Hudson County NJ John Zinn
Monmouth Club of Hoboken 1858 Hoboken Hudson County NJ Richard Hershberger
Monmouth Club of Hudson City 1867-09-21 Hudson City Hudson County NJ John Zinn