Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in anatomy facet::UBERON:0000073]]
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='UBERON:0000073') AND t1.p_id=687)
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
110
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:0000073') AND t1.p_id=687)
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
110
SQL Explain
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 | 201 | 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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneHuman (Homo sapiens)
- 10357-105E6 (cerebellum, newborn, donor10223)
- 10358-105E7 (substantia nigra, newborn, donor10223)
- 10360-105E9 (amygdala, newborn, donor10223)
- 10361-105F1 (medulla oblongata, newborn, donor10223)
- 10362-105F2 (locus coeruleus, newborn, donor10223)
- 10363-105F3 (hippocampus, newborn, donor10223)
- 10364-105F4 (globus pallidus, newborn, donor10223)
- 10365-105F5 (putamen, newborn, donor10223)
- 10366-105F6 (thalamus, newborn, donor10223)
- 10367-105F7 (globus pallidus, adult, donor10258)
- 10368-105F8 (medial frontal gyrus, adult, donor10258)
- 10370-105G1 (thalamus, adult, donor10258)
- 10371-105G2 (substantia nigra, adult, donor10258)
- 10372-105G3 (putamen, adult, donor10258)
- 10373-105G4 (parietal cortex, adult, donor10258)
- 10374-105G5 (hippocampus, adult, donor10258)
- 10375-105G6 (locus coeruleus, adult, donor10258)
- 10376-105G7 (medial temporal gyrus, adult, donor10258)
- 10377-105G8 (pineal gland, adult, donor10258)
- 10378-105G9 (pituitary gland, adult, donor10258)
- 11235-116D2 (Astrocyte - cerebral cortex, donor1)
- 11316-117D2 (Astrocyte - cerebral cortex, donor2)
- 11392-118C6 (Astrocyte - cerebral cortex, donor3)
- 11489-119E4 (Mouse Neurons - substantia nigra, donor4)
- 11490-119E5 (Mouse Neurons - substantia nigra, donor5)
- 11495-119F1
- 11500-119F6 (Astrocyte - cerebellum, donor1)
- 11550-120C2 (Mouse Astrocytes - cerebellar, donor2)
- 11551-120C3 (Mouse Astrocytes - hippocampus, donor2)
- 11575-120E9
- 11580-120F5 (Astrocyte - cerebellum, donor2)
- 11631-122C2
- 11632-122C3 (Mouse Astrocytes - hippocampus, donor3)
- 11642-122D4
- 11643-122D5 (Mouse Neurons - dorsal spinal cord, donor3)
- 11644-122D6 (Mouse Neurons - hippocampal, donor3)
- 11645-122D7 (Mouse Neurons - raphe, donor3)
- 11646-122D8 (Mouse Neurons - striatal, donor3)
- 11647-122D9 (Mouse Neurons - cortical, donor3)
- 11648-122E1 (Mouse Neurons - ventral spinal cord, donor3)
- 11649-122E2
- 11656-122E9
- 11661-122F5 (Astrocyte - cerebellum, donor3)
- 11708-123B7 (Mouse Astrocytes - cerebellar, donor1)
- 11709-123B8 (Mouse Astrocytes - hippocampus, donor1)
- 11719-123C9
- 11720-123D1 (Mouse Neurons - dorsal spinal cord, donor1)
- 11721-123D2 (Mouse Neurons - hippocampal, donor1)
- 11722-123D3 (Mouse Neurons - raphe, donor1)
- 11723-123D4 (Mouse Neurons - striatal, donor1)