SELECT
n.id,
n.titre_ger AS titre,
n.texte_ger AS texte,
DATE_FORMAT(n.date, '%d/%m/%Y') as date,
n.id_cat,
t.cat_ger AS cat
FROM
aeroport_news AS n, aeroport_news_cat AS t
WHERE t.id_cat = n.id_cat AND n.public = '1' ORDER BY n.id DESC
LIMIT 0, 3
News
