r.contributor AS contributor,
r.subject AS subject,
r.publisher AS publisher,
+ TO_DAYS(r.modified) AS modified,
GROUP_CONCAT(DISTINCT d.nom_discipline) AS disciplines,
GROUP_CONCAT(DISTINCT d.id_discipline) AS discipline_ids,
GROUP_CONCAT(DISTINCT p.nom) AS pays,
WHERE r.validated AND (l.spec IS NULL OR l.validated)
GROUP BY r.id''',
sql_query_info='SELECT * from savoirs_record WHERE id=$id',
- sql_attr_multi=['discipline_ids', 'region_ids']
+ sql_attr_multi=['discipline_ids', 'region_ids'],
+ sql_attr_uint=['modified']
)
emit_source('savoirsenpartage_actualites',