SELECT
news.id,
news.name,
news.date,
news.id_langue,
languages.id_langue AS id_langue1,
languages.flag_langue,
languages.nom_langue nom_langue_FR,
languages.nom_langue_EN,
languages.nom_langue_ES,
languages.nom_langue_DE,
languages.nom_langue_NL,
languages.nom_langue_IT,
news.source,
news.pages,
news.image,
news.pdf,
news.txt_FR,
news.txt_EN,
news.txt_ES,
news.txt_DE,
news.txt_NL,
news.txt_IT,
news.type
FROM news INNER JOIN languages ON news.id_langue = languages.id_langue WHERE news.type = 2 ORDER BY news.date ASC
Zeitschriften |
Einzelartikel |
|
|
|

