Chaoss collaboration trial about 8knot HOT 1 CLOSED

-- Need to incorporate action type into weight 
-- Need to provide a portable time parameter 

SELECT 
	a.cntrb_id,
	a.repo_id,
	b.repo_name,
	MAX ( RANK ) AS weight 
FROM
	explorer_contributor_actions a,
	repo b 
WHERE
	a.repo_id = b.repo_id 
GROUP BY
	a.cntrb_id,
	a.repo_id,
	b.repo_name
ORDER BY
	cntrb_id;