<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	My Coding Methodology - Understanding The Madness And The Man Behind It
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:391.view
	
	Date Posted:
	Nov 8, 2006 at 8:33 AM
	
---- --------------------------------------------------------------------------------------- --->


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
	)