Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:Organizations]] [[Industry sector::Health and Social Care]]
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_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=19678
AND (
(t4.o_hash='Health and Social Care') AND t4.p_id=57939)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
0
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_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=19678
AND (
(t4.o_hash='Health and Social Care') AND t4.p_id=57939)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
105
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | index_merge | s_id, o_hash, s_id_2, p_id | o_hash,p_id | 258,262 | 203 | Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | wcpl.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wcpl.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneOrganization | Sub-Industry | State | City | Established | Current status |
---|---|---|---|---|---|
A S A P Homecare & Home Nurses | Ambulatory Health Care Services | ||||
A. Humphreys, M.D., Physician and Surgeon | Ambulatory Health Care Service | Defunct | |||
A. Thomson - Dentist | Ambulatory Health Care Services | Defunct | |||
ASAP Homecare Inc | Ambulatory Health Care Services | 2003 | Active | ||
Acharya, Utkarsh MD | Ambulatory Health Care Services | Active | |||
Adult Geriatrics Of Wooster | Ambulatory Health Care Services | Active | |||
Advocacy & Protective Svc Inc | Other Individual & Family Services | Defunct | |||
Allergy & Asthma Treatment Ctr | Ambulatory Health Care Services | Active | |||
American Academy-Dermatology | Dermatology | Active | |||
American Cancer Society | Social Assistance | Ohio | Wooster | Active | |
American E M S | Ambulance Services | Active | |||
Amy Harp Healing Arts LLC | Ambulatory Health Care Services Massage Therapists | 2012 | Active | ||
Anazao Community Partners | Social Assistance | Ohio | Wooster | Active | |
Anesthesia Association | Ambulatory Health Care Services | Defunct | |||
Angel Private Duty Home Health | Ambulatory Health Care Services, Ambulatory Health Care Services | Defunct | |||
Apple Creek Developmental Center | Nursing and Residential Care Facilities | Defunct | |||
Arthritis Clinic | Ambulatory Health Care Services | 2006 | Active | ||
Arthur, Bruce MD | Ambulatory Health Care Services | Active | |||
Aspen Dental | Offices Of Dentists | ||||
Astreika, Vera MD | Ambulatory Health Care Services Office of Psychiatry | Active | |||
Athleticare | Ambulatory Health Care Services | Active | |||
Aultman Orrville Hospital | Hospital | 1951 | Active | ||
Autism Program | Ambulatory Health Care Services Autism Spectrum Disorders | Defunct | |||
Avada Audiology & Hearing Care | Ambulatory Health Care Services | Ohio | Wooster | Defunct | |
B & C Care Inc | Ambulatory Health Care Services | 2001 | |||
Bailey Rehabilitation Service | Social Assistance | Defunct | |||
Baker, Darby Np | Ambulatory Health Care Services | Active | |||
Barton, M G Np | Ambulatory Health Care Services | Active | |||
Bay, James H MD | Ambulatory Health Care Services | Active | |||
Beacon House | Social Assistance | Ohio | Wooster | Active | |
Beeson Clinic | Ambulatory Health Care Services Hospitals | Ohio | Wooster | 1936 | Defunct |
Big Brothers Big Sisters | Other Individual & Family Services | ||||
Biggio, A J DDS | , Offices Of Dentists | ||||
Block, Johnthan D Dc | Ambulatory Health Care Services | Active | |||
Bloomington Medical | Freestanding Ambulatory Surgical & Emergency Ctrs, Ambulatory Health Care Services | ||||
Bloomington Medical Svc | Ambulatory Health Care Services | ||||
Bonner, Cynthia R Lpn | Ambulatory Health Care Services, | Active | |||
Bowden & Associates | Ambulatory Health Care Services, Child & Youth Services, Other Individual & Family Services | 2016 | Active | ||
Boye, Harold MD | Ambulatory Health Care Services | ||||
Boys Village Inc | Other Nursing and Residential Care Facilities | 1945 | Active | ||
Bradley J Smith Dr | Offices Of Optometrists, Ambulatory Health Care Services | Active | |||
Brookdale Wooster | Nursing and Nursing and Residential Care Facilities | Active | |||
Brown's Dental Parlors | Ambulatory Health Care Services | Defunct | |||
Brown, Josephine H Do | , Ambulatory Health Care Services | ||||
Brown, Nick Dpm | Offices Of Podiatrists | ||||
Brzezowski, Kimberly | Ambulatory Health Care Services | Defunct | |||
Buckeye Dental | Offices Of Dentists | ||||
Burchfield, Janette L Np | Ambulatory Health Care Services | Active | |||
Butterbaugh, William MD | , Ambulatory Health Care Services | Defunct | |||
C. B. Mower, M.D., D.D.S. | Proprietorship | ||||
Cambridge Caretenders | Ambulatory Health Care Services, Ambulatory Health Care Services | Active | |||
Campbell Chiropractic Office | Ambulatory Health Care Services | Active | |||
Cancer Treatment Center LTD | Specialty (Exc Psychiatric/Substance Abuse) Hospital, Ambulatory Health Care Services | 1990 | Active | ||
Cardiology Specialists Inc | Ambulatory Health Care Services | Defunct | |||
Care 4 Kids Educational Child | Social Assistance | Ohio | Wooster | 1998 | Active |
Career Clothing Center | Religious / Grantmaking / Civil / Profession and Similar Organizations Social Assistance | Ohio | Wooster | Active | |
Caring Haven | Ambulatory Health Care Services | 2015 | Active | ||
Carr, Jessica L Lpn | Ambulatory Health Care Services, | Active | |||
Catholic Charities Wayne County | Other Individual & Family Services | Active | |||
Catholic Commission Of Wayne, Ashland, Medina | Other Individual & Family Services | Defunct | |||
Cebul, Robert D MD | Ambulatory Health Care Services General Surgery | Active | |||
Center For Occupational Med | Ambulatory Health Care Services | ||||
Cesare Behavioral Consltng LLC | Psychiatric & Substance Abuse Hospitals | ||||
Chaffee Chiropractic Clinic | Ambulatory Health Care Services | 1993 | Active | ||
Change Through Chance Inc | Ambulatory Health Care Services | 2006 | Defunct | ||
Charity's Home Care | Ambulatory Health Care Services | Defunct | |||
Chen Acupuncture Health Center | Ambulatory Health Care Services, Ambulatory Health Care Services | Active | |||
Chiropractic Health Center Inc | Ambulatory Health Care Services | Ohio | Doylestown | Active | |
Chowdhry Aqeel A MD | Ambulatory Health Care Services Radiology | Active | |||
Christian Children's Home of Ohio | Social Assistance | Ohio | Wooster | 1969 | Active |
Ciesa, Mary E Np | Ambulatory Health Care Services | Active | |||
Clark, Shane C MD | Ambulatory Health Care Services | ||||
Clark, Shane MD | Ambulatory Health Care Services | Active | |||
Cleartone Hearing Aid Svc | Ambulatory Health Care Services Health and Personal Care Stores | Ohio | Wooster | Active | |
Cleveland Clinic | Ambulatory Health Care Services, Ambulatory Health Care Services, Offices-Physical, Occptnl/Speech Thrpsts/Audlgsts | ||||
Cleveland Clinic Wooster | Ambulatory Health Care Services | Active | |||
Club-House Kids Day Care | Child Day Care Services | ||||
Cms & Co Management Svc Inc | Continuing Care Retirement Communities | ||||
College Avenue Home | Vocational Rehabilitation Services | ||||
College Of Wooster-Nursery | Child Day Care Services | 2000 | |||
Comfort Keepers | Ambulatory Health Care Services | 2008 | |||
Committee For Career | Vocational Rehabilitation Services | ||||
Commons Center | Nursing and Nursing and Residential Care Facilities | ||||
Community Action Wayne/Medina | Religious / Grantmaking / Civil / Profession and Similar Organizations Social Assistance | Ohio | Wooster | Active | |
Community Nephrology Svc Inc | Ambulatory Health Care Services | ||||
Community Service For The Deaf | Services For The Elderly/Persons With Disabilities | ||||
Comprehensive Family Mediation | Ambulatory Health Care Services | ||||
Comprehensive Internal Mdcn | Ambulatory Health Care Services | 2004 | |||
Comprehensive Psychological | Ambulatory Health Care Services, Social Assistance, Other Individual & Family Services | ||||
Counseling Center of Wayne and Holmes Counties | Social Assistance | Ohio | Wooster | 1953 | Active |
Country Acres | Nursing and Nursing and Residential Care Facilities | ||||
Country Pointe | Nursing and Nursing and Residential Care Facilities, Ambulatory Health Care Services | ||||
County Of Holmes | Other Individual & Family Services | ||||
Coveny Chiropractic | Ambulatory Health Care Services | ||||
Coveny Chiropractic Ctr | Ambulatory Health Care Services | ||||
Crouser, Kirk D MD | Ambulatory Health Care Services | Defunct | |||
Crowley, Paul J MD | , Ambulatory Health Care Services | ||||
Danbury Woods Of Wooster | Assisted Living Facilities For The Elderly | ||||
Danbury Woods Senior Living | Active | 1997 | |||
Davidson, Piper | Other Individual & Family Services |