Semantic search
From FANTOM5_SSTAR
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='UBERON:0010314') AND t1.p_id=574)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 80 | 100.00 | Using index condition; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | resource_browser.t1.s_id | 1 | 50.00 | Using where |
Query-Depth:1
is a:UBERON:0004733 (segmental subdivision of hindbrain),UBERON:0004756 (dermal skeletal element),UBERON:0005340 (dorsal telencephalic commissure),UBERON:0005383 (caudate-putamen),UBERON:0005432 (aortic sac),UBERON:0005641 (otocyst epithelium),UBERON:0005932 (bulb of hair follicle),UBERON:0005933 (hair root sheath),UBERON:0006858 (adrenal/interrenal gland),UBERON:0008895 (splanchnocranium),UBERON:0009494 (pharyngeal arch mesenchymal region),UBERON:0009526 (maxillary process mesenchyme),UBERON:0009662 (hindbrain nucleus),UBERON:0009663 (telencephalic nucleus),UBERON:0009899 (pole of cerebral hemisphere),UBERON:0010011 (collection of basal ganglia),UBERON:0010046 (entire pharyngeal arch associated mesenchyme),UBERON:0010092 (future metencephalon),UBERON:0010096 (future myelencephalon),UBERON:0010113 (future membranous labyrinth),UBERON:0010313 (neural crest-derived structure),UBERON:0010349 (otic capsule pre-cartilage condensation),UBERON:0010351 (otic capsule cartilage condensation),UBERON:0010743 (meningeal cluster),UBERON:0011299 (white matter of telencephalon),UBERON:0011300 (gray matter of telencephalon),UBERON:0011595 (jaw region),UBERON:0011932 (pilosebaceous unit),UBERON:0014371 (future telencephalon),UBERON:0016526 (lobe of cerebral hemisphere)