#
# users signed up since March 1 - 26
#
SELECT
	*,
	trim(concat(upper(substring(substring_index(firstname,' ',1),1,1)),
	lower(substring(substring_index(firstname,' ',1),2,10)))) as firstname,
	date_format(first_visit,'%M %e, %Y') as first_visit_pretty,
	lower(userid) as userid
FROM
	users
	#left join charges using (user_id)
WHERE
	removemeemail='0'
	and emailbounced='0'
	and generalPurposeBit='0'
	and userid!=''
	and email!=''
	and first_visit > '2010-03-01 00:00:00'
	and email not in (
		'3bianca333@gmail.com',
		'aguilus3@aol.com'
		)
	#and email not like '%aol.com'
LIMIT 500