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
15
OFFSET
40
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
15
OFFSET
40
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 | |
---|---|---|---|---|
or.22.transparence | Données, Transparence et Démocratie | Olivier Ricou | 1 May 2022 | |
renkin.22.forte | Effective Reductions of Mealy Machines | Florian Renkin, Philipp Schlehuber-Caissier, Alexandre Duret-Lutz, Adrien Pommellet | Proceedings of the 42nd International Conference on Formal Techniques for Distributed Objects, Components, and Systems (FORTE'22) | 26 April 2022 |
paviot.22.forte | LTL under reductions with weaker conditions than stutter invariance | Emmanuel Paviot-Adet, Denis Poitrenaud, Etienne Renault, Yann Thierry-Mieg | Proceedings of the 41th IFIP International Conference on Formal Techniques for Distributed Objects, Components and Systems (FORTE'22) | 18 April 2022 |
esteban.22.icpr | Estimation of the noise level function for color images using mathematical morphology and non-parametric statistics | Baptiste Esteban, Guillaume Tochon, Edwin Carlinet, Didier Verna | Proceedings of the 26th International Conference on Pattern Recognition | 8 April 2022 |
abadie.22.das | A Benchmark of Named Entity Recognition Approaches in Historical Documents | Nathalie Abadie, Edwin Carlinet, Joseph Chazalon, Bertrand Duménieu | Proceedings of the 15th IAPR International Workshop on Document Analysis System | 7 April 2022 |
hermary.22.jmiv | Learning Grayscale Mathematical Morphology with Smooth Morphological Layers | Romain Hermary, Guillaume Tochon, Élodie Puybareau, Alexandre Kirszenberg, Jesús Angulo | Journal of Mathematical Imaging and Vision | 4 April 2022 |
veyrin-forrer.22.egc | Qu'est-ce que mon GNN capture vraiment ? Exploration des représentations internes d'un GNN | Luca Veyrin-Forrer, Ataollah Kamal, Stefan Duffner, Marc Plantevit, Céline Robardet | Extraction et Gestion des Connaissances, EGC 2022Blois, France, 24 au 28 janvier 2022 | 24 March 2022 |
shi.21.itip | Local Intensity Order Transformation for Robust Curvilinear Object Segmentation | Tianyi Shi, Nicolas Boutry, Yongchao Xu, Thierry Géraud | IEEE Transactions on Image Processing | 22 March 2022 |
tschora.22.apen | Electricity Price Forecasting on the Day-Ahead Market using Machine Learning | Léonard Tschora, Erwan Pierre, Marc Plantevit, Céline Robardet | Applied Energy | 10 March 2022 |
blin.22.tpds | Max-Tree Computation on GPUs | Nicolas Blin, Edwin Carlinet, Florian Lemaitre, Lionel Lacassagne, Thierry Géraud | IEEE Transactions on Parallel and Distributed Systems | 9 March 2022 |