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]][[Country::United States]]
 |?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=100
 |link=none
 |sort=
 |order=asc
 |template=Display Clubs Row
 |introtemplate=Display Clubs Header
 |outrotemplate=Display Table Footer
}}

Results 101 – 150 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Clubs]][[Country::United States]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.3384",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Clubs]] [[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) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=7808
   AND (
   (t4.o_hash='United States') AND t4.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

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t4	ref	s_id, o_hash, s_id_2, p_id	o_hash	258	const	46006	1.47	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id	4	protoballdb.t4.s_id	1	31.08	Using where
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	protoballdb.t4.s_id	1	50.00	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

Club	Date	City	Borough	State	First in	Contributor
Active Club of Lafayette	1870-05-18	Jersey City	Hudson County	NJ		John Zinn
Active Club of Lafayette, IN	1867	Lafayette		IN		Bruce Allardice
Active Club of Lansingburgh	1860	Lansingburgh		NY		Craig Waff
Active Club of Lawrenceville	1870	Lawrenceville		PA		Bruce Allardice
Active Club of Lexington, MA	1868	Lexington		MA		Bruce Allardice
Active Club of Lincoln	1871	Lincoln		IL		Bruce Allardice
Active Club of Litchfield	1870	Litchfield		CT		Bruce Allardice
Active Club of Little Falls	1868-08-24	Little Falls		NJ		John Zinn
Active Club of Little Rock	1869	Little Rock		AR		Bruce Allardice
Active Club of Los Angeles	1876-01-19	Los Angeles		CA		Bruce Allardice
Active Club of Louisville	1868	Louisville		KY		Bruce Allardice
Active Club of Lowellville	1867	Lowellville		OH	Lowellville, OH	Bruce Allardice
Active Club of Manchester	1867	Manchester		VT	Manchester, VT	Bruce Allardice
Active Club of Martinsburg	1867	Martinsburg		NY	Martinsburg, NY	Bruce Allardice
Active Club of Meadville	1866	Meadville		PA		Bruce Allardice
Active Club of Mechanicsburg	1869	Mechanicsburg		PA		Bruce Allardice
Active Club of Melrose	1867-10-19	Melrose	The Bronx	NY		Gregory Christiano
Active Club of Memphis	1867	Memphis		TN		Bruce Allardice
Active Club of Millbury	1869	Millbury		MA		Bruce Allardice
Active Club of Milwaukee	1866	Milwaukee		WI		Bruce Allardice
Active Club of Morrisania	1867-10-19	Morrisania	The Bronx	NY		Gregory Christiano
Active Club of Mystic Bridge	1870	Mystic		CT		Bruce Allardice
Active Club of New Albany	1868	New Albany		IN		Bruce Allardice
Active Club of New Bedford	1867-08	New Bedford		MA		Kyle DeCicco-Carey
Active Club of New Haven	1869	New Haven		CT		Bruce Allardice
Active Club of New London	1866	New London		CT		Bruce Allardice
Active Club of New Orleans	1867	New Orleans		LA		Bruce Allardice
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 Norfolk	1870	Norfolk		CT	Norfolk, CT	Bruce Allardice
Active Club of North Woburn	1867	Woburn		MA		Bruce Allardice
Active Club of Ottumwa	1866-10	Ottumwa		IA	Ottumwa, IA	Bruce Allardice
Active Club of Palmyra	1870	Palmyra		NY		Bruce Allardice
Active Club of Parma	1866	Parma		NY	Parma, NY	Bruce Allardice
Active Club of Pascagoula	1877-07-07	Pascagoula		MS	Pascagoula, MS	Bruce Allardice
Active Club of Paterson	1864-08-22	Paterson	Passaic County	NJ		John Zinn
Active Club of Peoria	1867	Peoria		IL		Robert Sampson
Active Club of Peru	1868	Peru		NY		Bruce Allardice
Active Club of Petaluma	1869	Petaluma		CA	Petaluma, CA	Bruce Allardice
Active Club of Philadelphia	1863	Philadelphia		PA		Bruce Allardice
Active Club of Pittston	1869	Pittston		PA		Bruce Allardice
Active Club of Plattsburgh	1868	Plattsburgh		NY		Bruce Allardice
Active Club of Polo	1870	Polo		IL		Bruce Allardice
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

Semantic search

Query log

Navigation menu

Search