Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:town::OXFORD]]
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='3321')
)
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='519' AND t4.o_id='3321')
)
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_3 | 9 | const,const | 1584 | 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 | |
---|---|---|---|---|---|
01189871890 | EFES GRILL LIMITED | Takeaway Food | OXFORD | http://www.efesgrill.co.uk | |
01189892222 | JAYLANE PROMOTION SERVICES LIMITED | Promotional Items & Incentives | OXFORD | info@fortunewest.co.uk | http://www.ait-uk.com |
01202395228 | OXFAM | Charity Shops | OXFORD | givetime@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 |
01202553000 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01202605362 | OXFAM | Charity Shops | OXFORD | givetime@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 |
01202721433 | OXFAM | Charity Shops | OXFORD | givetime@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 |
01202743838 | TOP WOK LIMITED | Takeaway Food | OXFORD | ||
01202805995 | BLUE NOTE SOLUTIONS LTD | Web Design & Development | OXFORD | http://www.bluenotesolutions.com | |
01204303219 | OXFAM | Charity Shops | OXFORD | givetime@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 |
01204363577 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01204386488 | BARKAT ENTERPRISE LTD | Grocers & Convenience Stores | OXFORD | ||
01206576156 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01206578477 | ANGELS HAIR DESIGN LIMITED | Hairdressers | OXFORD | ||
01209701431 | DIRECT LANDSCAPING LIMITED | Landscapers | OXFORD | http://www.direct-landscaping.co.uk | |
01209891223 | DIRECT LANDSCAPING LIMITED | Landscapers | OXFORD | http://www.direct-landscaping.co.uk | |
01212278570 | QODA CONSULTING (LONDON) LTD | Building Consultants | OXFORD | enquiries@qodaconsulting.com | http://www.qodaconsulting.com |
01212884747 | OYSTER TRAVEL LTD | Travel Agents & Services | OXFORD | http://www.oystertravel.co | |
01213514445 | CENTRE TANK SERVICES LIMITED | Oil Companies | OXFORD | enquiries@centretank.com | http://www.centretank.com |
01213557906 | OXFAM | Charity Shops | OXFORD | givetime@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 |
01213576900 | ESSENTIALS LTD | Tanning Salons | OXFORD | ||
01214274784 | OXFAM | Book Shops | OXFORD | givetime@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 |
01214512325 | CRASHPRICE LTD | Furniture - Retail | OXFORD | ||
01214711644 | SAH ENTERPRISES LIMITED | Jewellers | OXFORD | http://www.bournvilledesignerjewellery.co.uk | |
01215325509 | ANIMALTASTIC LIMITED | Educational Services | OXFORD | info@animal-tastic.co.uk | http://www.animal-tastic.co.uk |
01215523011 | TRUSCANIAN FOUNDRIES LIMITED | Metal Castings | OXFORD | info@wlucy.com | http://www.lucygroup.com |
01216433114 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01216631218 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01216666949 | RVB INVESTMENTS | Property Development | OXFORD | ||
01216844475 | FOOTSTEPS LTD | Foot Health | OXFORD | ||
01216933071 | SMALL WORLD NURSERY LIMITED | Day Nurseries | OXFORD | ||
01217114212 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01217331330 | FOOTSTEPS LTD | Shoe Shops | OXFORD | ||
01223209400 | SQW LIMITED | Management & Business Consultants | OXFORD | http://www.sqw.co.uk | |
01223321921 | OXFAM | Charity Shops | OXFORD | oxfamshopf2412@oxfam.org.uk | http://www.oxfam.org.uk/shop/local-shops/oxfam-shop-kings-lynn |
01223356347 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01223463200 | BLACKWELL UK LIMITED | Book Shops | OXFORD | blackwell.online@blackwell.co.uk | http://www.blackwell.co.uk |
01223861611 | PROTRONICS LIMITED | Electronic Engineers | OXFORD | http://www.protronics-uk.co.uk | |
01224637662 | OXFAM | Charity Shops | OXFORD | givetime@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 |
01224645103 | ANGELS HAIR DESIGN LIMITED | Hairdressers | OXFORD | info@angels-hair.co.uk | http://www.angels-hair.co.uk |
01225428008 | SOCIETY CAFE LIMITED | Cafes & Coffee Shops | OXFORD | contact@society-cafe.com | http://www.society-cafe.com |
01225442433 | SOCIETY CAFE LIMITED | Cafes & Coffee Shops | OXFORD | http://www.society-hafe.com | |
01225461650 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01227450201 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01227471141 | BANGKOK HOUSE LIMITED | Thai Restaurants | OXFORD | http://www.bangkok-house.co.uk | |
01227861149 | BLACKWELL LIMITED | Builders | OXFORD | ||
01228319874 | OAKMONT LIMITED | Painters & Decorators | OXFORD | ||
01233611604 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01233633274 | OXFAM | Charity Shops | OXFORD | givetime@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 |
01234215792 | MOSS LIMITED | Men's Clothes Hire | OXFORD | http://www.moss.co.uk | |
01234269204 | OXFAM | Charity Shops | OXFORD | givetime@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 |