Semantic search
Debug output SQLStore
ASK Query
[[Category:Publications]]
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, t4.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=5352)
AND (t4.p_id=5194)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
25
OFFSET
20
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, t4.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_time` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=5352)
AND (t4.p_id=5194)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_sortkey DESC
LIMIT
25
OFFSET
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 434 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | www_public.t1.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, p_id, p_id_2, s_id_2 | s_id_2 | 8 | www_public.t1.s_id, const | 1 | Using index |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
NoneTitle | Authors | Published in | Date | |
---|---|---|---|---|
veyrin-forrer.22.dke | In Pursuit of the Hidden Features of GNN's Internal Representations | Luca Veyrin-Forrer, Ataollah Kamal, Stefan Duffner, Marc Plantevit, Céline Robardet | Data & Knowledge Engineering | 26 October 2022 |
movn.22.nips | Topology-Aware Method to Segment 3D Plan Tissue Images | Minh Ôn Vũ Ngoc, Nicolas Boutry, Jonathan Fabrizio | 36th Conference on Neural Information Processing SystemsAI for Science Workshop | 25 October 2022 |
veyrin-forrer.22.dami | On GNN Explainability with Activation Rules | Luca Veyrin-Forrer, Ataollah Kamal, Marc Plantevit, Céline Robardet, DuffnerStefan | Data Mining and Knowledge Discovery | 20 October 2022 |
esteban.22.gpce | The Cost of Dynamism in Static Languages for Image Processing | Baptiste Esteban, Edwin Carlinet, Guillaume Tochon, Didier Verna | Proceedings of the 21st International Conference on Generative Programming: Concepts & Experiences (GPCE 2022) | 10 October 2022 |
roynard.22.gpce | A Modern C++ Point of View of Programming in Image Processing | Michaël Roynard, Edwin Carlinet, Thierry Géraud | Proceedings of the 21st International Conference on Generative Programming: Concepts & Experiences (GPCE 2022) | 10 October 2022 |
zhao.22.iros | Multi-purpose Tactile Perception Based on Deep Learning in a New Tendon-driven Optical Tactile Sensor | Zhou Zhao, Zhenyu Lu | 2022 IEEE/RSJ International Conference on Intelligent Robots and Systems | 1 October 2022 |
duluard.22.mlsa | Discovering and Visualizing Tactics in Table Tennis Games Based on Subgroup Discovery | Pierre Duluard, Xinqing Li, Marc Plantevit, Céline Robardet, Romain Vuillemot | Machine Learning and Data Mining for Sports Analytics - 9th International Workshop, MLSA 2022 | 19 September 2022 |
kamal.22.xkdd | Improving the Quality of Rule-Based GNN Explanations | Ataollah Kamal, Elouan Vincent, Marc Plantevit, Céline Robardet | Workshop on eXplainable Knowledge Discovery in Data Mining. Machine Learning and Principles and Practice of Knowledge Discovery in Databases - International Workshops of ECML PKDD 2022, GrenobleFrance, September 19-23, 2022, Proceedings, Part I | 12 September 2022 |
fahrenberg.22.concur | A Kleene Theorem for Higher-Dimensional Automata | Uli Fahrenberg, Christian Johansen, Georg Struth, Krzysztof Ziemiański | 33rd International Conference on Concurrency Theory (CONCUR 2022) | 6 September 2022 |
newton.22.ifl | Comparing Use-Cases of Tree-Fold vs Fold-Left, How to Fold and Color a Map | Jim Newton | Symposium on Implementation and Application of Functional Languages | 31 August 2022 |
lepage.22.interspeech | Label-Efficient Self-Supervised Speaker Verification With Information Maximization and Contrastive Learning | Théo Lepage, Réda Dehak | Proc. Interspeech 2022 | 28 August 2022 |
moranges.22.taffc | Using subgroup discovery to relate odor pleasantness and intensity to peripheral nervous system reactions | Maelle Moranges, Marc Plantevit, Moustafa Bensafi | IEEE Transactions on Affective Computing | 24 July 2022 |
veyrin-forrer.22.ijcai | What Does my GNN Really Capture? On Exploring Internal GNN Representations | Luca Veyrin-Forrer, Ataollah Kamal, Stefan Duffner, Marc Plantevit, Céline Robardet | International Joint Conference on Artificial Intelligence 2022 | 23 July 2022 |
akshay.22.stacs | On Robustness for the Skolem and Positivity Problems | S Akshay, Hugo Bazille, Blaise Genest, Mihir Vahanwala | 39th International Symposium on Theoretical Aspects of Computer Science STACS | 7 July 2022 |
droste.22.iandc | Greibach normal form for ω-algebraic systems and weighted simple ω-pushdown automata | Manfred Droste, Sven Dziadek, Werner Kuich | Information and Computation | 30 June 2022 |
fahrenberg.22.iandc | Posets With Interfaces as a Model for Concurrency | Uli Fahrenberg, Christian Johansen, Georg Struth, Krzysztof Ziemiański | Information and Computation | 30 June 2022 |
esteban.22.gretsi.1 | Estimation de la fonction de niveau de bruit pour des images couleurs en utilisant la morphologie mathématique | Baptiste Esteban, Guillaume Tochon, Edwin Carlinet, Didier Verna | 28e Colloque sur le traitement du signal et des images | 15 June 2022 |
esteban.22.gretsi.2 | Généricité dynamique pour des algorithmes morphologiques | Baptiste Esteban, Edwin Carlinet, Guillaume Tochon, Didier Verna | 28e Colloque sur le traitement du signal et des images | 15 June 2022 |
duret.22.cav | From Spot 2.0 to Spot 2.10: What's New? | Alexandre Duret-Lutz, Etienne Renault, Maximilien Colange, Florian Renkin, Alexandre Gbaguidi Aisse, Philipp Schlehuber-Caissier, Thomas Medioni, Antoine Martin, Jérôme Dubois, Clément Gillard, Henrich Lauko | Proceedings of the 34th International Conference on Computer Aided Verification (CAV'22) | 6 June 2022 |
boutry.22.jmiv.2 | Some Equivalence Relation between Persistent Homology and Morphological Dynamics | Nicolas Boutry, Laurent Najman, Thierry Géraud | Journal of Mathematical Imaging and Vision | 17 May 2022 |