Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in disease facet::DOID:3095]]
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=17953)
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=17953)
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 | 33 | 0.15 | 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
NoneMouse (Mus musculus)
- 10555-107I6 (neuroblastoma cell line:NH-12)
- 10556-107I7
- 10585-108C9
- 10590-108D5 (testicular germ cell embryonal carcinoma cell line:NEC8)
- 10591-108D6 (testicular germ cell embryonal carcinoma cell line:NEC14)
- 10593-108D8 (testicular germ cell embryonal carcinoma cell line:NEC15)
- 10607-108F4 (neuroblastoma cell line:NBsusSR)
- 10618-108G6 (choriocarcinoma cell line:T3M-3)
- 10637-108I7 (neuroectodermal tumor cell line:FU-RPNT-1)
- 10663-109C6 (neuroectodermal tumor cell line:FU-RPNT-2)
- 10694-109G1 (tridermal teratoma cell line:HGRT)
- 10695-109G2 (sacrococcigeal teratoma cell line:HTST)
- 10697-109G4 (peripheral neuroectodermal tumor cell line:KU-SN)
- 10728-110A8 (neuroepithelioma cell line:SK-N-MC)
- 10749-110D2
- 10774-110F9 (neuroectodermal tumor cell line:TASK1)
- 10781-110G7 (somatostatinoma cell line:QGP-1)
- 10785-110H2 (choriocarcinoma cell line:SCH)
- 10786-110H3 (testicular germ cell embryonal carcinoma cell line:ITO-II)
- 10790-110H7 (teratocarcinoma cell line:NCC-IT-A3)
- 10798-110I6 (teratocarcinoma cell line:NCR-G1)
- 10799-110I7
- 10807-111A6 (teratocarcinoma cell line:PA-1)