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:town::BUNTINGFORD]]
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='519' AND t4.o_id='25497')
  )
  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_id_39const,const89Using 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
 Companies:company nameCompanies:categoryCompanies:townCompanies:emailCompanies:homepageCompanies:phone
01763289285DRY ELECTRIC LIMITEDElectricians & Electrical ContractorsBUNTINGFORD01763289285
01763289875FRESH PERSPECTIVE ASSOCIATES LTDManagement & Business ConsultantsBUNTINGFORDhttp://www.fresh-perspective.co.uk01763289875
01763293030M D WATSON LIMITEDDouble Glazing InstallersBUNTINGFORDmmja@btinternet.comhttp://www.mdwatson.co.uk01763293030
01763848011STAGESTRUCK LIMITEDConference & Event ManagementBUNTINGFORDhttp://www.stagestruck.com01763848011
01763849496MARTINS PLANTS LTDRetail Horticultural NurseriesBUNTINGFORDhttp://www.villagetrees.com01763849496
01763849995AUTO FINESSE LIMITEDCleaning Materials & SuppliesBUNTINGFORDhttp://www.autofinesse.co.uk01763849995
01799513376FLAWLESS FLOORING (UK) LIMITEDFlooring ServicesBUNTINGFORDhttp://www.flawlessflooring.org.uk01799513376
01799695027CLS ROOFING SPECIALISTS LIMITEDRoofing ServicesBUNTINGFORD01799695027
01992441076LANES OF LONDON LTDDiscount StoresBUNTINGFORD01992441076
01992463920COLLINS ROOFING SERVICES LTDRoofing ServicesBUNTINGFORD01992463920
01992503111SELECTION & SEARCH ASSOCIATES LIMITEDRecruitment ConsultantsBUNTINGFORDhttp://www.selection-search.co.uk01992503111
01992536029PATRICK PHOTOGRAPHER LIMITEDGeneral PhotographersBUNTINGFORDinfo@patrickphotographer.comhttp://www.patrickphotographer.com01992536029
01992581374STUDIO 28 INTERIORS LIMITEDInterior DesignersBUNTINGFORDinfo@s28interiors.comhttp://www.s28interiors.com/01992581374
01993775501CRESCENT CARS LIMITEDTaxis & Private Hire VehiclesBUNTINGFORD01993775501
02080997766ELSTREE HELICOPTERS LIMITEDFlying SchoolsBUNTINGFORDinfo@elstreehelicopters.co.ukhttp://www.heliservices.co.uk02080997766
02089513916PREMIER AUTO CARE LIMITEDGarage ServicesBUNTINGFORDhttp://www.premierautocare.net02089513916
02882243555ANTOINETTE LIMITEDHairdressersBUNTINGFORD02882243555
02887725892GLEN MOORE LIMITEDComputer RepairsBUNTINGFORD02887725892
07515880690NAGCABS LTDHorse Transporter OperatorsBUNTINGFORDhttp://www.nagcabs.com07515880690
07747064824PREMIER AUTO CARE LIMITEDCar Body RepairsBUNTINGFORD07747064824
07767615267NJE CLEANING SERVICES LIMITEDDomestic CleaningBUNTINGFORD07767615267
07768858439THE MAGIC VIDEO COMPANY LIMITEDTv, Film & Video Production ServicesBUNTINGFORDhttp://www.themagicvideocompany.co.uk/index.html07768858439
07772191345HIM & TEAM LIMITEDBuildersBUNTINGFORDhttp://www.homeimprovementman.co.uk07772191345
07778669007MARK THOMAS PHOTOGRAPHY LIMITEDGeneral PhotographersBUNTINGFORDmarkthomasphotos@blueyonder.co.ukhttp://www.markthomasphotos.com07778669007
07792722339D M GAS SOLUTIONS LTDGas EngineersBUNTINGFORD07792722339
07852314881NICHE LEARNING PROGRAMMES LIMITEDTraining ServicesBUNTINGFORDhttp://www.nichelearning.co.uk07852314881
07894666101CELESTIAL BODIES LIMITEDPersonal TrainersBUNTINGFORD07894666101
07903768654C K PLASTERING LIMITEDPlastering & ScreedingBUNTINGFORD07903768654
07905234687DRAGE CONSULTANCY LIMITEDMarketing & Advertising ConsultantsBUNTINGFORD07905234687
07931250890C K PLASTERING LIMITEDPlastering & ScreedingBUNTINGFORDhttp://tinyurl.com/pmx777k07931250890
07960208284AJS PAINTERS & DECORATORS LIMITEDPainters & DecoratorsBUNTINGFORDajstewart40@yahoo.co.ukhttp://www.ajspainters.iconosites.com07960208284
07962141178SIMON CLARK LIMITEDSign WritersBUNTINGFORD07962141178
07966159775COUNTRY PROMOTIONS LIMITEDParty Planners & OrganisersBUNTINGFORDali@countrypromotions.comhttp://www.countrypromotions.com07966159775
07967963479RYEDALE EUROPE LIMITEDInvestment ConsultantsBUNTINGFORDhttp://www.ryedale.com/?utm source=yell&utm medium=referral&utm campaign=yell07967963479
07976762990D A ROWLEY LIMITEDBuildersBUNTINGFORDhttp://www.darowley.com07976762990
07977871805SCUFF WHEELS LIMITEDCycle Shops & RepairsBUNTINGFORDhttp://www.scuffwheels.co.uk07977871805
07980919444COLLINS ROOFING SERVICES LTDRoofing ServicesBUNTINGFORD07980919444
08003800716HOME & AWAY SURVEILLANCE LIMITEDCctv InstallersBUNTINGFORD08003800716
08453701070ORBITAL TRAVEL LIMITEDTravel Agents & ServicesBUNTINGFORDenquiries@orbitaltravel.co.uk
nomad.justin@yahoo.com
info@orbitaltravel.co.uk
http://www.orbitaltravel.co.uk08453701070