0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for 3D printing enthusiasts

select COUNT(*) AS [COUNT], '1' AS [PULL]
from posts 
WHERE posts.ViewCount >= 72707
UNION
select COUNT(*) AS [COUNT], '2' AS [PULL]
from posts 
WHERE posts.ViewCount >= 42944 AND posts.ViewCount < 72707
UNION
select COUNT(*) AS [COUNT], '3' AS [PULL]
from posts 
WHERE posts.ViewCount >= 30901 AND posts.ViewCount < 42944
UNION
select COUNT(*) AS [COUNT], '4' AS [PULL]
from posts 
WHERE posts.ViewCount >= 24250 AND posts.ViewCount < 30901

fork query

edited mar 17 18

created mar 17 18 anonymous