Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:Organizations]] [[Industry sector::Professional and Technical]]
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='Professional and Technical') 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
55
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='Professional and Technical') 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
55
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 | 168 | 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 |
---|---|---|---|---|---|
1010 Magapp LLC | Computer Systems Design and Related Services | October 2012 | Active | ||
Accel Title Agency | Title Abstract & Settlement Offices | Active | |||
Acorn Tree Service | Other Professional / Scientific and Technical Services | Ohio | Wooster | Defunct | |
Adair and Adair - Attorneys | Attorneys' Private Practices | Defunct | |||
Adeo Photography | Professional / Scientific / and Technical Services | 2009 | Defunct | ||
Adrian W. Miller - Attorney | Legal Services | Defunct | |||
Advanced Animal Care | Veterinary Services | 2000 | Defunct | ||
Advanced Merchant Svc | All Other Professional, Scientific/Technical Svcs, | Defunct | |||
Advantage Tax Group | Accounting / Tax Preparation / Bookkeeping / and Payroll Services | Active | |||
Advertising Ideas Of Wooster | Advertising and Related Services | Ohio | Wooster | 2003 | Defunct |
Advertising Tapes | Other Services Related To Advertising | Defunct | |||
Affordable Justice LLC | Legal Services, | 2009 | Active | ||
Albright Brothers | Professional / Scientific / and Technical Services | Ohio | Wooster | 1872 | Defunct |
All About Animals Vet Svc LLC | Veterinary Services | Defunct | |||
All Around Photography | Professional / Scientific / and Technical Services | 2010 | |||
Allodial Solutions Inc | Other Computer Related Services, | 2003 | |||
Andrews Auctioneer | All Other Professional, Scientific/Technical Svcs, | 1971 | Active | ||
Anfang III, William F | Legal Services | Active | |||
Animal Clinic | Veterinary Services | ||||
Application Technology Research Unit | Research & Development In Biotechnology | 1981 | Active | ||
Ark Veterinary Hospital | Professional / Scientific / and Technical Services | Ohio | Wooster | 1992 | Active |
Aroma Lab | Research & Development In Biotechnology | 2009 | Active | ||
Art-Form Photography | , Professional / Scientific / and Technical Services | Active | |||
Ash, Michael J | Legal Services | Active | |||
Ashley Lindeman Photo LLC | , Professional / Scientific / and Technical Services, Portrait | 2014 | Active | ||
Asset Management Services Inc | All Other Professional, Scientific/Technical Svcs | 1991 | Defunct | ||
Astro Service Ctr Inc | All Other Professional, Scientific/Technical Svcs | ||||
Atnetplus Inc | Custom Computer Programming Services, Computer Systems Design Services | Defunct | |||
Baasten McKinley & Co LPA | Legal Services | ||||
Baltzly's Palace of Art | Professional / Scientific / and Technical Services | Ohio | Wooster | 1862 | Defunct |
Barkan Meizlish, LLP | Legal Services | Active | |||
Barnard Law Offices | Legal Services | Defunct | |||
Barrington Law Office | Legal Services | Active | |||
Beery Income Tax Svc | Accounting / Tax Preparation / Bookkeeping / and Payroll Services, | Defunct | |||
Biohio Research Park Inc | Marketing Research & Public Opinion Polling | 2010 | Active | ||
Birdeye | Computer Systems Design and Related Services | Ohio | Wooster | 2008 | Active |
Blake Stone Lpa | Legal Services | Active | |||
Bookkeeping & Tax Service LLC | Accounting / Tax Preparation / Bookkeeping / and Payroll Services, Accounting / Tax Preparation / Bookkeeping / and Payroll Services | Defunct | |||
Bookminders Inc | Accounting / Tax Preparation / Bookkeeping / and Payroll Services | Defunct | |||
Boosz | Professional / Scientific / and Technical Services | Defunct | |||
Bradley R Harp Attorney LLC | Legal Services | 2015 | Active | ||
Bringger & Smith | Professional / Scientific / and Technical Services | Defunct | |||
Broehl Law Office LLC | Legal Services | 1977 | Active | ||
Brown Law Office | Legal Services | 2013 | Active | ||
Bur Oak Consulting | Management / Scientific and Technical Consulting Services | Active | |||
Business Success Enterprises | Management / Scientific and Technical Consulting Services | Defunct | |||
C Biggs & Assoc | Management / Scientific and Technical Consulting Services | Ohio | Wooster | Active | |
CJS Office & Consulting Svc | , Process, Physical Distr/Logistics Consulting Svcs | Defunct | |||
Calais Fine Portraiture Inc | Professional / Scientific / and Technical Services, Professional / Scientific / and Technical Services | Active | |||
Calibration Services | Professional / Scientific / and Technical Services | 2001 | Defunct |