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::Charity Shops]]
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='6955')
  )
  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_id5const2978Using 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
01142725545CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01142753179AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01142753301BRITISH HEART FOUNDATIONCharity ShopsLONDONhttp://www.bhf.org.uk
01142787152DEPAUL UKCharity ShopsLONDON
01158419580SECOND CHANCE LIMITEDCharity ShopsLANCASHIRE
01159110301SECOND CHANCE LIMITEDCharity ShopsLANCASHIREhttp://www.carltoncommunitychurch.com
01159202608BRITISH HEART FOUNDATIONCharity ShopsLONDONhttp://www.bhf.org.uk
01159216276CANCER RESEARCH UKCharity ShopsLONDON
01159240800HEADWAY LIMITEDCharity ShopsLONDONhttp://www.headway.org.uk
01159254196CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159289165TREETOPS RETAIL LIMITEDCharity ShopsDERBYinfo@treetopshospice.org.ukhttp://www.treetopshospice.org.uk
01159308135BRITISH HEART FOUNDATIONCharity ShopsLONDONhttp://www.bhf.org.uk
01159336339CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159411561AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01159455078CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159463376BRITISH HEART FOUNDATIONCharity ShopsLONDONhttp://www.bhf.org.uk
01159465588THE MIND SHOP LIMITEDCharity ShopsWHITCHURCHstrategy@mind.org.uk
supporterservices@mind.org.uk
mindinfoteam@mind.org.uk
internalinfo@mind.org.uk
http://www.mind.org.uk
01159470186CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159523617ISCOUT LTDCharity ShopsDERBYwebmaster@notts-scouts.org.ukhttp://www.notts-scouts.org.uk
01159587671WHITE ROSE LIMITEDCharity ShopsLEEDShttp://www.whiteroseshop.com
01159589009BRITISH HEART FOUNDATIONCharity ShopsLONDONhttp://www.bhf.org.uk
01159625151SECOND CHANCE LIMITEDCharity ShopsLANCASHIRE
01159671057CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159678104BRITISH HEART FOUNDATIONCharity ShopsLONDONhttp://www.bhf.org.uk
01159691766CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159706806MY SIGHT LIMITEDCharity ShopsWOLVERHAMPTONinfo@mysightnotts.org.ukhttp://www.mysightnotts.org.uk
01159723960CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159770021CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159786133RADFORD CARE GROUPCharity ShopsNOTTINGHAMSHIREhttp://www.radfordcaregroup.org.uk
01159810503SHELTER LIMITEDCharity ShopsMANCHESTERhttp://www.shelter.org.uk
01159819360CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01159825028AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01159826008AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01159858735THE MIND SHOP LIMITEDCharity ShopsWHITCHURCHstrategy@mind.org.uk
supporterservices@mind.org.uk
mindinfoteam@mind.org.uk
internalinfo@mind.org.uk
http://www.mind.org.uk
01162354723LOROS LIMITEDCharity ShopsMANCHESTERhttp://www.loros.co.uk
01162460763AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01162518168CANCER RESEARCH UKCharity ShopsLONDONhttp://www.cancerresearchuk.org
01162518802AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01162556455OXFAMCharity ShopsOXFORDgivetime@oxfam.org.uk
enquiries@oxfam.org.uk
feedback@oxfam.org.uk
campaigning@oxfam.org.uk
education@oxfam.org.uk
events@oxfam.org.uk
fundraising@oxfam.org.uk
internationalprocurement@oxfam.org.uk
npbuying@oxfam.org.uk
oos@oxfam.org.uk
http://www.oxfam.org.uk
01162571277AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01162603062LOROS LIMITEDCharity ShopsMANCHESTERhttp://www.loros.co.uk
01162621220AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01162622250LEICESTER SECULAR SOCIETYCharity ShopsLEICESTER
01162624852SAMARITANSCharity ShopsEWELLsupportercare@samaritans.org
jo@samaritans.org
volunteering@samaritans.org
http://www.samaritans.org
01162628267BRITISH HEART FOUNDATIONCharity ShopsLONDONhttp://www.bhf.org.uk
01162672098AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01162706049AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01162710019AGE UKCharity ShopsLONDONhttp://www.ageuk.org.uk
01162720188LOROS LIMITEDCharity ShopsMANCHESTERhttp://www.loros.co.uk
01162734258THE MIND SHOP LIMITEDCharity ShopsWHITCHURCHstrategy@mind.org.uk
supporterservices@mind.org.uk
mindinfoteam@mind.org.uk
internalinfo@mind.org.uk
http://www.mind.org.uk