select pts.tags from (select pt.postid, string_agg(t.tagn...


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for pro webmasters

select pts.tags
	  from (select pt.postid,
				   string_agg(t.tagname, ',') within group (order by as tags
			  from posttags pt
				   inner join tags t on pt.tagid =
			 group by pt.postid
			having count(pt.tagid) > 1
		   ) pts
	 group by pts.tags
	 order by count(pts.postid) desc;

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results