Open main menu

Semantic search

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
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:category::Burglar Alarms & Security Systems]]
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='794')
  )
  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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt4refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const1464Using where; Using temporary; Using filesort
1SIMPLEt2refs_id,o_id,s_id_2,o_id_2s_id4callto_wikidb.t4.s_id1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4callto_wikidb.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
Phone numberCompanyBusiness categoryLocationE-mailCompany homepage
01179398895CRIME CURE LTDBurglar Alarms & Security SystemsASHFORD
01179522636ASTRA COMMUNICATIONS SECURITY SYSTEMS LIMITEDBurglar Alarms & Security SystemsBRISTOLinfo@astracomms.co.ukhttp://www.astracomms.co.uk
01179526000AVON ALARMS LIMITEDBurglar Alarms & Security SystemsREDLANDhttp://www.avonalarms.co.uk
01179570037CASTLE SECURITY LIMITEDBurglar Alarms & Security SystemsWARRINGTON
01179583838BAC FIRE & SECURITY LIMITEDBurglar Alarms & Security SystemsBRISTOLhttp://www.bacsecurity.com
01179657692C.A.P SECURITY LIMITEDBurglar Alarms & Security SystemsBRISTOLinfo@capsecurity.co.ukhttp://www.capsecurityltd.co.uk
01179668765ALARMSAFE LTDBurglar Alarms & Security SystemsGLASGOWalarmsafe@hotmail.comhttp://www.alarmsafe-bristol.co.uk
01179748999CANNON SECURITY LIMITEDBurglar Alarms & Security SystemsNORTH FILTONinfo@cannonsecurity.co.ukhttp://www.cannonsecurity.co.uk
01179779997ENTERPRISE SECURITY DISTRIBUTION (SOUTH WEST) LIMITEDBurglar Alarms & Security SystemsROYSTON
01179822088AVONBRIDGE ALARMS LIMITEDBurglar Alarms & Security SystemsBRISTOLhttp://www.avonbridgealarms.tel
01183779000BAND SYSTEMS LIMITEDBurglar Alarms & Security SystemsSHEFFIELDhttp://www.bandsystems.co.uk
01189016750SPECTRUM SECURITY & FIRE LIMITEDBurglar Alarms & Security SystemsWINDSORinfo@spectrumsecurity.co.uk
chris@digity.co.uk
http://www.spectrumsecurity.co.uk
01189036060I2 SECURITY LIMITEDBurglar Alarms & Security SystemsCHATHAMinfo@i2security.co.ukhttp://www.i2security.co.uk
01189419564ABATTIS SECURITY SYSTEMS LIMITEDBurglar Alarms & Security SystemsREADINGhttp://www.abattis.co.uk
01189433710HARVEYS HOME SECURITY LIMITEDBurglar Alarms & Security SystemsREADINGhttp://www.
01189448773JB SECURITY SYSTEMS LTDBurglar Alarms & Security SystemsBRACKNELLinfo@jb-security.co.ukhttp://www.jb-security.co.uk
01189722054BOND ALARMS LIMITEDBurglar Alarms & Security SystemsBRECON
01189811428BERKELEY GUARD GROUP LLPBurglar Alarms & Security SystemsTHEALEinfo@berkeleyguard.com
sales@berkeleyguard.com
http://www.berkeleyguard.com
01202621749BLUEBIRD SECURITY LIMITEDBurglar Alarms & Security SystemsPOOLEhttp://www.bluebirdsecurityltd.co.uk
01202631742FRONTIER SECURITY SYSTEMS LIMITEDBurglar Alarms & Security SystemsPOOLEfrontier@security.eclipse.co.ukhttp://www.frontiersecuritysystems.com
01202775456MS SECURITY LIMITEDBurglar Alarms & Security SystemsBRADFORD
01202874834ACTION ALARMS LIMITEDBurglar Alarms & Security SystemsBOURNEMOUTH
01202892360JB SECURITY LIMITEDBurglar Alarms & Security SystemsDORSETinfo@jbsecurity.co.ukhttp://www.jbsecurity.co.uk
01202924510SOUTHERN SECURITY SERVICES LIMITEDBurglar Alarms & Security SystemsPOOLEsales@southernsecurityservices.co.ukhttp://www.southernsecurityservices.co.uk
01202937166CLAYMAN ELECTRONICS LIMITEDBurglar Alarms & Security SystemsPOOLE
01204322677NOVA ALARMS NORTHWEST LTDBurglar Alarms & Security SystemsMANCHESTERnova.alarmsltd@gmail.comhttp://www.nova-alarms.co.uk
01204362554ADK SECURITY LIMITEDBurglar Alarms & Security SystemsLANCASHIREsales@adk-security.comhttp://www.adk-security.com
01204395525DERBY FIRELEC LIMITEDBurglar Alarms & Security SystemsBOLTONinfo@derbyfirelec.comhttp://www.derbyfirelec.com
01204415585ASM LIMITEDBurglar Alarms & Security SystemsLONDON
01204439872ACT SECURITY LIMITEDBurglar Alarms & Security SystemsCHESTERsales@actcctv.co.ukhttp://www.actcctv.co.uk
01204491000DPE SYSTEMS LIMITEDBurglar Alarms & Security SystemsBOLTONhttp://www.dpesys.com
01204491366GUARDALL ALARMS LIMITEDBurglar Alarms & Security SystemsBOLTON
01204792407ATOM SECURITY UK LTDBurglar Alarms & Security SystemsBOLTON
01204886058ATLANTIS INTRUDER ALARMS LIMITEDBurglar Alarms & Security SystemsNR BURY
01204898254NOVA SECURITY SYSTEMS LIMITEDBurglar Alarms & Security SystemsBOLTONoffice@nova-security.co.ukhttp://www.nova-security.co.uk
01206303004ELECTRONIC ENGINEERING LIMITEDBurglar Alarms & Security SystemsBIRMINGHAM
01206617418ANGLIAN BURGLAR ALARMS LIMITEDBurglar Alarms & Security SystemsIPSWICH
01206728814PENTAGON ELECTRICAL SERVICES LTDBurglar Alarms & Security SystemsFLEET
01206763203HEWES SECURITY LIMITEDBurglar Alarms & Security SystemsHERTFORDSHIREhttp://www.hewessecurity.co.uk
01206853599TDT ENTERPRISES LIMITEDBurglar Alarms & Security SystemsCOLCHESTERinfo@tdtenterprises.co.ukhttp://www.tdtenterprises.co.uk
01209214902PG SMITH LIMITEDBurglar Alarms & Security SystemsHYDE
01212366977MULTIPLEX SECURITY COMMUNICATIONS LIMITEDBurglar Alarms & Security SystemsSTOURBRIDGE
01212367449BHARAT ALARMSBurglar Alarms & Security Systems
01212430318EXPRESS ALARMS LTDBurglar Alarms & Security SystemsBIRMINGHAM
01212702591N.B. SYSTEMS LIMITEDBurglar Alarms & Security SystemsBOURNEMOUTH
01212850612HOW ARE YOU LIMITEDBurglar Alarms & Security SystemsSOLIHULLhttp://www.howareyougroup.co.uk
01213699893JUSTICE SECURITY SYSTEMS LIMITEDBurglar Alarms & Security SystemsBIRMINGHAMinfo@justicesecurity.co.uk
sales@justicesecurity.co.uk
http://www.justicesecurity.co.uk
01213825900SECURICAN LTDBurglar Alarms & Security SystemsRUGELEYhttp://www.securican.com
01213845606BEE TEE ALARMS LIMITEDBurglar Alarms & Security SystemsNORTHAMPTONsales@beeteealarmsltd.co.ukhttp://www.beeteealarmsltd.co.uk
01214211740CROWN SECURITY LTDBurglar Alarms & Security SystemsBARNSLEY