Ooops. The CASE is not exactly the same as the AND/OR conditions, so it should be:
```
SELECT a.*, b.AnnualDossier as Dossier
FROM (
SELECT DISTINCT ProjID
FROM Project_List
) as o,
JOIN Project_List as a
ON a.ProjID == o.ProjID
AND a.InsertDate == (
select max(InsertDate)
from Project_List
where ProjID == o.ProjID
)
JOIN ABT_Budget as b
ON b.ProjID == o.ProjID
AND b.InsertDate == (
select max(InsertDate)
from ABT_Budget
where ProjID == o.ProjID
)
WHERE a.PMO_Board_Report != 'No'
AND (
(
a.Target_Go_Live_Date > substr(date('now'),1,4) || '-01-15'
)
OR
(
a.Target_Go_Live_Date = '' AND a.Finish_Date > substr(date('now'),1,4) || '-01-15'
)
)
ORDER BY o.ProjID
;
```