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::Office Equipment Suppliers]]
 |?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::Office Equipment Suppliers]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0185",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Category:Companies:CompanyContact]] [[Companies:category::Office Equipment Suppliers]]

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='548')
  )
  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	404	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
01236437145	Office Equipment Suppliers	GLASGOW			01236437145
01236734400	Office Equipment Suppliers	STIRLING		http://www.data-supplies.com	01236734400
01242230016	Office Equipment Suppliers	HERTFORD		http://www.abbeybusinessequipment.com	01242230016
01242263444	Office Equipment Suppliers	HERTFORD		http://www.abbeybusinessequipment.com	01242263444
01243544233	Office Equipment Suppliers	MAIDSTONE		http://www.apogeecorp.com	01243544233
01246470444	Office Equipment Suppliers	CHESTERFIELD	sales@kudosoffice.co.uk	http://www.kudosoffice.co.uk	01246470444
01249444777	Office Equipment Suppliers	CHIPPENHAM		http://www.woodsoffice.co.uk	01249444777
01252359760	Office Equipment Suppliers	FARNBOROUGH		http://www.ajproducts.co.uk	01252359760
01252447373	Office Equipment Suppliers	ALDERSHOT		http://www.gotoner.co.uk	01252447373
01252543559	Office Equipment Suppliers	HANTS		http://www.floydsuk.com	01252543559
01253393355	Office Equipment Suppliers	COVENTRY		http://www.discountofficesupplieslimited.co.uk	01253393355
01253767470	Office Equipment Suppliers	CARLISLE		http://www.otcorp.co.uk	01253767470
01253767644	Office Equipment Suppliers	LANCASHIRE	sales@longfellowsltd.co.uk	http://www.longfellowsltd.co.uk/Default.aspx	01253767644
01256886420	Office Equipment Suppliers	TADLEY		http://www.xentair.com	01256886420
01257440240	Office Equipment Suppliers	CHORLEY	educationsales@blueorangeit.co.uk	http://www.blueorangeit.co.uk	01257440240
01260271208	Office Equipment Suppliers	CONGLETON			01260271208
01268491900	Office Equipment Suppliers	BASILDON	offer@atsweb.co.uk	http://www.advancedtechnologysystems.co.uk	01268491900
01268798000	Office Equipment Suppliers	RAYLEIGH	info@damedia.co.uk	http://www.damedia.co.uk	01268798000
01269844769	Office Equipment Suppliers	CHATHAM			01269844769
01270255802	Office Equipment Suppliers	CHESHIRE		http://www.officeservices.uk.com	01270255802
01273203100	Office Equipment Suppliers	HOVE		http://www.odm-uk.com	01273203100
01273494913	Office Equipment Suppliers	HENFIELD	support@premieroffice.co.uk info@premieroffice.co.uk	http://www.premieroffice.co.uk	01273494913
01274201200	Office Equipment Suppliers	BRADFORD		http://www.mpsys.co.uk	01274201200
01274390136	Office Equipment Suppliers	BRADFORD		http://www.officerulers.co.uk	01274390136
01274505834	Office Equipment Suppliers	GLASGOW	info@nicheofficesolutions.co.uk	http://www.nicheofficesolutions.co.uk	01274505834
01274530878	Office Equipment Suppliers	WAKEFIELD	info@arenagroup.net service@arenagroup.net pssupport@arenagroup.net edmsupport@arenagroup.net sales@arenagroup.net	http://www.arenagroup.net	01274530878
01274532014	Office Equipment Suppliers	SKIPTON		http://www.ioeonline.co.uk	01274532014
01274611461	Office Equipment Suppliers	BRADFORD			01274611461
01274662100	Office Equipment Suppliers	BRADFORD		http://www.commercebusinesssystems.co.uk	01274662100
01276675492	Office Equipment Suppliers	CAMBERLEY	s.potter@powerdatamanagement.co.uk	http://www.powerdatamanagement.co.uk	01276675492
01277282411	Office Equipment Suppliers	LONDON		http://www.frankingdirect.co.uk	01277282411
01277363365	Office Equipment Suppliers	SAWBRIDGEWORTH		http://www.falconbus.co.uk	01277363365
01278723784	Office Equipment Suppliers	EDINGTON		http://www.sdsltd.uk.com	01278723784
01282778037	Office Equipment Suppliers	ACCRINGTON		http://www.texol.co.uk	01282778037
01284700803	Office Equipment Suppliers	AMPTHILL			01284700803
01284723522	Office Equipment Suppliers	WITHAM		http://www.ebmplc.com	01284723522
01284767711	Office Equipment Suppliers	LEEDS		http://www.officeteam.com	01284767711
01294270593	Office Equipment Suppliers	IRVINE	kenny.stuart@arenaoffice.co.uk	http://www.arenaoffice.co.uk	01294270593
01295711117	Office Equipment Suppliers	BANBURY		http://osol.opnet.co.uk/Index.aspx?SID=761b7b44b0f5437eb7eb6a8deaff70cc	01295711117
01296425566	Office Equipment Suppliers	BIRMINGHAM	claire@burgessoffice.co.uk	http://www.burgessoffice.co.uk	01296425566
01299871369	Office Equipment Suppliers	STOURPORT ON SEVERN		http://www.peterhandley.co.uk	01299871369
01302322333	Office Equipment Suppliers	WAKEFIELD	info@arenagroup.net service@arenagroup.net pssupport@arenagroup.net edmsupport@arenagroup.net sales@arenagroup.net	http://www.arenagroup.net	01302322333
01303266200	Office Equipment Suppliers	CANTERBURY	sales@theglasswipeboardcompany.com	http://www.theglasswipeboardcompany.com	01303266200
01306713410	Office Equipment Suppliers	BRIGHTON		http://www.teamgt.co.uk	01306713410
01314459950	Office Equipment Suppliers	LANARKSHIRE	salesadmin@ncs-ltd.com	http://www.ncs-ltd.com	01314459950
01322223003	Office Equipment Suppliers	PETERBOROUGH	johnboyflash@btopenworld.com	http://www.ethosservices.co.uk	01322223003
01322868606	Office Equipment Suppliers	HORTON ROAD HORTON KIRBY		http://www.lionhouse.co.uk	01322868606
01325382020	Office Equipment Suppliers	DARLINGTON		http://www.glenofficesupplies.co.uk	01325382020
01342892929	Office Equipment Suppliers	SOUTH GODSTONE	askme@one-to-one.net orders@one-to-one.net	http://www.onetooneofficesupplies.com	01342892929
01344307800	Office Equipment Suppliers			http://www.infigoltd.co.uk	01344307800