Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in disease facet::DOID:7]]
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=722 AND t1.o_id=724)
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
10
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_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=722 AND t1.o_id=724)
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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | const | 172 | 0.03 | Using where; 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)
- 10466-106H7
- 10471-106I3 (renal cell carcinoma cell line:TUHR10TKB)
- 10482-107A5 (breast carcinoma cell line:MCF7)
- 10484-107A7 (hepatoma cell line:Li-7)
- 10490-107B4 (prostate cancer cell line:DU145)
- 10491-107B5
- 10496-107C1 (bile duct carcinoma cell line:TFK-1)
- 10512-107D8
- 10517-107E4
- 10518-107E5
- 10519-107E6
- 10532-107G1
- 10533-107G2
- 10536-107G5 (cholangiocellular carcinoma cell line:HuH-28)
- 10537-107G6
- 10540-107G9
- 10544-107H4 (oral squamous cell carcinoma cell line:SAS)
- 10545-107H5 (oral squamous cell carcinoma cell line:HSC-3)
- 10550-107I1 (oral squamous cell carcinoma cell line:HO-1-u-1)
- 10576-108B9
- 10578-108C2
- 10579-108C3
- 10582-108C6
- 10588-108D3
- 10597-108E3 (Wilms' tumor cell line:HFWT)
- 10599-108E5
- 10617-108G5
- 10627-108H6
- 10629-108H8
- 10630-108H9
- 10632-108I2
- 10633-108I3 (hepatoblastoma cell line:HuH-6)
- 10658-109C1
- 10660-109C3
- 10661-109C4
- 10665-109C8
- 10704-109H2 (osteoclastoma cell line:Hs 706.T)
- 10706-109H4 (pleomorphic hepatocellular carcinoma cell line:SNU-387)
- 10711-109H9 (fibrous histiocytoma cell line:GCT TIB-223)
- 10721-110A1 (leiomyoblastoma cell line:G-402)
- 10723-110A3 (pharyngeal carcinoma cell line:Detroit 562)
- 10731-110B2
- 10733-110B4
- 10739-110C1
- 10746-110C8
- 10747-110C9
- 10750-110D3
- 10772-110F7 (myelodysplastic syndrome cell line:SKM-1)
- 10779-110G5
- 10808-111A7 (hereditary spherocytic anemia cell line:WIL2-NS)