Semantic search
From Bioblast
Debug output SQLStore
ASK Query
[[Was submitted to event::IOC116]]
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, idst5.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
(`smw_di_wikipage` AS t5
INNER JOIN
`smw_object_ids` AS idst5 ON idst5.smw_id=t5.o_id) ON t0.smw_id=t5.s_id
WHERE
(t1.p_id=80906 AND t1.o_id=35307)
AND (t5.p_id=80882)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
idst5.smw_sort ASC
LIMIT
35
OFFSET
9
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, idst5.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
(`smw_di_wikipage` AS t5
INNER JOIN
`smw_object_ids` AS idst5 ON idst5.smw_id=t5.o_id) ON t0.smw_id=t5.s_id
WHERE
(t1.p_id=80906 AND t1.o_id=35307)
AND (t5.p_id=80882)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
idst5.smw_sort ASC
LIMIT
35
OFFSET
9
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 | 10 | 2.07 | Using where; Using temporary; Using filesort |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneHas title | |
---|---|
Poddar 2016 Abstract IOC116 | Poddar J, Banerjee A, Mukherjee A, Chakrabarti S (2016) Effects of glucose hypometabolism on mitochondrial functions in rat brain and in SHSY5Y cells in culture. Mitochondr Physiol Network 21.11 |
Krizova 2016 Abstract IOC116 | Krizova J, Macakova M, Bohuslavova B, Klima J, Ellederova Z, Zeman J, Motlik J, Hansikova H (2016) Complex I-dependent respiration decline is a marker of Huntington`s disease in spermatozoa of transgenic minipig model. Mitochondr Physiol Network 21.11 |
Sobotka 2016 Abstract IOC116 | Sobotka O, Kucera Otto, Stankova P, Endlicher R, Nozickova K, Banni A, Cervinkova Z (2016) Mitochondrial respiration in fatty liver. Mitochondr Physiol Network 21.11 |
Morato 2016 Abstract IOC116 | Morato L, Guillot de Suduiraut MI, Grosse J, Zanoletti O, Riccio O, Fournier C, Sandi C (2016) Impaired mitochondrial function mediates early life stress-induced depression. Mitochondr Physiol Network 21.11 |
Komlodi 2016 Abstract IOC116 | Komlodi T, Geibl F, Sassani M, Adam-Vizi V, Tretter L (2016) The effect of ΔΨmt and ΔpH on mitochondrial reactive oxygen species production - A comparative study using mitochondria isolated from different mammalian tissues. Mitochondr Physiol Network 21.11 |
Cecatto 2016 Abstract IOC116 | Cecatto C, Silva JC, Wajner A, Godoy KS, Ribeiro, RT, Amaral AU, Wajner M (2016) cis-4-Decenoic and decanoic acids impair mitochondrial energy, redox and Ca2+ homeostasis and induce mitochondrial permeability transition pore opening in rat brain and liver. Mitochondr Physiol Network 21.11 |
Nielsen 2016 Abstract IOC116 | Nielsen B, Woertwein G, Cejvanovic V, Hansen AR, Weimann A, Bjerring PN, Poulsen HE, Joergensen MB (2016) The function of mitochondria and oxidative stress after antidepressants treatment in rats. Mitochondr Physiol Network 21.11 |
Wyss 2016 Abstract IOC116 | Wyss RK, Mendez-Carmona N, Nieves Sanz M, Tevaearai Stahel HT, Longnus SL (2016) Tolerance of cardiac mitochondria to ischemia and reperfusion. Mitochondr Physiol Network 21.11 |
Moore 2016 Abstract IOC116 | Moore AL (2016) Investigations into the multi-faceted roles of the alternative oxidases: are they a reflection of the nature of the hydrophobic cavity? Mitochondr Physiol Network 21.11 |