Semantic search
From FANTOM5_SSTAR
Debug output SQLStore
ASK Query
[[Ancestors in cell lineage facet::CL:0000738]]
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='CL:0000738') AND t1.p_id=686)
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
30
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='CL:0000738') AND t1.p_id=686)
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
30
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 | 647 | 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)
- 10704-109H2 (osteoclastoma cell line:Hs 706.T)
- 10711-109H9 (fibrous histiocytoma cell line:GCT TIB-223)
- 10712-109I1 (hairy cell leukemia cell line:Mo)
- 10725-110A5
- 10731-110B2
- 10744-110C6 (mycosis fungoides, T cell lymphoma cell line:HuT 102 TIB-162)
- 10745-110C7
- 10768-110F3
- 10773-110F8
- 10775-110G1 (lymphoma, malignant, hairy B-cell cell line:MLMA)
- 10777-110G3 (NK T cell leukemia cell line:KHYG-1)
- 10795-110I3 (anaplastic large cell lymphoma cell line:Ki-JK)
- 10808-111A7 (hereditary spherocytic anemia cell line:WIL2-NS)
- 10821-111C2 (B lymphoblastoid cell line: GM12878 ENCODE, biol_rep1)
- 10822-111C3 (B lymphoblastoid cell line: GM12878 ENCODE, biol_rep2)
- 10823-111C4 (B lymphoblastoid cell line: GM12878 ENCODE, biol_rep3)
- 10840-111E3 (plasma cell leukemia cell line:ARH-77)
- 11224-116B9 (CD14+ Monocytes, donor1)
- 11225-116C1 (CD4+ T Cells, donor1)
- 11226-116C2 (CD8+ T Cells, donor1)
- 11227-116C3 (Dendritic Cells - monocyte immature derived, donor1)
- 11228-116C4 (Dendritic Cells - plasmacytoid, donor1)
- 11229-116C5 (CD14+ monocyte derived endothelial progenitor cells, donor1)
- 11230-116C6 (Natural Killer Cells, donor1)
- 11231-116C7 (Peripheral Blood Mononuclear Cells, donor1)
- 11232-116C8 (Macrophage - monocyte derived, donor1)
- 11233-116C9 (Neutrophils, donor1)
- 11305-117B9 (CD14+ Monocytes, donor2)
- 11306-117C1 (CD4+ T Cells, donor2)
- 11307-117C2 (CD8+ T Cells, donor2)
- 11308-117C3 (Dendritic Cells - monocyte immature derived, donor2)
- 11309-117C4 (Dendritic Cells - plasmacytoid, donor2)
- 11310-117C5 (CD14+ monocyte derived endothelial progenitor cells, donor2)
- 11311-117C6 (Natural Killer Cells, donor2)
- 11312-117C7 (Peripheral Blood Mononuclear Cells, donor2)
- 11313-117C8 (Macrophage - monocyte derived, donor2)
- 11314-117C9 (Neutrophils, donor2)
- 11381-118B4 (CD14+ Monocytes, donor3)
- 11382-118B5 (CD4+ T Cells, donor3)
- 11383-118B6 (CD8+ T Cells, donor3)
- 11384-118B7 (Dendritic Cells - monocyte immature derived, donor3)
- 11385-118B8 (Dendritic Cells - plasmacytoid, donor3)
- 11386-118B9 (CD14+ monocyte derived endothelial progenitor cells, donor3)
- 11387-118C1 (Natural Killer Cells, donor3)
- 11388-118C2 (Peripheral Blood Mononuclear Cells, donor3)
- 11389-118C3 (Macrophage - monocyte derived, donor3)
- 11390-118C4 (Neutrophils, donor3)
- 11486-119E1
- 11487-119E2 (Mast cell - stimulated, donor1)
- 11501-119F7