Special

Semantic search

Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
import-annotation:

Additional annotated data are to be copied during the parsing of a subject
propsep:

The separator between the properties of a result entry
valuesep:

The separator between the values for a property of a result
template:

The name of a template with which to display the printouts
named args:

Name the arguments passed to the template
userparam:

A value passed into each template call, if a template is used
class:

An additional CSS class to set for the list
introtemplate:

The name of a template to display before the query results, if there are any
outrotemplate:

The name of a template to display after the query results, if there are any
Sort options
Delete
Add sorting condition
SQLStore debug output
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
  55
OFFSET
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt15refs_id,p_id,p_id_2,s_id_2p_id4const644Using where; Using temporary; Using filesort
1SIMPLEt1eq_refPRIMARYPRIMARY4www_public.t15.s_id1
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4www_public.t15.s_id1Using 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:7
Query-Depth:1
Errors and Warnings
None
  • Spot 2.3 was released — 19 January 2017
    This new release features some exciting news such as: faster emptiness checks for automata that are not explored on-the-fly, several improvements to the SAT-based minimization procedure, preliminary support for alternating automata, membership tests for all classes of the Manna and Pnueli hierarchy of temporal properties.
  • The LRDE hosts a new member, Joseph Chazalon, Research Fellow. — 17 January 2017
    Joseph Chazalon, postdoc from Laboratoire Image, Informatique et Interaction (L3i) at Université de
    La Rochelle, has joined the lab for several months and will work on the MOBIDEM project.
  • The LRDE hosts a new member, Elodie Puybareau, research engineer, who joins the Olena team. — 1 January 2017
    Holding an engineering degree in medical imaging and a PhD in computer science from LIGM, ESIEE, Elodie has worked mainly on automatic extraction of physiological parameters from videos.
    She joins LRDE's Olena team where she will work on the MOBIDEM project, especially on automatic extraction of text from images of identity papers.
  • Nicolas Boutry defends his PhD thesis "A study of well-composedness in n-D" at ESIEE at 2pm. — 14 December 2016
  • Publication The MIT Lincoln Laboratory 2016 speaker recognition system in NIST Speaker Recognition Evaluation 2016 — 12 December 2016
  • LRDE Seminar on Performance and Genericity - Des données spatio-temporelles aux

    dynamiques urbaines by Julien Perret, équipe COGIT, LaSTIG, IGN. — 7 December 2016

  • Publication A Study of Well-Composedness in n-D — 1 December 2016
  • LRDE Seminar on Performance and Genericity - Analyse du mouvement avec applications bio-médicales by Elodie Puybareau, LIGM. — 23 November 2016
  • Publication Estimating the Number of Endmembers to Use in Spectral Unmixing of Hyperspectral Data with Collaborative Sparsity in Proceedings of the 13th International Conference on Latent Variable Analysis and Signal Separation (LVA-ICA) — 22 November 2016
  • Publication Monads in Common Lisp — 18 November 2016