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]] [[City::Newark]] [[Borough::Essex 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_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `smw_di_wikipage` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
  `smw_di_blob` AS t9 ON t2.s_id=t9.s_id
INNER JOIN
  `smw_di_blob` AS t11 ON t2.s_id=t11.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=7808
   AND (
   (t4.o_hash='Newark') AND t4.p_id=566)
   AND (t6.p_id=18595 AND t6.o_id=18826)
   AND (
   (t9.o_hash='NJ') AND t9.p_id=568)
   AND (
   (t11.o_hash='United States') AND t11.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_hash, s_id_2, p_idp_id262const, const409100.00Using index condition; Using temporary; Using filesort
1SIMPLEt6refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3s_id8protoballbetadb.t4.s_id, const15.00Using where
1SIMPLEt9refs_id, o_hash, s_id_2, p_ids_id8protoballbetadb.t4.s_id, const15.00Using where
1SIMPLEt11refs_id, o_hash, s_id_2, p_ids_id8protoballbetadb.t4.s_id, const121.85Using where
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id4protoballbetadb.t4.s_id130.08Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4protoballbetadb.t4.s_id150.00Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:9
Query-Depth:1
Errors and Warnings
None
Club Date City Borough State First in Contributor
Niagara Jr. Club of Newark 1866-07-07 Newark Essex County NJ John Zinn
Northern Liberty Club of Newark 1866-10-12 Newark Essex County NJ John Zinn
Olive Club of Newark 1867-10-22 Newark Essex County NJ John Zinn
Oneida Club of Newark 1867-08-07 Newark Essex County NJ John Zinn
Oraton Club of Newark 1859-11-14 Newark Essex County NJ John Zinn
Oriental Club of Newark 1866-07-25 Newark Essex County NJ John Zinn
Oriental/Olympic Club of Newark 1855-06-16 Newark Essex County NJ
Osceola Club of Newark 1860-09-02 Newark Essex County NJ Richard Hershberger
Osswatomie Club of Newark 1859-11-26 Newark Essex County NJ John Zinn
Pacific Club of Newark 1859-05-31 Newark Essex County NJ John Zinn
Pacific Junior Club II of Newark 1867-07-29 Newark Essex County NJ John Zinn
Padesco Club of Newark 1860-09-02 Newark Essex County NJ Richard Hershberger
Passaic Club of Newark 1861-07-27 Newark Essex County NJ John Zinn
Pennington Club of Newark 1866-10-01 Newark Essex County NJ John Zinn
Perserverance Club of Newark 1866-07-06 Newark Essex County NJ John Zinn
Phoenix Club of Newark 1861-07-27 Newark Essex County NJ John Zinn
Pioneer Club of Newark 1859-10-08 Newark Essex County NJ John Zinn
Potomac Club of Newark 1866-07-16 Newark Essex County NJ John Zinn
Powhatan Club of Newark 1861-07-31 Newark Essex County NJ John Zinn
Quickstep Club of Newark 1860-07-29 Newark Essex County NJ Richard Hershberger
Quickstep Club of Newark2 1867-06-29 Newark Essex County NJ
Quickstep, Jr. Club of Newark 1860-08-02 Newark Essex County NJ John Zinn
Reliance Social Club of Newark 1870-06-07 Newark Essex County NJ John Zinn
Resolute Club of Newark 1865-08-16 Newark Essex County NJ John Zinn
Ringold Club of Newark 1860-05-28 Newark Essex County NJ John Zinn
Roseville (Union) Club of Newark 1857-10-05 Newark Essex County NJ John Zinn
Roseville Club of Newark 1870-07-11 Newark Essex County NJ John Zinn
Roseville Club of Newark2 1858-10-22 Newark Essex County NJ
Rover Club of Newark 1866-08-16 Newark Essex County NJ John Zinn
Scott Club of Newark 1861-06-29 Newark Essex County NJ John Zinn
Seminoles Club of Newark 1866-07-23 Newark Essex County NJ John Zinn
Sennex Social Club of Newark 1868-07-08 Newark Essex County NJ John Zinn
Sparta Club of Newark 1867-08-01 Newark Essex County NJ John Zinn
St. John's Club of Newark 1855-10-24 Newark Essex County NJ John Zinn
Star Club of Newark 1861-06-24 Newark Essex County NJ John Zinn
Star Club of Newark2 1866-08-21 Newark Essex County NJ
Starlight Junior Club of Newark 1870-05-14 Newark Essex County NJ John Zinn
Summit Junior Club of Newark 1866-06-30 Newark Essex County NJ John Zinn
Tedisco Club of Newark 1860-08-31 Newark Essex County NJ John Zinn
Una Club of Newark 1870-09-09 Newark Essex County NJ John Zinn
Uncas Club of Newark 1860-08-31 Newark Essex County NJ John Zinn
Union Club of Newark 1859-11-07 Newark Essex County NJ John Zinn
Unique Club of Newark 1869-08-17 Newark Essex County NJ John Zinn
Unknown Club of Newark 1869-07-31 Newark Essex County NJ John Zinn
Venus Club of Newark 1860-10-30 Newark Essex County NJ John Zinn
Washington Club II of Newark 1860-08-11 Newark Essex County NJ John Zinn
Washington Club of Newark 1857-11-16 Newark Essex County NJ John Zinn
Washington Jr. Club of Newark 1859-10-30 Newark Essex County NJ Richard Hershberger
Waverly Club of Newark 1867-07-06 Newark Essex County NJ John Zinn
Young America Club of Newark 1860-10-08 Newark Essex County NJ John Zinn