combined_joins_example.sql

SELECT e.source_id, COUNT(e.*)
FROM entries AS e
	INNER JOIN users__sources AS sassoc
		ON sassoc.source_id = e.source_id AND sassoc.user_id = :user_id
	LEFT JOIN users__entries AS eassoc
		ON eassoc.entry_id = e.id AND eassoc.user_id = :user_id
WHERE eassoc.entry_id IS NULL OR eassoc.is_read = FALSE
GROUP BY e.source_id