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::43999 - Other specialised construction activities n.e.c.]]
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='3622')
  )
  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_id5const265Using 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
01323761202PEVENSEY COASTAL DEFENCE LIMITED43999 - Other specialised construction activities n.e.c.SEGENSWORTH WEST
01323892588MULTI GAS INSTALLATIONS LIMITED43999 - Other specialised construction activities n.e.c.CHARTHAM HATCH
01327315012A C & V LTD43999 - Other specialised construction activities n.e.c.ROYAL OAK INDUSTRIAL ESTATE
013327818712 C CONSTRUCTION LTD43999 - Other specialised construction activities n.e.c.DERBY
01344425881MACOR SERVICES LIMITED43999 - Other specialised construction activities n.e.c.BRACKNELL
01347822019R W ELLIS LIMITED43999 - Other specialised construction activities n.e.c.ADDINGHAM
01355220249DPG PLUS LTD43999 - Other specialised construction activities n.e.c.EAST KILBRIDEhttp://www.dpgplus.com
01362289341K G SADD PROPERTY MAINTENANCE LIMITED43999 - Other specialised construction activities n.e.c.SCARNING
01366328877ANGLIA STEEL PORTALS LIMITED43999 - Other specialised construction activities n.e.c.FOULDEN
01371879065COLEMAN ENGINEERING (STRUCTURAL) LIMITED43999 - Other specialised construction activities n.e.c.GREAT DUNMOW
01373834721A & B MAINTENANCE LTD43999 - Other specialised construction activities n.e.c.LUGWARDINEhttp://www.aandbmaintenance.co.uk
01376561752JAG INTERIORS LIMITED43999 - Other specialised construction activities n.e.c.DUCKEND GREENhttp://www.jaginteriors.co.uk
01377241524D & D TAYLOR ENGINEERING LIMITED43999 - Other specialised construction activities n.e.c.EAST RIDING
01379608777ON-LEVEL PAVING LIMITED43999 - Other specialised construction activities n.e.c.ERIDGE GREENpaving@on-level.co.ukhttp://www.on-level.co.uk
01380729612HAYES GFS LIMITED43999 - Other specialised construction activities n.e.c.BATH ROADhttp://www.hayes-gfs.com
01382522999J & M INTERIORS (SCOTLAND) LIMITED43999 - Other specialised construction activities n.e.c.BROUGHTY FERRYhttp://www.jandminteriors.co.uk
01383611710MAR SCAFFOLDING (SCOTLAND) LIMITED43999 - Other specialised construction activities n.e.c.CHURCH STREETenquiries@marscaffolding.co.ukhttp://www.marscaffolding.co.uk
01392824272DEVON ECO ENERGY LTD43999 - Other specialised construction activities n.e.c.BUSINESS INDUSTRIAL ESTATEsales@devonecoenergy.comhttp://www.devonecoenergy.com
01394282770MD BUILDING LTD43999 - Other specialised construction activities n.e.c.DWIGHT ROAD
01403257536SUSSEX SOLAR LIMITED43999 - Other specialised construction activities n.e.c.LONDON ROADhttp://www.sussexsolar.com
01403264140CLARKE FENCING LIMITED43999 - Other specialised construction activities n.e.c.ERNEST ROAD
01403864373FOWLER SWIMMING POOLS LIMITED43999 - Other specialised construction activities n.e.c.COWFOLDhttp://www.fowlergroup.co.uk
0140443203AS BUILDERS LIMITED43999 - Other specialised construction activities n.e.c.
01413328243FUSION MECHANICAL SERVICES LIMITED43999 - Other specialised construction activities n.e.c.http://www.fusionmechanical.co.uk
01422886699PARKING VENTILATION EQUIPMENT LTD43999 - Other specialised construction activities n.e.c.http://www.pveuk.com
01424231311NICHOLLS BROS (SUSSEX) LIMITED43999 - Other specialised construction activities n.e.c.BATTLE ROADnichollsbros@gmail.comhttp://www.nichollsbros.co.uk
01424442609FIRST FIRE PROTECTION LIMITED43999 - Other specialised construction activities n.e.c.16 STATION ROADwebmaster@lips.co.ukhttp://www.firstfire.co.uk
01425888909BOURNE SPECIAL PROJECTS LTD43999 - Other specialised construction activities n.e.c.PARKSTONEinfo.bgp@bournegroup.eu
sales@bournegroup.eu
http://www.bournegroup.eu
01435862784LANDSCAPE ENGINEERING LTD.43999 - Other specialised construction activities n.e.c.PADIHAM
01449614939CLARKE FENCING LIMITED43999 - Other specialised construction activities n.e.c.ERNEST ROADinfo@clarkefencing.co.ukhttp://www.clarkefencing.co.uk/?utm source=yell&utm medium=referral&utm campaign=yell
01452720546E J TAYLOR & SONS (GLOUCESTER) LIMITED43999 - Other specialised construction activities n.e.c.HARDWICKEenquiries@ejtaylorsonsgloucester.co.ukhttp://www.ejtaylorsonsgloucester.co.uk
01452731350G.B. FORKLIFTS LIMITED43999 - Other specialised construction activities n.e.c.http://www.gbforklifts.co.uk
01455449316CHESHIRE CEILINGS LTD43999 - Other specialised construction activities n.e.c.MARKET BOSWORTH
01472806149TRADE DOORS DIRECT LIMITED43999 - Other specialised construction activities n.e.c.UPPER FFOREST WAY
01474333635PAD PROPERTY CARE SERVICES LIMITED43999 - Other specialised construction activities n.e.c.HOLLY HILLhttp://www.padinteriorcontracts.co.uk
01474534119THAMESIDE CABINS LIMITED43999 - Other specialised construction activities n.e.c.BESSBOROUGH ROADinfo@thamesidecabins.com
thamesidecabins@aol.com
http://www.thamesidecabins.com
01480437774HERITAGE CONSERVATORIES LIMITED43999 - Other specialised construction activities n.e.c.FENTON WAYenquiries@heritageconservatories.co.ukhttp://www.heritageconservatories.co.uk
01480890652ECONERGY EUROPE LIMITED43999 - Other specialised construction activities n.e.c.EASTONsales@econergyeurope.comhttp://www.econergyeurope.com
01482481050S ZONE UK LIMITED43999 - Other specialised construction activities n.e.c.info@s-zone.co.ukhttp://www.s-zone.co.uk
01484600080CONCRETE GRINDING LIMITED43999 - Other specialised construction activities n.e.c.KIRKBURTONinfo@concrete-grinding.comhttp://www.concrete-grinding.com
01488668763A.J. WILLCOCK HOLEFORMERS LTD43999 - Other specialised construction activities n.e.c.INKPEN COMMON
01494413531FIRST FIRE PROTECTION LIMITED43999 - Other specialised construction activities n.e.c.16 STATION ROADhttp://www.firstfireprotection.co.uk
01494438288JAMES BUILDERS LTD43999 - Other specialised construction activities n.e.c.HANKHAM
01506880569G. ROSS CONTRACTORS LTD.43999 - Other specialised construction activities n.e.c.EAST CALDERhttp://www.rosscontractors.co.uk
01509815497R K N ALUMINIUM LIMITED43999 - Other specialised construction activities n.e.c.SILEBY
01512929454MSW LIMITED43999 - Other specialised construction activities n.e.c.http://www.mswservices.com
01522301289BIRKDALE DOORS (LINCOLNSHIRE) LIMITED43999 - Other specialised construction activities n.e.c.SKELLINGTHORPEinfo@bdlincoln.co.ukhttp://www.bdlincoln.co.uk
01522692572JMS LINCOLN LIMITED43999 - Other specialised construction activities n.e.c.WITHAM ST HUGHShttp://www.jmslincoln.com
01522787711BIRKDALE DOORS (LINCOLNSHIRE) LIMITED43999 - Other specialised construction activities n.e.c.SKELLINGTHORPEinfo@bdlincoln.co.ukhttp://www.bdlincoln.co.uk
01527911841S E DAVIS & SON LIMITED43999 - Other specialised construction activities n.e.c.info@sedavis.co.ukhttp://www.sedavis.co.uk