SELECT  TOP 15
		PS.poem_id, 
		PS.vote_average,  
		PS.vote_count, 
		P.poem_title, 
		P.name,
		P.author_id,
		P.bio,
		P.comments, 
		P.poem,
		C.main_category,
		C.subcategories,
		C.h1,
		C.url 
	FROM poems AS P INNER JOIN 
			poem_stats AS PS ON PS.poem_id = P.poem_id INNER JOIN 
				category AS C ON P.category_fk = C.category_id  
	WHERE P.publish_ind='Y' 
	ORDER BY 
		PS.emailed DESC, 
		PS.vote_average DESC

SELECT DISTINCT main_category FROM category

with CTE(poem_id, vote_average, vote_count, poem_title, name, 
	author_id, bio, comments, poem, main_category,
	subcategories, h1, url, RowNum)
AS 
(	SELECT  
		PS.poem_id, 
		PS.vote_average,  
		PS.vote_count, 
		P.poem_title, 
		P.name,
		P.author_id,
		P.bio,
		P.comments, 
		P.poem,
		C.main_category,
		C.subcategories,
		C.h1,
		C.url,
		ROW_NUMBER() OVER (PARTITION BY C.main_category ORDER BY C.main_category, PS.poem_id) AS RowNum
	FROM poems AS P 
		INNER JOIN poem_stats AS PS ON 
			PS.poem_id = P.poem_id 
		INNER JOIN category AS C ON 
			IP.category_fk = C.category_id  
	WHERE P.publish_ind='Y' 
)

SELECT *
FROM CTE
WHERE RowNum = 1
ORDER BY main_category DESC