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::Computer Consultancy]]
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='890')
  )
  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_id5const2778Using 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
01162325232GIS COORDINATED LTDComputer ConsultancyLEICESTERhttp://www.gis-solved.com
01162427000BINARY STAR LIMITEDComputer ConsultancyLEICESTERhttp://www.binarystar.co.uk
01162555342TECHSPEEDY LIMITEDComputer ConsultancyLEICESTERsupport@techspeedy.co.ukhttp://www.techspeedy.co.uk
01162555524HAIGH CONSULTANCY SERVICES LIMITEDComputer ConsultancyLEICESTERasdfsa@asdfsa.comhttp://www.haigh-cs.co.uk
01162624825IT SOLUTIONS LTDComputer ConsultancyCHESTERhttp://www.itsolutions.uk.net
01162715538FISI LIMITEDComputer ConsultancyEDINBURGHhttp://www.fisiltd.co.uk
01162793673ACE COMPUTER SERVICES LIMITEDComputer ConsultancyLEICESTERhttp://www.netcomuk.co.uk
01162893830TECHNICALLYURS LIMITEDComputer ConsultancyLEICESTER
01163667020RCS TECHNOLOGIES LTDComputer ConsultancyLEICESTER
01172232166DERWENT VALLEY SOLUTIONS LIMITEDComputer ConsultancyBRIDGWATERhttp://www.derwent-valley.com
01173116461SAPPHIRE TECHNOLOGIES LIMITEDComputer ConsultancyDARLINGTONhttp://www.sapphire.net
01173182219FUTURE BOUND IT LTDComputer ConsultancyLONDON
01173308900COMPUTERNETWORKZ LTDComputer ConsultancyCHEPSTOWtony.castle@computernetworkz.co.ukhttp://www.computernetworkz.co.uk
01173620854IMAGEGLOW CONSULTANTS LIMITEDComputer ConsultancyBRISTOL
01173763477TECHMODAL LIMITEDComputer ConsultancyBRISTOLhttp://www.techmodal.com
01173900040BRISTOL TECHNOLOGY GROUP LTD.Computer ConsultancyBRISTOLhttp://www.bristoltechnology.com/
01174090106AMTER-COLLINS SOLUTIONS LTDComputer ConsultancyBRISTOLhttp://www.amter-collins.co.uk
01179048209XDELTA LIMITEDComputer ConsultancyBRISTOLhttp://www.xdelta.co.uk
01179077498NIMBOSTRATUS CONSULTING LTDComputer ConsultancyLONDONhttp://www.nimbostratusconsulting.co.uk
01179087573IT SOLUTIONS LTDComputer ConsultancyCHESTERhttp://www.nd-itsolutions.co.uk
01179091824DENLOR IT CONSULTANTS LIMITEDComputer ConsultancyBRISTOLhttp://www.syndec.net
01179141400INTELLIGENT CONSULTING LIMITEDComputer ConsultancyALRESFORD
01179152200APPLICABLE LIMITEDComputer ConsultancyHAMMERSMITHsales@applicable.com
apacsales@applicable.com
http://www.applicable.com
01179249780CABOT CONSULTING LTDComputer ConsultancyBRISTOLhttp://www.cabotconsultingltd.co.uk
01179251700IMPERIAL BUSINESS SYSTEMS LIMITEDComputer Consultancyhttp://www.ices.imperial.co.uk
01179423032XSYSTEMS CONSULTANTS LIMITEDComputer ConsultancyBRISTOLhttp://www.xsystems.co.uk
01179444949ITEAM SOLUTIONS LIMITEDComputer ConsultancyBRISTOLinfo@iteam.co.uk
hit@iteam.co.uk
http://www.iteam.co.uk
01179466800AUROS LIMITEDComputer ConsultancyLONDONhttp://www.auros.co.uk
01179467934KNOWLEDGE TO POWER LIMITEDComputer ConsultancyBRISTOL
01179511700VOODOO I.T. LIMITEDComputer ConsultancyBRISTOLhttp://www.voodooit.co.uk
01179599393MICROSYSTEM SUPPORT LIMITEDComputer ConsultancyBRISTOL
01179600318ALCAM CONSULTANTS LIMITEDComputer ConsultancyBRISTOL
01179681877PREMIUM SOURCE LTDComputer ConsultancyCARDIFF
01179745179STRIPE CONSULTING LIMITEDComputer ConsultancyHORLEYhttp://www.stripeconsulting.com
01179799283G D & H D CONSULTING LIMITEDComputer ConsultancyBRISTOL
01179855479U VIEW DATA LIMITEDComputer ConsultancyBRISTOLhttp://www.uviewdata.com
01179895969DL I.T. SOLUTIONS LIMITEDComputer ConsultancyBRISTOLhttp://www.dlitsolutions.co.uk
01183240042DATA UTILITIES LIMITEDComputer ConsultancyREADINGhttp://www.data-utilities.co.uk
01183241111CONSULT SPARK LTDComputer ConsultancyREADINGhttp://www.consultspark.co.uk
01183754789LOVATOS SOLUTIONS LIMITEDComputer ConsultancyREADING
01183800784AGILE TECH LTDComputer ConsultancyREADING
01189076320BIT WAVE SOLUTIONS LIMITEDComputer ConsultancyLONDONhttp://www.bitwavesolutions.com
01189090390COHORT PLCComputer ConsultancyTHEALEinfo@cohortplc.com
cohort@mhpc.com
http://www.cohortplc.com
01189241241TELEPHONE SYSTEMS LIMITEDComputer ConsultancyKETTERING NORTHANTShttp://www.prodec.co.uk
01189298098ENTECH SOLUTIONS LIMITEDComputer ConsultancyCOVENTRYhttp://www.entechsolutions.co.uk
01189310430SKY CONNECTION LIMITEDComputer ConsultancyREADING
01189328338CHARITY SOLUTIONS LIMITEDComputer ConsultancyST. AUSTELLsales@charitysolutions.co.ukhttp://www.charitysolutions.co.uk
01189344300AVR INTERNATIONAL LIMITEDComputer ConsultancyMAIDENHEADinfo@avr.co.ukhttp://www.avr.co.uk
01189357165THEMIS CONSULTING LIMITEDComputer ConsultancyLONDONinfo@themisconsulting.co.ukhttp://www.themisconsulting.co.uk
01189416490AGEX CONSULTING LIMITEDComputer ConsultancyREADING