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]]
 |?Date
 |?Type of Date
 |?Modern Address
 |?Country
 |?State
 |?City
 |?Name
 |?First in Location
 |?First in Location Note
 |format=template
 |limit=50
 |offset=50
 |link= none
 |sort=
 |order=asc
 |headers= hide
 |mainlabel=
 |template= Display First Clubs Row
 |introtemplate= Display First Clubs Header
 |outrotemplate= Display Table Footer
}}

Results 51 – 100 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.1335",
    "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
50

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	24872	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

Page	Date	City	State	Club	First in
Club	Error: Invalid time.	Barrytown	NY	Active Club of Barrytown	Barrytown, NY
Club	Error: Invalid time.	Batavia	NY	Active Club of Batavia
Club	Error: Invalid time.	Bath	ME	Active Club of Bath	Bath, ME
Club	Error: Invalid time.	Beatrice	NE	Active Club of Beatrice	Beatrice, NE
Club	Error: Invalid time.	Belleville	NJ	Active Club of Belleville
Club	Error: Invalid time.	Bennington	VT	Active Club of Bennington
Club	Error: Invalid time.	Smithfield	RI	Active Club of Bernon
Club	Error: Invalid time.	Big Rapids	MI	Active Club of Big Rapids
Club	Error: Invalid time.	Boston	MA	Active Club of Boston
Club	Error: Invalid time.	Brazil	IN	Active Club of Brazil	Brazil, IN
Club	Error: Invalid time.	Brookfield	MO	Active Club of Brookfield	Brookfield, MO
Club	Error: Invalid time.	Brooklyn	NY	Active Club of Brooklyn
Club	Error: Invalid time.	Buffalo	NY	Active Club of Buffalo
Club	Error: Invalid time.	Burlington	NJ	Active Club of Burlington	Burlington, NJ
Club	Error: Invalid time.	Camden	DE	Active Club of Camden	Camden, DE
Club	Error: Invalid time.	Carlinville	IL	Active Club of Carlinville
Club	Error: Invalid time.	Central Falls	RI	Active Club of Central Falls
Club	Error: Invalid time.	Chelsea	MA	Active Club of Chelsea
Club	Error: Invalid time.	Chester	PA	Active Club of Chester
Club	Error: Invalid time.	Chicago	IL	Active Club of Chicago
Club	Error: Invalid time.	Chicopee	MA	Active Club of Chicopee
Club	Error: Invalid time.	Cincinnati	OH	Active Club of Cincinnati
Club	Error: Invalid time.	Cleveland	OH	Active Club of Cleveland
Club	Error: Invalid time.	Columbus	OH	Active Club of Columbus
Club	Error: Invalid time.	Cumberland Mills	ME	Active Club of Cumberland Mills	Cumberland Mills, ME
Club	Error: Invalid time.	Detroit	MI	Active Club of Detroit
Club	Error: Invalid time.	Dobbs Ferry	NY	Active Club of Dobbs Ferry
Club	Error: Invalid time.	Dorchester	MA	Active Club of Dorchester
Club	Error: Invalid time.	Douglasville	GA	Active Club of Douglasville	Douglasville, GA
Club	Error: Invalid time.	Dresden		Active Club of Dresden	Dresden, Germany
Club	Error: Invalid time.	Cambridge	MA	Active Club of East Cambridge
Club	Error: Invalid time.	Elizabeth	NJ	Active Club of Elizabeth
Club	Error: Invalid time.	Elmira	NY	Active Club of Elmira
Club	Error: Invalid time.	Evansville	IN	Active Club of Evansville
Club	Error: Invalid time.	Exeter	NH	Active Club of Exeter	Exeter, NH
Club	Error: Invalid time.	Fayetteville	NY	Active Club of Fayetteville
Club	Error: Invalid time.	Florence	MA	Active Club of Florence	Florence, MA
Club	Error: Invalid time.	Frederick	MD	Active Club of Frederick
Club	Error: Invalid time.	Fremont	OH	Active Club of Fremont	Fremont, OH
Club	Error: Invalid time.	Gettysburg	PA	Active Club of Gettysburg
Club	Error: Invalid time.	Somersworth	NH	Active Club of Great Falls
Club	Error: Invalid time.	Great Falls	NH	Active Club of Great Falls	Great Falls, NH
Club	Error: Invalid time.	Green Island	NY	Active Club of Green Island
Club	Error: Invalid time.	Rensselaer	NY	Active Club of Greenbush	Rensselaer, NY
Club	Error: Invalid time.	Hackettstown	NJ	Active Club of Hackettstown	Hackettstown, NJ
Club	Error: Invalid time.	Hadley	MA	Active Club of Hadley
Club	Error: Invalid time.	Hampton	NJ	Active Club of Hampton Junction, NJ	Hampton, NJ
Club	Error: Invalid time.	Harlem	NY	Active Club of Harlem
Club	Error: Invalid time.	Harrisburg	PA	Active Club of Harrisburg
Club	Error: Invalid time.	Hoboken	NJ	Active Club of Hoboken

Semantic search

Query log

Navigation menu

Search