I am trying to filter with a "WHERE" but I want to display the filtered rows as "NULL" or 0 instead of hiding them.

Here is my code:

```
SELECT *, IFNULL(SUM(ROUND(TIMESTAMPDIFF(MINUTE,start,end)/60,1)),0) urlaub 
FROM time_entries e
LEFT JOIN users u ON e.user_id = u.id
WHERE e.project_id = 10 AND YEAR(end) = YEAR(CURRENT_DATE)
GROUP BY e.user_id

```

Best,
Chris