EN
EN
SELECT DISTINCT left(media_year_nae,4) year FROM ipscom_media WHERE media_year_nae != '' AND media_date_nae != '' AND media_trash = 0 ORDER BY year DESC