Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is 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

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

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

{{#ask: [[Category:Organizations]] [[Industry sector::Finance and Insurance]]
 |?Sub-Industry
 |?Founded in state=State
 |?Founded in city=City
 |?Start date=Established
 |?Status=Current status
 |format=broadtable
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |mainlabel=Organization
 |searchlabel=Finance and Insurance
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Organizations]] [[Industry sector::Finance and Insurance]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0395",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Organizations]] [[Industry sector::Finance and Insurance]]

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=19678
   AND (
   (t4.o_hash='Finance and Insurance') AND t4.p_id=57939)
  )
  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	Extra
1	SIMPLE	t4	index_merge	s_id, o_hash, s_id_2, p_id	o_hash,p_id	258,262		122	Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	s_id_2	9	wcpl.t4.s_id, const	1	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	wcpl.t4.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

Organization	Sub-Industry	State	City	Established	Current status
AAA Insurance	Insurance Carriers and Related Activities	Ohio	Wooster		Active
ABM Investments				2003	Active
Acceptance Insurance	Insurance Carriers and Related Activities			2008	Active
Acquisition Group LTD	Investing Institutions	Ohio	Wooster	2001	Active
Adams Bank	Banks and Credit Unions			1870	Defunct
Advance America	Credit Institutions	Ohio	Wooster		Defunct
Aflac Health Plans	Insurance Carriers and Related Activities & Brokerages				Active
Agri Advisory Associates Inc	Investing Institutions				Active
Aig American General	Insurance Carriers and Related Activities	Ohio	Wooster		Active
Allstate Insurance	Insurance Carriers and Related Activities	Ohio	Wooster	2005	Active
Ameri First Home Mortgage	Real Estate Credit Mortgage Loan Brokers			2014	Defunct
American Family Insurance	Insurance Carriers and Related Activities & Brokerages				Active
American Payroll Advance LTD	Credit Institutions Loan Companies				Active
Ameriprise Financial Inc	Investing Institutions				Active
Apple Creek Banking Company, The	Banks and Credit Unions	Ohio	Apple Creek	1904	Active
Arnett Agency	Insurance Carriers and Related Activities & Brokerages				Defunct
Asher, Donald Agt	Insurance Carriers and Related Activities & Brokerages
Atlantic Financial Services	Investing Institutions				Defunct
Autoworkers Credit Union Inc	Credit Union				Defunct
Bank Of America Home Loans	Real Estate Credit Banks and Credit Unions				Defunct
Bank Of America Mortgage	Real Estate Credit				Defunct
Bank of Mt. Eaton, The	Banks and Credit Unions			1919	Defunct
Bank of Wooster, The	Banks and Credit Unions	Ohio	Wooster	1840	Defunct
Beaverson Foundation, The	Funds / Trust and Other Financial Vehicles			1992	Active
Beneficial Finance	Credit Institutions
Blough & Taylor Insurance	Insurance Carriers and Related Activities Investing Institutions	Ohio	Wooster		Defunct
Boreman Norton Cook Wealth Partners	Investing Institutions	Ohio	Wooster		Active
Briggs Financial Group	Insurance Carriers and Related Activities & Brokerages			1995	Active
Buren Insurance Group	Insurance Carriers and Related Activities & Brokerages				Active
CSB Trust & Financial Svcs	Trust, Fiduciary & Custody Activities
Capital Financial Service Inc	Investing Institutions				Defunct
Capital Securities Of America	Investing Institutions				Defunct
Cashland	Credit Institutions				Active
Chase Bank	Banks and Credit Unions				Active
Check Into Cash	Credit Institutions	Ohio	Wooster		Defunct
Chippewa Finance Co.	Credit Institutions				Defunct
Chunker Investment LLC	Miscellaneous Intermediation				Defunct
Citizens Bank, The (Fredericksburg, Ohio)	Banks and Credit Unions	Ohio	Fredericksburg	1903	Defunct
Citizens Insurance Agency	Insurance Carriers and Related Activities	Ohio	Wooster		Defunct
Citizens National Bank, The	Banks and Credit Unions			1905	Defunct
City Loan and Saving Company, The	Banks and Credit Unions			1912	Defunct
Clarke Insurance Group LLC	Insurance Carriers and Related Activities & Brokerages				Active
Commercial & Savings Bank	Credit Institutions, Banks and Credit Unions
Commercial Banking & Trust Company, The	Banks and Credit Unions	Ohio	Wooster	1918	Defunct
Cook Financial Planning Ctr	Investing Institutions
Countrywide Home Loans	Credit Institutions	Ohio	Wooster		Active
Crater Agency	Insurance Carriers and Related Activities				Defunct
Creative Equity Partners	Credit Institutions
Critchfield Xen Insurance	Insurance Carriers and Related Activities & Brokerages,
Crystal Insurance	Insurance Carriers and Related Activities & Brokerages

Semantic search

Query log

Navigation menu

Search