# Pastebin mdOfDD04
2023-05-20 14:47:08.350 UTC [141] ERROR:  column "rg.name" must appear in the GROUP BY clause or be used in an aggregate function at character 78
2023-05-20 14:47:08.350 UTC [141] STATEMENT:  SELECT rg.gid AS release_group_mbid
	                                       , rg.name AS release_group_name
	                                       , t.name AS tag_name
	                                       , row_number() OVER (PARTITION BY rg.gid ORDER BY t.name) AS rnum 
	                                    FROM release_group rg    
	                                    JOIN release_group_tag rgt
	                                      ON rg.id = rgt.release_group
	                                    JOIN tag t
	                                      ON t.id = rgt.tag
	                                   WHERE t.name in ('downtempo', 'trip hop')
	                                     AND count > 1
	                                GROUP BY release_group_mbid, count, t.name
	                                ;