select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2023' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2022' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2021' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2020' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2019' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2018' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2017' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2016' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2015' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2014' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2013' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2012' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2011' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2010' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2009' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2008' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2007' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2006' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2005' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2004' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2003' order by news_date DESC
select id,news_project_id,news_file_name,news_description,news_date from news where EXTRACT(YEAR FROM news_date) = '2002' order by news_date DESC
