Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

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

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Category:Clubs]]
 |?Type of Date
 |?Date
 |?Modern Address
 |?Country
 |?State
 |?City
 |?Name
 |?First in Location
 |?First in Location Note
 |?Reviewed
 |?Submitted by
 |?Borough
 |format=template
 |limit=50
 |offset=150
 |link=none
 |sort=
 |order=asc
 |template=Display Clubs Row
 |introtemplate=Display Clubs Header
 |outrotemplate=Display Table Footer
}}

Results 151 – 200 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Clubs]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1179",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Clubs]]

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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=7808)
  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
150

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	const	24922	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	protoballdb.t1.s_id	1	50.00	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

Club	Date	City	Borough	State	First in	Contributor
Active Club of Portland	1864	Portland		ME		Bruce Allardice
Active Club of Portland, OR	1867	Portland		OR		Bruce Allardice
Active Club of Providence	1866	Providence		RI		Bruce Allardice
Active Club of Quincy	1869	Quincy		IL		Bruce Allardice
Active Club of Quincy, MA	1866	Quincy		MA	Quincy, MA	Bruce Allardice
Active Club of Racine	1870	Racine		WI		Bruce Allardice
Active Club of Reading	1866-08	Reading		PA		Bruce Allardice
Active Club of Rochester	1867	Rochester		NY		Bruce Allardice
Active Club of Rome	1868	Rome		NY		Bruce Allardice
Active Club of Saginaw	1870	Saginaw		MI		Bruce Allardice
Active Club of Salem	1866	Salem		MA		Bruce Allardice
Active Club of San Francisco	1867	San Francisco		CA		Bruce Allardice
Active Club of Savannah	1867-10-09	Savannah		GA		Bruce Allardice
Active Club of Schenectady	1869	Schenectady		NY		Bruce Allardice
Active Club of Springfield	1866	Springfield		MA		Bruce Allardice
Active Club of Springfield, IL	1867	Springfield		IL		Robert Sampson
Active Club of St. Charles	1867	St. Charles		IL		Bruce Allardice
Active Club of St. Louis	1866	St. Louis		MO		Jeffrey Kittel
Active Club of St. Paul	1870	St. Paul		MN		Bruce Allardice
Active Club of Sterling	1871	Sterling		IL		Bruce Allardice
Active Club of Summit	1867-07-25	Summit	Union County	NJ	Summit, NJ	John Zinn
Active Club of Summit, IL	1875					Bruce Allardice
Active Club of Swanton	1867	Swanton		VT	Swanton, VT	Bruce Allardice
Active Club of Thevenin	1869	Thevenin		OH	Thevenin, OH	Bruce Allardice
Active Club of Towson	1868	Towson		MD		Bruce Allardice
Active Club of Troy	1860-10-27	Troy		NY		Bruce Allardice
Active Club of Tuckahoe	1867	Tuckahoe	Westchester County	NY		Bruce Allardice
Active Club of Tucson	1877	Tucson		AZ		Bruce Allardice
Active Club of Utica	1864	Utica		NY		Bruce Allardice
Active Club of Vandalia	1867	Vandalia		IL		Robert Sampson
Active Club of Verona	1869-07-22	Verona		NJ		John Zinn
Active Club of Wappinger's Falls	1866	Wappinger's Falls		NY	Wappinger's Falls, NY	Bruce Allardice
Active Club of Washington	1865	Washington		DC		Bruce Allardice
Active Club of Washington, NJ	1866-09-07	Washington		NJ		John Zinn
Active Club of Watertown	1867	Watertown		NY		Bruce Allardice
Active Club of West Castleton	1867	Castleton		VT	Castleton, VT	Bruce Allardice
Active Club of Wheeling	1867	Wheeling		WV		Bruce Allardice
Active Club of Wilkes Barre	1868	Wilkes-Barre		PA		Bruce Allardice
Active Club of Wilmington	1870	Wilmington		DE		Bruce Allardice
Active Club of Wolcottville	1870	Torrington		CT		Bruce Allardice
Active Club of Yonkers	1867	Yonkers	Westchester County	NY		Bruce Allardice
Active Jr. Club of Chicago	1869	Chicago		IL		Bruce Allardice
Active Jr. Club of Morrisania	1868	Morrisania	The Bronx	NY		Bruce Allardice
Active Junior Club of Newark	1867-07-20	Newark	Essex County	NJ		John Zinn
Active Star Club of New Orleans	1869	New Orleans		LA		Bruce Allardice
Actives Club of Ballston Spa	1867	Ballston Spa		NY		Bruce Allardice
Actives Club of Clinton	1870	Clinton		IA		Bruce Allardice
Actives Club of Dundee	1868	Dundee		NY		Bruce Allardice
Actives Club of Fort Lincoln	1874-06-07	Fort Lincoln		ND	Fort Lincoln, ND	Bruce Allardice
Actives Club of Lynchburg	1875-08-13	Lynchburg		TN	Lynchburg, TN	Bruce Allardice

Semantic search

Query log

Navigation menu

Search