SELECT
	um.emailaddress,
	u.username,
	um.lastname,
	um.firstname,
	um.groups,
	COUNT(v.id) as view_count
FROM
	environments env,
	usermetadata um,
	users u
LEFT JOIN views v ON
	(u.username = v.username and u.environmentid = v.environmentid and v.created > '2016-01-10 00:00:00' AND
	v.created < '2016-01-13 23:59:59')
WHERE
	env.guid = '28b5e9e32c68470dbd5df5a24f06e65b' and
	um.userid = u.id AND
	um.enddate is null AND
	env.id = u.environmentid
GROUP BY
	um.emailaddress, u.username, um.lastname, um.firstname, um.groups
order by count(v.id) desc

SELECT
				um.emailaddress,
				u.username,
				um.lastname,
				um.firstname,
				um.groups,
				COUNT(v.userid) as view_count
			FROM
				environments env,
				usermetadata um,
				users u
			LEFT JOIN
				(SELECT
					*
				FROM
					views v
				JOIN
					environments env ON env.id = v.environmentid
				WHERE
					env.guid = '28b5e9e32c68470dbd5df5a24f06e65b' and
					v.created > '2016-01-10 00:00:00' AND
					v.created < '2016-01-13 23:59:59') AS v
			ON
				u.username = v.username and
				u.environmentid = v.environmentid
			WHERE
				env.guid = '28b5e9e32c68470dbd5df5a24f06e65b' and
				um.userid = u.id AND
				um.enddate is null AND
				env.id = u.environmentid
			GROUP BY
				um.emailaddress, u.username, um.lastname, um.firstname, um.groups