Select distinct [Title], [Acronym],
iif(len(URL)=0 and len(imgLogo)>0, [imgLogo]) as [imgLogo1£#£],
iif(len(URL)>0 and len(imgLogo)>0, '') as [gettami£#£],
[Abstract] as [Abstract#], [start_date],[end_date] as [_end_date], [url_reference],
[Large_Description] as [Descrizione££],
[start_date] as [Data iniziale££],
[end_date] as [_Data conclusione££],
[url_reference] as [URL££],
[IPR_Ita] as [IPR (proprietą intellettuale risultati)££],
[achievements] as [Risultati££],
[innovation] as [Innovazione££],
[keywords] as [keywords££],
ID as [ID££]
from [Progetti-vista]
ORDER BY [start_date] DESC
;
