Semantic search
Debug output SQLStore
ASK Query
[[Category:News||LrdeBulletin]] OR [[Category:Publications]] [[Published has news::true]] OR [[Category:OlenaNews]] [[Is global news::true]]
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, t15.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`smw_di_time` AS t15 ON t0.smw_id=t15.s_id
WHERE
(t15.p_id=5194)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t15.o_sortkey DESC
LIMIT
25
OFFSET
550
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, t15.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
INNER JOIN
`smw_di_time` AS t15 ON t0.smw_id=t15.s_id
WHERE
(t15.p_id=5194)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t15.o_sortkey DESC
LIMIT
25
OFFSET
550
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t15 | ref | s_id, p_id, p_id_2, s_id_2 | p_id | 4 | const | 896 | Using where; Using temporary | |
1 | SIMPLE | t1 | eq_ref | PRIMARY | PRIMARY | 4 | www_public.t15.s_id | 1 | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | www_public.t15.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_fpt_inst` AS t2 WHERE (t2.o_id=5406 OR t2.o_id=1431)
INSERT IGNORE INTO `t1` SELECT DISTINCT t5.s_id FROM `smw_fpt_inst` AS t5 INNER JOIN `smw_di_bool` AS t7 ON t5.s_id=t7.s_id WHERE t5.o_id=5352 AND ((t7.o_value=1) AND t7.p_id=5224)
INSERT IGNORE INTO `t1` SELECT DISTINCT t10.s_id FROM `smw_fpt_inst` AS t10 INNER JOIN `smw_di_bool` AS t12 ON t10.s_id=t12.s_id WHERE t10.o_id=1330 AND ((t12.o_value=1) AND t12.p_id=1328)
Query Metrics
Query-Size:7Query-Depth:1
Errors and Warnings
None- The LRDE hosts a new member: Benjamin Raynal — 26 September 2011
- PhD from Université Paris Est Marne-la-Vallée. His works mainly focus on real-time motion capture from multi-camera systems. The applications include new human-computer interfaces, automatic video surveillance and domotics. He joined LRDE as a postdoctoral researcher and is currently interested by automatic extraction of text from images.
- Olena 2.0 is released — 16 September 2011
Olena is LRDE's platform dedicated to image processing and
- Publication of the lab's bulletin L'air de rien 22 — 12 September 2011
- Publication Language Recognition via I-Vectors and Dimensionality Reduction in INTERSPEECH 2011 — 1 August 2011
- Publication LTL Translation Improvements in Spot in Proceedings of the 5th International Workshop on Verification and Evaluation of Computer and Communication Systems (VECoS'11) — 25 July 2011
- LRDE Seminar on Performance and Genericity - Un algorithme rapide pour le Compressive Sensing sur architectures parallèles — 6 July 2011
by Alexandre Borghi
- LRDE Seminar on Performance and Genericity — 6 July 2011
Attendance to LRDE Seminars is free and open to anyone.
- Publication of the lab's bulletin L'air de rien 21 — 4 July 2011
- Guillaume Lazzara invited to the LORIA in Nancy — 24 June 2011
Guillaume Lazzara will be at the LORIA in Nancy on June 24th 2011. He is invited by the Qgar Team to give a talk about the Scribo module, a new free software framework for Document Image Analysis based on Milena.
- Publication Self-Loop Aggregation Product — A New Hybrid Approach to On-the-Fly LTL Model Checking in Proceedings of the 9th International Symposium on Automated Technology for Verification and Analysis (ATVA'11) — 23 June 2011
- LRDE Seminar on Performance and Genericity - Modèle basé-contexte pour l'annotation automatique du multimédia, LRDE Seminar on Performance and Genericity - Traitement d'images sur processeur graphique avec CUDA et C++ — 15 June 2011
by Nicolas Ballas, by Matthieu Garrigues
- LRDE Seminar on Performance and Genericity — 15 June 2011
Attendance to LRDE Seminars is free and open to anyone.
- Publication The SCRIBO Module of the Olena Platform: a Free Software Framework for Document Image Analysis in Proceedings of the 11th International Conference on Document Analysis and Recognition (ICDAR) — 1 June 2011
- Publication Combining Explicit and Symbolic Approaches for Better On-the-Fly LTL Model Checking — 1 June 2011
- Publication Generalized Büchi Automata versus Testing Automata for Model Checking in Proceedings of the second International Workshop on Scalable and Usable Model Checking for Petri Net and other models of Concurrency (SUMO'11) — 25 May 2011
- LRDE Seminar on Performance and Genericity - Utilisation des distances tangentes pour la compensation de mouvement : Application au codec Theora — 18 May 2011
by Jonathan Fabrizio
- LRDE Seminar on Performance and Genericity — 18 May 2011
Attendance to LRDE Seminars is free and open to anyone. This session includes the following topic:
- Publication Une approche générique du logiciel pour le traitement d'images préservant les performances in Proceedings of the 23rd Symposium on Signal and Image Processing (GRETSI) — 13 May 2011
- Publication Front-End Factor Analysis For Speaker Verification in IEEE Transactions on Audio, Speech, and Language Processing — 1 May 2011
- Publication A Channel-Blind System for Speaker Verification in International Conference on Acoustics, Speech and Signal Processing (ICASSP) — 1 May 2011