Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in anatomy facet::UBERON:0002097]]
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:0002097') 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
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_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='UBERON:0002097') 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
0
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 | 96 | 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
NoneMouse (Mus musculus)
- 10065-101I2 (skin, fetal, donor1)
- 10074-102A2 (skin, adult, donor1)
- 10273-104E3
- 10283-104F4
- 10284-104F5
- 10285-104F6
- 10286-104F7 (Skin - palm, donor1)
- 10287-104F8
- 10288-104F9 (tongue epidermis (fungiform papillae), donor1)
- 10289-104G1
- 10301-104H4 (Fingernail (including nail plate, eponychium and hyponychium), donor2)
- 10311-104I5
- 10312-104I6
- 10313-104I7
- 10314-104I8
- 10315-104I9
- 10316-105A1
- 10317-105A2
- 10329-105B5
- 10339-105C6
- 10340-105C7
- 10341-105C8
- 10342-105C9
- 10343-105D1
- 10344-105D2
- 10345-105D3
- 10465-106H6 (melanoma cell line:G-361)
- 10514-107E1 (melanoma cell line:COLO 679)
- 10567-108A9
- 10600-108E6 (myxofibrosarcoma cell line:MFH-ino)
- 10602-108E8
- 10608-108F5
- 10684-109E9 (myxofibrosarcoma cell line:NMFH-1)
- 10702-109G9 (basal cell carcinoma cell line:TE 354.T)
- 10711-109H9 (fibrous histiocytoma cell line:GCT TIB-223)
- 10713-109I2
- 10791-110H8 (keratoacanthoma cell line:HKA-1)
- 10843-111E6 (merkel cell carcinoma cell line:MKL-1)
- 10844-111E7 (merkel cell carcinoma cell line:MS-1)
- 11220-116B5 (Sebocyte, donor1)
- 11269-116G9 (Fibroblast - Dermal, donor1)
- 11271-116H2 (Hair Follicle Dermal Papilla Cells, donor1)
- 11272-116H3 (Keratinocyte - epidermal, donor1)
- 11301-117B5 (Sebocyte, donor2)
- 11346-117G5 (Fibroblast - Dermal, donor2)
- 11348-117G7 (Hair Follicle Dermal Papilla Cells, donor2)
- 11349-117G8 (Keratinocyte - epidermal, donor2)
- 11378-118B1 (Sebocyte, donor3)
- 11418-118F5 (Fibroblast - Dermal, donor3)
- 11420-118F7 (Hair Follicle Dermal Papilla Cells, donor3)