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]][[State::MD]][[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=0
 |link=none
 |sort=
 |order=asc
 |template=Display Clubs Row
 |introtemplate=Display Clubs Header
 |outrotemplate=Display Table Footer
}}

Results 1 – 50 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

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

Debug output SQLStore

ASK Query

[[Category:Clubs]] [[State::MD]] [[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_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=7808
   AND (
   (t4.o_hash='MD') AND t4.p_id=568)
   AND (
   (t6.o_hash='United States') AND t6.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
0

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	p_id	262	const, const	456	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	t6	ref	s_id, o_hash, s_id_2, p_id	s_id	8	protoballdb.t4.s_id, const	1	24.62	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
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id	4	protoballdb.t4.s_id	1	30.96	Using where; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:5
Query-Depth:1

Errors and Warnings

None

Club	Date	City	State	First in	Contributor
Active Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Active Club of Frederick	1869	Frederick	MD		Bruce Allardice
Active Club of Towson	1868	Towson	MD		Bruce Allardice
Advance Club of Cumberland	1866	Cumberland	MD
Alert Club of Baltimore	1866-08	Baltimore	MD		Bruce Allardice
Alert Club of Buckeystown	1870	Buckeystown	MD		Bruce Allardice
Alert Club of Cumberland	1865-09-15	Cumberland	MD	Cumberland, MD	Bruce Allardice
Alleghany Club of Cumberland	1866	Cumberland	MD		Bruce Allardice
Alpha Club of Baltimore	1861	Baltimore	MD		Bruce Allardice
Alpine Club of Buckeystown	1869	Buckeystown	MD	Buckeystown, MD	Bruce Allardice
Alpine Club of Emmittsburg	1869	Emmittsburg	MD	Emmittsburg, MD	Bruce Allardice
Amateur Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Amazon Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
American Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Annapolis Club of Annapolis	1865	Annapolis	MD	Annapolis, MD	Bruce Allardice
Antietam Club of Hagerstown	1865	Hagerstown	MD	Hagerstown, MD	Bruce Allardice
Arctic Club of Baltimore	1867	Baltimore	MD		Bruce Allardice
Arlington Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Ashland Club of Baltimore	1865-09	Baltimore	MD		Bruce Allardice
Associate Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Athletic Club of Annapolis	1866	Annapolis	MD		Bruce Allardice
Athletic Club of Baltimore	1868	Baltimore	MD		Bruce Allardice
Athletic Club of Cockeysville	1868	Cockeysville	MD	Cockeysville, MD	Bruce Allardice
Athletic Jr. Club of East Baltimore	1866	Baltimore	MD		Bruce Allardice
Atlanta Club of Baltimore	1865	Baltimore	MD		Bruce Allardice
Atlantic Club of Baltimore	1861	Baltimore	MD		Bruce Allardice
Atlantic Club of Frederick	1870	Frederick	MD		Bruce Allardice
Atlantic Jr. Club of Baltimore	1861	Baltimore	MD		Bruce Allardice
Avalanche Club of Cecil County	1867	Cecil County	MD	Cecil County, MD	Marty Payne
Baltic Club of Calvert College, New Windsor	1870	New Windsor	MD		Bruce Allardice
Baltimore Base Ball Club	1860-07	Baltimore	MD		Bruce Allardice
Bancroft Club of Annapolis Naval Academy	1866	Annapolis	MD		Bruce Allardice
Belvidere Club of Baltimore	1860-11-10	Baltimore	MD		Bruce Allardice
Bohemia Club of Chesapeake City	1866	Chesapeake City	MD	Chesapeake City, MD	Chuck DeSocio
Bolton Club of Baltimore	1861	Baltimore	MD		Bruce Allardice
Calvert Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Calvert Club of New Windsor	1866	New Windsor	MD	New Windsor, MD	Bruce Allardice
Carroll Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Carroll Club of Uniontown	1866	Uniontown	MD	Uniontown, MD	Bruce Allardice
Catoctin Club of Middletown	1866	Middletown	MD	Middletown, MD	Bruce Allardice
Cecil Club of Chesapeake City	1866	Chesapeake City	MD		Chuck DeSocio
Centre Club of Baltimore	1866	Baltimore	MD		Bruce Allardice
Chesapeake Club of Baltimore	1861	Baltimore	MD		Bruce Allardice
Chesapeake Club of West River	1867	West River	MD		Bruce Allardice
Chesepeake Club of Annapolis	1866	Annapolis	MD		Bruce Allardice
Chester Club of Baltimore	1861	Baltimore	MD		Bruce Allardice
Chester Club of Preston	1867-06-20	Preston	MD
Chesterfield Club of Centreville	1867	Centreville	MD	Centreville, MD	Bruce Allardice
Chesterfield Club of Queen Anne County	1867	Queen Anne County	MD	Queen Anne County, MD	Marty Payne
Choptank Club of Preston	1867-05-30	Preston	MD	Preston, MD

Semantic search

Query log

Navigation menu

Search