Semantic search
Debug output SQLStore
ASK Query
[[Category:Publications]] [[Publication type::article]]
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, t7.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_time` AS t7 ON t0.smw_id=t7.s_id
WHERE
(t2.o_id=5352
AND (
(t4.o_hash='article') AND t4.p_id=5218)
)
AND (t7.p_id=5194)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_sortkey DESC
LIMIT
25
OFFSET
50
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, t7.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_time` AS t7 ON t0.smw_id=t7.s_id
WHERE
(t2.o_id=5352
AND (
(t4.o_hash='article') AND t4.p_id=5218)
)
AND (t7.p_id=5194)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t7.o_sortkey DESC
LIMIT
25
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id, s_id_2, o_hash, p_id | o_hash | 258 | const | 86 | Using index condition; Using where; Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | www_public.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | www_public.t4.s_id | 1 | Using where | |
1 | SIMPLE | t7 | ref | s_id, p_id, p_id_2, s_id_2 | s_id_2 | 8 | www_public.t4.s_id, const | 1 | Using index |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneTitle | Authors | Published in | Date | |
---|---|---|---|---|
demaille.17.sacs | Derived-Term Automata of Multitape Expressions with Composition | Akim Demaille | Scientific Annals of Computer Science | 29 December 2017 |
boutry.17.jmiv | A Tutorial on Well-Composedness | Nicolas Boutry, Thierry Géraud, Laurent Najman | Journal of Mathematical Imaging and Vision | 12 October 2017 |
rusinol.17.mtap | Augmented Songbook: an Augmented Reality Educational Application for Raising Music Awareness | Marçal Rusiñol, Joseph Chazalon, Katerine Diaz-Chito | Multimedia Tools and Applications | 29 June 2017 |
tochon.17.tgrs | Object tracking by hierarchical decomposition of hyperspectral video sequences: Application to chemical gas plume tracking | Guillaume Tochon, Jocelyn Chanussot, Mauro Dalla Mura, Andrea Bertozzi | IEEE Transactions on Geoscience and Remote Sensing | 20 April 2017 |
xu.16.prl | Hierarchical image simplification and segmentation based on Mumford-Shah-salient level line selection | Yongchao Xu, Thierry Géraud, Laurent Najman | Pattern Recognition Letters | 20 May 2016 |
xu.16.pami | Hierarchical Segmentation Using Tree-Based Shape Spaces | Yongchao Xu, Edwin Carlinet, Thierry Géraud, Laurent Najman | IEEE Transactions on Pattern Analysis and Machine Intelligence | 11 April 2016 |
fabrizio.16.ijdar | TextCatcher: A method to detect curved and challenging text in natural scenes | Jonathan Fabrizio, Myriam Robert-Seidowsky, Séverine Dubuisson, Stefania Calarasanu, Raphaël Boissel | International Journal on Document Analysis and Recognition | 8 April 2016 |
calarasanu.16.ivc | What is a good evaluation protocol for text localization systems? Concerns, arguments, comparisons and solutions | Stefania Calarasanu, Jonathan Fabrizio, Séverine Dubuisson | Image and Vision Computing | 1 February 2016 |
renault.16.sttt | Variations on Parallel Explicit Model Checking for Generalized Büchi Automata | Etienne Renault, Alexandre Duret-Lutz, Fabrice Kordon, Denis Poitrenaud | International Journal on Software Tools for Technology Transfer (STTT) | 26 October 2015 |
carlinet.15.itip | MToS: A Tree of Shapes for Multivariate Images | Edwin Carlinet, Thierry Géraud | IEEE Transactions on Image Processing | 26 October 2015 |
xu.15.pami | Connected Filtering on Tree-Based Shape-Spaces | Yongchao Xu, Thierry Géraud, Laurent Najman | IEEE Transactions on Pattern Analysis and Machine Intelligence | 5 June 2015 |
xu.14.itip | Tree-Based Morse Regions: A Topological Approach to Local Feature Detection | Yongchao Xu, Thierry Géraud, Pascal Monasse, Laurent Najman | IEEE Transactions on Image Processing | 3 October 2014 |
carlinet.14.itip | A Comparative Review of Component Tree Computation Algorithms | Edwin Carlinet, Thierry Géraud | IEEE Transactions on Image Processing | 16 June 2014 |
duret.14.ijccbs | LTL Translation Improvements in Spot 1.0 | Alexandre Duret-Lutz | International Journal on Critical Computer-Based Systems | 6 March 2014 |
fabrizio.13.paa | Text detection in street level image | Jonathan Fabrizio, Beatriz Marcotegui, Matthieu Cord | Pattern Analysis and Applications | 5 November 2013 |
shum.13.taslp | Unsupervised Methods for Speaker Diarization: An Integrated and Iterative Approach | S Shum, Najim Dehak, Réda Dehak, J Glass | IEEE Transactions on Audio, Speech, and Language Processing | 7 June 2013 |
lazzara.13.ijdar | Efficient Multiscale Sauvola's Binarization | Guillaume Lazzara, Thierry Géraud | International Journal of Document Analysis and Recognition (IJDAR) | 25 April 2013 |
fabrizio.12.spic | Motion compensation based on Tangent Distance prediction for video compression | Jonathan Fabrizio, Séverine Dubuisson, Dominique Béréziat | Signal Processing: Image Communication | 9 February 2012 |
bensalem.12.topnoc | Model Checking using Generalized Testing Automata | Ala Eddine Ben Salem, Alexandre Duret-Lutz, Fabrice Kordon | Transactions on Petri Nets and Other Models of Concurrency (ToPNoC VI) | 1 January 2012 |
dehak.11.taslp | Front-End Factor Analysis For Speaker Verification | Najim Dehak, P Kenny, Réda Dehak, P Dumouchel, P Ouellet | IEEE Transactions on Audio, Speech, and Language Processing | 1 May 2011 |