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::Agricultural Machinery]]
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='14047')
  )
  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_id5const643Using 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
 Companies:categoryCompanies:townCompanies:emailCompanies:homepageCompanies:phone
01243784411Agricultural MachineryWEST SUSSEXhttp://www.goodrowes.co.uk01243784411
01244324148Agricultural MachineryMANCHESTERhttp://www.spread-a-bale.com01244324148
01246475315Agricultural MachineryGRANTHAMhttp://www.setchfield.co.uk01246475315
01249651059Agricultural MachineryWILTS01249651059
01254826295Agricultural MachineryCLITHEROEhttp://www.rowlandtractors.co.uk01254826295
01254877011Agricultural MachineryACCRINGTONhttp://www.mjrobinsontractors.co.uk01254877011
01258441102Agricultural MachinerySTURMINSTER NEWTONinfo@tractorsuk.co.ukhttp://www.tractorsuk.co.uk01258441102
01258441640Agricultural MachineryDORSETinfo@candogardenmachinery.comhttp://www.candogardenmachinery.com01258441640
01258837166Agricultural MachinerySOMERSETsales@redlynchtractors.co.ukhttp://www.redlynchtractors.co.uk01258837166
01261839190Agricultural MachineryFORFAR01261839190
01262488275Agricultural MachineryEAST YORKSHIREhttp://www.cherryhire.co.uk01262488275
01262488341Agricultural MachineryDRIFFIELD01262488341
01264710900Agricultural MachineryMARLBOROUGHinfo@bdcsystems.comhttp://www.bdcsystems.com01264710900
01264811260Agricultural MachineryWILTSHIRE01264811260
01264860532Agricultural MachineryDEVIZEShttp://www.rhunt.co.uk01264860532
01267614379Agricultural MachineryCARMARTHENhttp://www.daviesimplementsltd.co.uk01267614379
01268533000Agricultural MachineryESSEXhttp://www.cnh.com01268533000
01270624141Agricultural MachineryCHESHIREenquiries@cornthwaiteag.co.ukhttp://www.cornthwaiteag.co.uk01270624141
01273834689Agricultural MachineryESSEXaccounts@ernestdoe.com
hayleyhill@ernestdoe.com
http://www.ernestdoe.com01273834689
01278662836Agricultural MachineryBRIDGWATERsales@compasstractors.co.ukhttp://www.compasstractors.co.uk01278662836
01280705353Agricultural MachineryBRACKLEYhttp://www.m-trac.co.uk01280705353
01282860444Agricultural MachineryCOLNEhttp://www.ggmgroundscare.com01282860444
01283814442Agricultural MachineryBURTON-ON-TRENTscottwallis@gmail.comhttp://www.rapidtractors.co.uk01283814442
01283821345Agricultural MachineryBURTON-ON-TRENTglennlogan@reavalleytractors.com
managerenquiries@reavalleytractors.com
http://www.reavalleytractors.com01283821345
01284388187Agricultural MachinerySUFFOLKhttp://www.overlandtractors.com01284388187
01284724455Agricultural MachineryBURY ST EDMUNDS01284724455
01284812060Agricultural MachineryCAMBRIDGESHIREhttp://www.tnsgroup.co.uk01284812060
01285652272Agricultural MachineryWALLINGFORDashford@listerwilder.co.uk
thornbury@listerwilder.co.uk
cirencester@listerwilder.co.uk
devizes@listerwilder.co.uk
guildford@listerwilder.co.uk
reading@listerwilder.co.uk
southam@listerwilder.co.uk
wallingford@listerwilder.co.uk
http://www.listerwilder.co.uk01285652272
01285720606Agricultural MachineryCHELTENHAMalex.fitzpatrick@cotswoldfarm.co.uk
george.pople@cotswoldfarm.co.uk
guy.medlicott@cotswoldfarm.co.uk
http://www.cotswoldfarm.co.uk01285720606
01286830918Agricultural MachineryCAERNARFONpost@menaitractors.comhttp://www.menaitractors.com01286830918
01289331904Agricultural MachineryBERWICK UPON TWEEDhttp://www.ancroft-tractors.co.uk01289331904
01290427000Agricultural MachineryGLASGOWhttp://www.pollockfarmequip.co.uk01290427000
01291673274Agricultural MachineryNEWPORT01291673274
01291689278Agricultural MachineryCHEPSTOWhttp://www.haroldrjohns.com01291689278
01291690205Agricultural MachineryROSS ON WYEpostroom@rossfarm.co.uk
martley@rossfarm.co.uk
raglan@rossfarm.co.uk
http://www.rossfarm.co.uk01291690205
01292541445Agricultural Machinery01292541445
01295680711Agricultural MachineryBANBURYhttp://brucehopkins.co.uk/01295680711
01299250922Agricultural MachineryDROITWICHmail@alo.uk.com
webmaster@alo.se
neil@alo.uk.com
rob@alo.uk.com
trudie@alo.uk.com
http://www.alo.uk.com01299250922
01299827002Agricultural MachineryWARWICKSHIREsales.warwick@murleyagriculture.co.uk
stourport.sales@murley-agri.co.uk
sales@murleyconstruction.co.uk
sales@murleygarden.co.uk
sales@murley-agri.co.uk
murley-stratford@hyundaidealer.co.uk
sales1642@murleyauto.co.uk
servicemanager1642@murleyauto.co.uk
info@murleystratford.citroen.co.uk
http://www.murleygroup.co.uk01299827002
01300348881Agricultural MachinerySHAFTESBURYhttp://www.smartagservices.co.uk01300348881
01302751200Agricultural MachineryDONCASTERhttp://www.amazone.co.uk01302751200
01302757550Agricultural MachineryDONCASTER01302757550
01302759969Agricultural MachineryDONCASTERhttp://www.moorefarmservicesltd.co.uk01302759969
01302786786Agricultural MachineryMARR01302786786
01303890056Agricultural MachineryFOLKESTONEhttp://www.cooktrailers.co.uk01303890056
01305266058Agricultural MachineryDORCHESTERinfo@highwood-ag.co.ukhttp://www.highwood-ag.co.uk01305266058
01305853900Agricultural MachineryDORCHESTERhttp://www.mjfry.co.uk01305853900
01307461222Agricultural MachineryFORFARenquiries@nethertontractors.co.ukhttp://www.nethertontractor.co.uk01307461222
01307462081Agricultural MachineryFORFARadmin@alanmackay.co.ukhttp://www.alanmackay.co.uk01307462081
01307462154Agricultural MachineryANGUScolin.duthie@agricar.co.uk
gordon.smith@agricar.co.uk
neil.keillor@agricar.co.uk
sandy.matthew@agricar.co.uk
http://www.agricar.co.uk01307462154