0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

select * from (
	select top 10 postid from votes
	where votetypeid=2
	group by postid
	order by count(1) desc
	) a
union all
select * from (
	select top 10 postid from votes v
	inner join votetypes vt on v.votetypeid=vt.id and vt.name='DownMod'
	group by postid
	order by count(1) desc
	) b

view current version

edited sep 20

created sep 20 Janis123