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:Companies:CompanyContact]] [[Companies:category::Aerial Services & Supplies]]
 |?Companies:category
 |?Companies:town
 |?Companies:email
 |?Companies:homepage
 |?Companies:phone
 |format=table
 |limit=50
 |offset=50
 |sort=
 |order=asc
 |mainlabel=
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Companies:CompanyContact]] [[Companies:category::Aerial Services & Supplies]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0232",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Category:Companies:CompanyContact]] [[Companies:category::Aerial Services & Supplies]]

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_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='518'
   AND (t4.p_id='524' AND t4.o_id='1281')
  )
  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	Extra
1	SIMPLE	t4	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id	5	const	780	Using where; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id,o_id,s_id_2,o_id_2	s_id	4	callto_wikidb.t4.s_id	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	callto_wikidb.t4.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

	Companies:category	Companies:town	Companies:email	Companies:homepage	Companies:phone
01206766755	Aerial Services & Supplies	COLCHESTER		http://www.advgroup.co.uk	01206766755
01206945290	Aerial Services & Supplies	COLCHESTER			01206945290
01208221166	Aerial Services & Supplies	BIRMINGHAM			01208221166
01208264626	Aerial Services & Supplies	BOURNEMOUTH			01208264626
01213280111	Aerial Services & Supplies	NOTTINGHAM		http://www.grax.co.uk	01213280111
01213284088	Aerial Services & Supplies	BIRMINGHAM		http://www.eyeviewsat.co.uk/?page id=34	01213284088
01217043825	Aerial Services & Supplies	LONDON			01217043825
01217420026	Aerial Services & Supplies	SOLIHULL		http://www.a1aerialdigital.co.uk	01217420026
01223208441	Aerial Services & Supplies	CHRISTCHURCH		http://www.super-aceaerials.co.uk	01223208441
01223650942	Aerial Services & Supplies	ELY			01223650942
01224453147	Aerial Services & Supplies	ABERDEEN	quickfitaerials@yahoo.co.uk	http://www.quickfitaerials-aberdeen.co.uk	01224453147
01224573601	Aerial Services & Supplies	ABERDEEN	sales@aberdeentechnical.co.uk	http://www.aberdeentechnical.co.uk	01224573601
01225767508	Aerial Services & Supplies	SOLIHULL			01225767508
01227204839	Aerial Services & Supplies	FAVERSHAM	info@receptiontech.co.uk	http://www.receptiontech.co.uk	01227204839
01227264050	Aerial Services & Supplies	SUTTON-IN-ASHFIELD			01227264050
01227362517	Aerial Services & Supplies	ROMSEY	info@aerialshampshire.co.uk	http://www.clearviewaerials.co.uk	01227362517
01227362857	Aerial Services & Supplies	BARKING		http://www.ktvservices.com	01227362857
01227490046	Aerial Services & Supplies	DEAL			01227490046
01227500508	Aerial Services & Supplies	BROADSTAIRS			01227500508
01227637091	Aerial Services & Supplies	FAVERSHAM	info@receptiontech.co.uk	http://www.receptiontech.co.uk	01227637091
01229773596	Aerial Services & Supplies	COLCHESTER			01229773596
01233693136	Aerial Services & Supplies	DEAL		http://kent-aerials.co.uk	01233693136
01234263700	Aerial Services & Supplies	BEDFORD		http://www.philex.com	01234263700
01234834601	Aerial Services & Supplies	WALTHAM CROSS			01234834601
01241434902	Aerial Services & Supplies	ANGUS		http://www.arbroathaerials.co.uk	01241434902
01242236143	Aerial Services & Supplies	SOUTHAMPTON			01242236143
01242244402	Aerial Services & Supplies	LONDON		http://www.true-view.co.uk	01242244402
01242251796	Aerial Services & Supplies	CHELTENHAM		http://www.sparkesaudiovisual.co.uk	01242251796
01243555233	Aerial Services & Supplies	LITTLEHAMPTON			01243555233
01244346722	Aerial Services & Supplies	MANCHESTER			01244346722
01244546116	Aerial Services & Supplies	WATLINGTON			01244546116
01244682300	Aerial Services & Supplies	CHESTER	info@chesterdigitalsupplies.co.uk	http://www.chesterdigitalsupplies.co.uk/	01244682300
01245490355	Aerial Services & Supplies	SOUTH MOLTON			01245490355
01246241617	Aerial Services & Supplies	CHESTERFIELD			01246241617
01248450526	Aerial Services & Supplies	ANGLESEY		http://www.angleseyaerials.co.uk	01248450526
01252337630	Aerial Services & Supplies	LONDON		http://www.eurosat.com	01252337630
01253357712	Aerial Services & Supplies	RINGWOOD			01253357712
01253593422	Aerial Services & Supplies	COVENTRY			01253593422
01253691697	Aerial Services & Supplies	BLACKPOOL			01253691697
01253826489	Aerial Services & Supplies	NEWPORT			01253826489
01253828653	Aerial Services & Supplies	LANCASHIRE			01253828653
01254386728	Aerial Services & Supplies	THORNTON-CLEVELEYS			01254386728
01254471602	Aerial Services & Supplies	ACCRINGTON		http://www.accringtonaerials.co.uk	01254471602
01257453133	Aerial Services & Supplies	CHORLEY			01257453133
01258441322	Aerial Services & Supplies	SHAFTESBURY	info@robertsaerials.co.uk	http://www.robertsaerials.co.uk	01258441322
01259752043	Aerial Services & Supplies	MANCHESTER			01259752043
01260278819	Aerial Services & Supplies	CONGLETON			01260278819
01260298333	Aerial Services & Supplies	CHESHIRE	webmaster@evetttv.co.uk	http://www.evett-tv.co.uk	01260298333
01262400566	Aerial Services & Supplies	SOLIHULL			01262400566
01268202821	Aerial Services & Supplies	CANVEY ISLAND	apexaerials@hotmail.co.uk	http://apexaerialssouthend.net	01268202821