Semantic search

From Who Called Me
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::Computer Software Development]]
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='716')
  )
  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_id5const4272Using 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
01142211816FLOW SIMULATION LIMITEDComputer Software DevelopmentSHEFFIELD
01142217070PRODUCTION SOFTWARE TECHNOLOGY LIMITEDComputer Software DevelopmentROTHERHAMhttp://www.pstonline.co.uk
01142221888EPI GENESYS LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.epigenesys.org.uk
01142231370MACHINEWORKS LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.machineworks.com
01142242316BETTISON.ORG LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.bettison.org
01142242522INDUSTRIAL CONTROL SYSTEMS LIMITEDComputer Software DevelopmentSHEFFIELDinfo@ics-uk.nethttp://www.ics-uk.net
01142307305VISIONBASE SOFTWARE LIMITEDComputer Software DevelopmentSHEFFIELDinfo@landlord-manager.co.ukhttp://www.landlord-manager.co.uk
01142331663SUMMIT DIRECTIONS LIMITEDComputer Software Developmenthttp://www.the-summit.co.uk
01142412255PACE SOFTWARE DEVELOPMENT LIMITEDComputer Software DevelopmentSHEFFIELDenquiries@pacecomputers.co.ukhttp://www.pacecomputers.co.uk
01142495665CAN STUDIOS LIMITEDComputer Software DevelopmentSHEFFIELDinfo@canstudios.comhttp://www.the-can.com
01142508889NEXUS DESIGN SOFTWARE LIMITEDComputer Software DevelopmentSHEFFIELDinfo@nexuscad.comhttp://www.nexusdesignsoftware.com
01142558599DEFACTO SOLUTIONS LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.defactosolutions.co.uk
01142580404EPITOMY SOLUTIONS LIMITEDComputer Software DevelopmentSHEFFIELDsales@epitomy.com
enquiries@epitomy.com
http://www.epitomy.com
01142580945XACTIUM LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.xactium.com
01142582400CIT DIGITAL LIMITEDComputer Software DevelopmentSHEFFIELDsales@citdigital.comhttp://www.citdigital.com
01142666030SB SOFTWARE LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.sbsoft.co.uk
01142668404LIGHTWORK DESIGN LIMITEDComputer Software DevelopmentCAMBERLEYhttp://www.lightworkdesign.com
01142668626RUBICON SOFTWARE CONSULTANTS LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.rubicon-consulting.net
01142679834HARCOURT SOFTWARE LIMITEDComputer Software DevelopmentSHEFFIELDadrian@ariley.co.ukhttp://www.ariley.co.uk
01142725011WILLIAM MATTHEW LIMITEDComputer Software DevelopmentDONCASTERhttp://www.wmltd.co.uk
01142725081CERTUS TECHNOLOGY ASSOCIATES LIMITEDComputer Software DevelopmentDEVONhttp://www.certus-tech.com
01142750096DUMPLING DESIGN LIMITEDComputer Software DevelopmentSHEFFIELD
01142757550BHP INFORMATION TECHNOLOGY LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.bhpit.co.uk
01142757580TALENT ON VIEW LTDComputer Software DevelopmentSHEFFIELDteam@tribepad.com
chris@tribepad.com
laura@tribepad.com
dan@tribepad.com
sam@tribepad.com
support@tribepad.com
http://www.tribepad.com
01142816060FRETWELL-DOWNING HOSPITALITY LIMITEDComputer Software DevelopmentSHEFFIELDinfo@fdhospitality.comhttp://www.fdhospitality.com
01142900150AUTODESK LIMITEDComputer Software DevelopmentFARNBOROUGHhttp://www.navisworks.com
01143030231BUSINESS CAREWARE LIMITEDComputer Software DevelopmentSHEFFIELDenquiries@bcluk.comhttp://www.bcluk.com
01143030422BUSINESS CAREWARE LIMITEDComputer Software DevelopmentSHEFFIELDenquiries@bcluk.comhttp://www.businesscareware.co.uk
01143072364TOBII DYNAVOX LIMITEDComputer Software DevelopmentWARWICKhttp://www.tobiidynavox.co.uk
01143454110TANGENTIX LIMITEDComputer Software DevelopmentMANCHESTERhttp://www.tangentix.com
01143491294ALCIUM SOFTWARE LIMITEDComputer Software DevelopmentSHEFFIELDinfo@alciumsoftware.comhttp://www.alciumsoftware.com
01143600302VINZENZ BUSINESS SOLUTIONS LTDComputer Software DevelopmentSHEFFIELDhttp://www.vinzenzbusinesssolutions.co.uk
01143830018VISUALWIND LTDComputer Software DevelopmentSHEFFIELDhello@visualwind.co.ukhttp://www.visualwind.co.uk
01143830152LACEGEM LIMITEDComputer Software DevelopmentMANCHESTERhttp://www.lacegem.co.uk
01143830187INVACORE LIMITEDComputer Software DevelopmentBIRMINGHAMhttp://www.invacoreuk.com
01143863186MAGNIFICA LTDComputer Software DevelopmentLONDONinfo@magnifica.co.ukhttp://www.magnifica.co.uk
01143992430R2C ONLINE LIMITEDComputer Software DevelopmentSHEFFIELDinfo@r2conline.comhttp://www.r2conline.com
01157100180ENSEK LTDComputer Software DevelopmentNOTTINGHAMenquiries@ensek.co.ukhttp://www.ensek.co.uk
01157141486SAVOY SYSTEMS LTDComputer Software DevelopmentNOTTINGHAMhttp://www.savoysystems.co.uk
01158226177NOBLUE LIMITEDComputer Software DevelopmentNOTTINGHAMhttp://www.noblue.co.uk
01158405500DATA TECHNOLOGIES LIMITEDComputer Software DevelopmentNOTTINGHAMSHIREhttp://www.DataTechnologies.co.uk
01158484977DATARICH SOLUTIONS LIMITEDComputer Software Developmenthttp://www.datarich.co.uk
01158712098MULTIPIE LTDComputer Software DevelopmentNOTTINGHAMhttp://www.multipie.co.uk
01159061120CST UK LIMITEDComputer Software DevelopmentNOTTINGHAMhttp://www.cst.com
01159201184OVALTECH LIMITEDComputer Software DevelopmentNOTTINGHAMhttp://www.ovaltech.ltd.uk
01159224115HAZID TECHNOLOGIES LTDComputer Software DevelopmentNOTTINGHAMhttp://www.hazid.com
01159225479NEAR FIELD SOLUTIONS LIMITEDComputer Software DevelopmentNOTTINGHAMhttp://www.usingnfc.com
01159331783Q4 TECHNOLOGIES LIMITEDComputer Software DevelopmentNOTTINGHAMhttp://www.q4technologies.com
01159380280FORWARD COMPUTERS LIMITEDComputer Software DevelopmentNOTTINGHAMsales@forwardcomputers.co.ukhttp://www.forwardcomputers.co.uk
01159404400TECHNICAL SIMULATION CONSULTANTS LIMITEDComputer Software DevelopmentCOLWICKhttp://www.tscsimulation.co.uk