SELECT
	u.first_name,
	u.last_name,
	u.email
FROM
	user u
INNER JOIN
	user_type t
ON
	u.user_type_id = t.id
WHERE
	u.is_active = 1
AND
	ISNULL(
		(
			SELECT
				MAX(foo)
			FROM
				bar
		),
		0
	) > 0
AND
	u.id IN
	(
		SELECT
			id
		FROM
			cool_user
	)
AND
	(
			u.is_super_user = 1
		OR
			u.is_ghosting = 1
		OR
			ISNULL(
				u.user_type_id,
				0
			) = 14
	)