Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:category::Conservation Organisations]]
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='23096')
)
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
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='23096')
)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 125 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id,o_id,s_id_2,o_id_2 | s_id | 4 | callto_wikidb.t4.s_id | 1 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | callto_wikidb.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NonePhone number | Company | Business category | Location | Company homepage | |
---|---|---|---|---|---|
01505844827 | EADHA ENTERPRISES | Conservation Organisations | LOCHWINNOCH | contact@eadha.co.uk | http://www.eadha.co.uk |
01508550003 | AURUM ECOLOGY LIMITED | Conservation Organisations | NORWICH | http://www.aurum-ecology.co.uk | |
01514234433 | THE CONSERVATION VOLUNTEERS | Conservation Organisations | SOUTH YORKS | tcv@plmr.co.uk c.gold@tcv.org.uk d.graham@tcv.org.uk d.keys@tcv.org.uk enquiries@tcv.org.uk information@tcv.org.uk corporate-enquiries@btcv.org.uk corporate-enquiries@tcv.org.uk supportus@btcv.org.uk | http://www.tcv.org.uk |
01517371819 | LANDLIFE WILDFLOWERS LIMITED | Conservation Organisations | LIVERPOOL | info@wildflower.org.uk info@landlife.org.uk | http://www.wildflower.org.uk |
01531636441 | THE VINCENT WILDLIFE TRUST | Conservation Organisations | LEDBURY | enquiries@vwt.org.uk | http://www.vwt.org.uk/ |
01538384017 | ROYAL SOCIETY FOR THE PROTECTION OF BIRDS | Conservation Organisations | http://www.rspb.org.uk | ||
01590623443 | ORANGUTAN APPEAL UK | Conservation Organisations | EFFINGHAM | http://www.orangutan-appeal.org.uk | |
01600740600 | GWENT WILDLIFE TRUST LTD | Conservation Organisations | MONMOUTH | info@gwentwildlife.org magormarsh@gwentwildlife.org info@wildlifetrustswales.org enquiry@wildlifetrusts.org nicholas.ramsay@assembly.wale lynne.neagle@assembly.wale john.griffiths@assembly.wale jayne.bryant@assembly.wale alun.davies@assembly.wale hefin.david@assembly.wale julie.morgan@assembly.wale jenny.rathbone@assembly.wale vaughan.gething@assembly.wale mick.antoniw@assembly.wale dawn.bowden@assembly.wale rhianon.passmore@assembly.wale mohammad.asghar@assembly.wale davidj.rowlands@assembly.wale mark.reckless@assembly.wale steffan.lewis@assembly.wale dstenner@gwentwildlife.org | http://www.gwentwildlife.org |
01603661662 | ROYAL SOCIETY FOR THE PROTECTION OF BIRDS | Conservation Organisations | http://www.rspb.org.uk | ||
01603814869 | NORFOLK FWAG | Conservation Organisations | NORWICH | http://www.norfolkfwag.co.uk | |
01604630719 | SOUTH COURT ENVIRONMENTAL LIMITED | Conservation Organisations | NORTHAMPTONSHIRE | ||
01612421400 | ENGLISH HERITAGE LIMITED | Conservation Organisations | SWINDON | customers@english-heritage.org.uk press@english-heritage.org.uk development@english-heritage.org.uk foi@english-heritage.org.uk content.objection@english-heritage.org.uk web-team@english-heritage.org.uk | http://www.english-heritage.org.uk |
01622662012 | KENT WILDLIFE TRUST | Conservation Organisations | MAIDSTONE | membership@kentwildlife.org.uk maureen.rainey@kentwildlife.org.uk marion.turner@kentwildlife.org.uk | http://www.kentwildlifetrust.org.uk |
01623821490 | THE SHERWOOD FOREST TRUST | Conservation Organisations | MANSFIELD | http://www.sherwoodforest.org.uk/xhtml/default.asp?UserLinkID=235617 | |
01625573807 | GRAHAM BARROW RESEARCH & CONSULTING LIMITED | Conservation Organisations | MACCLESFIELD | graham@gbrcltd.co.uk | http://www.grahambarrow.co.uk |
01629824904 | DERBYSHIRE HISTORIC BUILDINGS TRUST | Conservation Organisations | DERBYSHIRE | http://www.derbyshirehistoricbuildings.org.uk | |
01654700222 | ROYAL SOCIETY FOR THE PROTECTION OF BIRDS | Conservation Organisations | birdwatch@rspb.org.uk | http://www.rspb.org.uk | |
01671401423 | CREE VALLEY COMMUNITY WOODLANDS TRUST | Conservation Organisations | NEWTON STEWART | mail@creevalley.com | http://www.cvcwt.org.uk |
01708642970 | THAMES CHASE TRUST LIMITED | Conservation Organisations | PIKE LANE | http://www.thameschase.org.uk | |
01720422153 | ISLES OF SCILLY WILDLIFE TRUST LIMITED | Conservation Organisations | ISLES OF SCILLY | sarahmason@ios-wildlifetrust.org.uk paulasmith@ios-wildlifetrust.org.uk darrenmason@ios-wildlifetrust.org.uk darrenhart@ios-wildlifetrust.org.uk murrayguy@ios-wildlifetrust.org.uk robcarrier@ios-wildlifetrust.org.uk nikkibanfield@ios-wildlifetrust.org.uk | http://www.ios-wildlifetrust.org.uk |
01727250250 | GLOBAL VISION INTERNATIONAL LIMITED | Conservation Organisations | EXETER | http://www.gvi.co.uk | |
01738630804 | SCOTTISH ENVIRONMENT LINK | Conservation Organisations | PERTH | http://www.scotlink.org | |
01770600656 | COMMUNITY OF ARRAN SEABED TRUST LIMITED | Conservation Organisations | ISLE OF ARRAN | http://www.arrancoast.com | |
01772317247 | LANCASHIRE ENVIRONMENTAL FUND LIMITED | Conservation Organisations | PRESTON | andyrowett@lancsenvfund.org.uk johnphillips@lancsenvfund.org.uk annekingston@lancsenvfund.org.uk jennifertidy@lancsenvfund.org.uk | http://www.lancsenvfund.org.uk |
01772324436 | CUERDEN VALLEY PARK TRUST | Conservation Organisations | LANCS. | http://www.cuerdenvalleypark.org.uk | |
01790763194 | OPERATION WALLACEA LIMITED | Conservation Organisations | SPILSBY | info@opwall.com | http://opwall.com |
01792642972 | BUTTERFLY CONSERVATION | Conservation Organisations | WAREHAM | info@butterfly-conservation.org membership@butterfly-conservation.org news@butterfly-conservation.org fundraising@butterfly-conservation.org northernireland@btconnect.com scotland@butterfly-conservation.org wales@butterfly-conservation.org | http://www.butterfly-conservation.org |
01793414910 | ENGLISH HERITAGE LIMITED | Conservation Organisations | SWINDON | customers@english-heritage.org.uk press@english-heritage.org.uk development@english-heritage.org.uk foi@english-heritage.org.uk content.objection@english-heritage.org.uk web-team@english-heritage.org.uk | http://www.english-heritage.org.uk |
01793752413 | COTSWOLD WATER PARK SOCIETY LIMITED | Conservation Organisations | GLOUCESTERSHIRE | http://www.waterpark.org | |
01798875073 | SOUTH DOWNS SOCIETY | Conservation Organisations | PULBOROUGH | http://www.southdownssociety.org.uk | |
01822855700 | SOUTH WEST LAKES TRUST | Conservation Organisations | LIFTON | info@swlakestrust.org.uk lakeside@swlakestrust.org.uk roadfordwatersports@swlakestrust.org.uk wimbleball@swlakestrust.org.uk stithianswatersports@swlakestrust.org.uk siblybackreception@swlakestrust.org.uk tamarwatersports@swlakestrust.org.uk | http://www.swlakestrust.org.uk |
01822890646 | DARTMOOR PRESERVATION ASSOCIATION | Conservation Organisations | http://www.dartmoorpreservation.com | ||
01825890975 | CAMPAIGN TO PROTECT RURAL ENGLAND | Conservation Organisations | LONDON | info@cpresussex.org.uk | http://www.cpresussex.org.uk |
01863766702 | KYLE OF SUTHERLAND FISHERIES TRUST | Conservation Organisations | ARDGAY | admin@kylefisheries.org | http://www.kylefisheries.org |
01875813681 | CASTLES OF SCOTLAND PRESERVATION TRUST | Conservation Organisations | MOTHERWELL | http://www.cospt.org.uk | |
01902560065 | ALLEN-MARTIN CONSERVATION LIMITED | Conservation Organisations | BIRMINGHAM | http://www.allen-martin.co.uk | |
01903883355 | THE WILDFOWL & WETLANDS TRUST | Conservation Organisations | http://www.wildfowlwwt.org.uk | ||
01904601901 | ENGLISH HERITAGE LIMITED | Conservation Organisations | SWINDON | customers@english-heritage.org.uk press@english-heritage.org.uk development@english-heritage.org.uk foi@english-heritage.org.uk content.objection@english-heritage.org.uk web-team@english-heritage.org.uk | http://www.english-heritage.org.uk |
01904659570 | YORKSHIRE WILDLIFE TRUST | Conservation Organisations | YORK | http://www.ywt.org.uk | |
01905759759 | WORCESTERSHIRE BIOLOGICAL RECORDS CENTRE | Conservation Organisations | WORCESTER | records@wbrc.org.uk | http://www.wbrc.org.uk |
01912846884 | NORTHUMBERLAND WILDLIFE TRUST LIMITED | Conservation Organisations | JUBILEE ROAD | mail@northwt.org.uk | http://www.nwt.org.uk |
01914165454 | THE WILDFOWL & WETLANDS TRUST | Conservation Organisations | http://www.wwt.org.uk | ||
01933625527 | ROCKINGHAM FOREST TRUST | Conservation Organisations | STANWICK | http://www.rockingham-forest-trust.org.uk | |
01934522125 | KENNETH ALLSOP MEMORIAL TRUST LIMITED | Conservation Organisations | WESTON-SUPER-MARE | http://www.steepholm.org.uk | |
0193583923 | DAEDALUS CONSERVATION LIMITED | Conservation Organisations | BASINGSTOKE | ||
01938555654 | MONTGOMERYSHIRE WILDLIFE TRUST LIMITED | Conservation Organisations | WELSHPOOL | info@montwt.co.uk 555654info@montwt.co.uk | http://www.montwt.co.uk |
01950460800 | ROYAL SOCIETY FOR THE PROTECTION OF BIRDS | Conservation Organisations | http://www.rspb.org.uk | ||
01962851664 | THE CITY OF WINCHESTER TRUST LIMITED | Conservation Organisations | WINCHESTER | http://www.cityofwinchestertrust.co.uk | |
01970615081 | NEIL TAYLOR LIMITED | Conservation Organisations | SOUTHAMPTON | ||
01978710786 | WILDBANKS CONSERVATION LIMITED | Conservation Organisations | WREXHAM | http://www.wildbanksconservation.com |