select s.*, c.contributor_id, c.screen_name, b.brand_id, b.brand, f.flavor_id, f.flavor, st.* from schwag s left join contributors c on (c.contributor_id = s.contributor_id) left join brands b on (b.brand_id = s.brand_id) left join flavors f on (f.flavor_id = s.flavor_id) left join schwag_type st on (st.id = s.schwag_type_id) group by s.schwag_id order by b.brand, f.flavor Merchandise, Schwag, Tchotchkes

Whatever you want to call it. Here is the list of all the energy drink related goodies we've acquired.

#	Brand	Description	pts	Contributor	Date Added
#currentRow#	- #brand#	#description#	(#point_value#)	#screen_name#	#DateFormat( date_added, "m/d/yy")#