Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:town::ILFRACOMBE]]
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='34567')
)
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='34567')
)
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 | 80 | 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
NoneCompanies:company name | Companies:category | Companies:town | Companies:email | Companies:homepage | Companies:phone | |
---|---|---|---|---|---|---|
01335360332 | GREENDALE FARM LIMITED | Self Catering Holiday Accommodation | ILFRACOMBE | 01335360332 | ||
0140443945 | PACKMAN REMOVALS LIMITED | Domestic Removals & Storage | ILFRACOMBE | 0140443945 | ||
01536511166 | SOUTH LEIGH LIMITED | Residential & Retirement Homes | ILFRACOMBE | azalea@pathwayscaregroup.co.uk thurstonhouse@pathwayscaregroup.co.uk ashleighhouse@pathwayscaregroup.co.uk thehighlands@pathwayscaregroup.co.uk grizedale@pathwayscaregroup.co.uk grizedale@newlifecaregroup.co.uk alexandrahouse@pathwayscaregroup.co.uk newlands@pathwayscaregroup.co.uk parkdale@pathwayscaregroup.co.uk stanway@pathwayscaregroup.co.uk theknoll@pathwayscaregroup.co.uk westacres@pathwayscaregroup.co.uk westborough@pathwayscaregroup.co.uk famillehouse@pathwayscaregroup.co.uk honeysuckle@pathwayscaregroup.co.uk greenways@pathwayscaregroup.co.uk berrywoodlodge@pathwayscaregroup.co.uk fairhaven@pathwayscaregroup.co.uk northleigh@pathwayscaregroup.co.uk southleigh@pathwayscaregroup.co.uk hardridinghouse@newlifecaregroup.co.uk mountview@pathwayscaregroup.co.uk mountview@newlifecaregroup.co.uk newridley@pathwayscaregroup.co.uk newridley@newlifecaregroup.co.uk harmonyhouse@pathwayscaregroup.co.uk fairholme@pathwayscaregroup.co.uk wallace@pathwayscaregroup.co.uk avenueroad@pathwayscaregroup.co.uk bealeyslane@pathwayscaregroup.co.uk henleyhouse@pathwayscaregroup.co.uk westgate@pathwayscaregroup.co.uk kidderminster@pathways4care.co.uk sedgley@pathwayscaregroup.co.uk sedgely@pathwayscaregroup.co.uk beaconhurst@pathwayscaregroup.co.uk brinton@pathwayscaregroup.co.uk rosedene@pathwayscaregroup.co.uk rutlandvilla@pathwayscaregroup.co.uk | http://www.pathwayscaregroup.co.uk/specialist residential homes.html | 01536511166 |
01629825108 | ADVERSE CAMBER LTD | Music Management & Promotion | ILFRACOMBE | hello@adversecamber.org | http://www.adversecamber.org | 01629825108 |
01633873196 | ROB WILLIAMS LTD | Builders | ILFRACOMBE | 01633873196 | ||
01769572841 | THE DESTINATION LOUNGE LIMITED | Travel Agents & Services | ILFRACOMBE | http://www.thedestinationlounge.co.uk | 01769572841 | |
01795536514 | MARCH COTTAGE LTD | Bed & Breakfast | ILFRACOMBE | sarah@marchcottagebandb.co.uk | http://www.marchcottagebandb.co.uk | 01795536514 |
01977612150 | THE PRECINCT LIMITED | Cafes & Coffee Shops | ILFRACOMBE | 01977612150 | ||
02033279900 | CRAFTED LTD | Web Design & Development | ILFRACOMBE | http://www.crafted.co.uk | 02033279900 | |
02071939748 | TWENTY-4 SEVEN GLOBAL MEDIA LIMITED | Broadcasting Services | ILFRACOMBE | http://www.247webcasting.com | 02071939748 | |
02081442350 | MULTITOUCH DISPLAYS LTD | Audio-visual Equipment | ILFRACOMBE | http://www.multitouchdisplays.co.uk | 02081442350 | |
02392475474 | CAPTAIN JACKS LIMITED | Fish & Chip Shops & Restaurants | ILFRACOMBE | 02392475474 | ||
02828272661 | T HATCH LIMITED | Pubs | ILFRACOMBE | 02828272661 | ||
02842757436 | VIP BEAUTY LTD | Mobile Beauty Therapists | ILFRACOMBE | 02842757436 | ||
07456170207 | NORTH DEVON DECORATORS LTD | Painters & Decorators | ILFRACOMBE | 07456170207 | ||
07539424992 | ROB WILLIAMS LTD | Health Food Suppliers | ILFRACOMBE | http://www.robwilliams.eu.nspshop.com | 07539424992 | |
07580255791 | H & A CATERING LTD. | Caterers | ILFRACOMBE | coastcreative@btinternet.com | http://www.hacatering.biz | 07580255791 |
07764185050 | VIP BEAUTY LTD | Beauty Salons & Consultants | ILFRACOMBE | 07764185050 | ||
07775644503 | HARBOUR COTTAGES LIMITED | Self Catering Holiday Accommodation | ILFRACOMBE | tricia@harbour-cottages.co.uk | http://www.harbour-cottages.co.uk | 07775644503 |
07789807424 | H2OUTDOOR LIMITED | Outdoor Pursuits | ILFRACOMBE | info@h2outdoor.co.uk | http://www.h2outdoor.co.uk | 07789807424 |
07801978910 | ROB WILLIAMS LTD | Hypnotherapists | ILFRACOMBE | http://www.robwilliamshypnotherapy.co.uk | 07801978910 | |
07807260853 | FIRETHOUGHT LTD | Tv, Film & Video Production Services | ILFRACOMBE | http://www.firethought.net | 07807260853 | |
07831801792 | DR SERVICES LIMITED | Motorcycle Repairs & Services | ILFRACOMBE | http://www.dr-services.co.uk | 07831801792 | |
07857798105 | DR SERVICES LIMITED | Window Cleaners | ILFRACOMBE | 07857798105 | ||
07870390158 | COASTAL ENGINEERING SERVICES LIMITED | Steel Fabrications | ILFRACOMBE | 07870390158 | ||
07885512506 | RV INSTALLATIONS LIMITED | Home Cinema | ILFRACOMBE | http://www.facebook.com/rv.installations | 07885512506 | |
07888777552 | REDWOOD ENTERPRISING LIMITED | Job Centres | ILFRACOMBE | http://www.redwoodenterprising.com | 07888777552 | |
07970636331 | CRABB CONTRACTORS LTD | Paving & Driveways | ILFRACOMBE | paul@crabbcontractors.com | http://www.crabbcontractors.com | 07970636331 |
07976914308 | DR SERVICES LIMITED | Trailer Hire | ILFRACOMBE | 07976914308 | ||
08442092646 | COUNTRY COUSINS LTD | Home Care Services | ILFRACOMBE | http://www.country-cousins.co.uk | 08442092646 |