aqetuner / workloads / stats
stats
Raw
SELECT Reputation, Views, COUNT(*)  FROM badges, users WHERE badges.UserId = users.Id AND users.UpVotes >= 0 GROUP BY Reputation, Views;
SELECT PostTypeId, Score, COUNT(*)  FROM comments, posts WHERE comments.UserId = posts.OwnerUserId AND (comments.CreationDate >= 1280968562) AND (comments.CreationDate <= 1410195049) AND (posts.ViewCount <= 2897) AND (posts.FavoriteCount <= 10) AND (posts.ViewCount >= 0) AND (posts.CommentCount >= 0) AND (posts.CommentCount <= 16) AND (posts.FavoriteCount >= 0) GROUP BY PostTypeId, Score;
SELECT UserId, COUNT(*)  FROM comments, posts WHERE comments.UserId = posts.OwnerUserId AND (comments.CreationDate >= 1280968562) AND (comments.CreationDate <= 1410195049) AND (posts.ViewCount <= 2897) AND (posts.FavoriteCount <= 10) AND (posts.ViewCount >= 0) AND (posts.CommentCount >= 0) AND (posts.CommentCount <= 16) AND (posts.FavoriteCount >= 0) GROUP BY UserId;
SELECT DownVotes, Views, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND (posts.ViewCount <= 2897) AND (posts.FavoriteCount <= 10) AND (posts.ViewCount >= 0) AND (posts.CommentCount >= 0) AND (posts.CommentCount <= 16) AND (posts.FavoriteCount >= 0) GROUP BY DownVotes, Views;
SELECT comments.PostId, COUNT(*)  FROM comments, posts WHERE comments.UserId = posts.OwnerUserId AND comments.Score = 0 AND (posts.CommentCount <= 10) AND (posts.Score <= 15) AND (posts.AnswerCount <= 3) AND (posts.ViewCount >= 0) AND (posts.Score >= 0) AND (posts.ViewCount <= 3002) GROUP BY comments.PostId;
SELECT DownVotes, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND (users.UpVotes >= 0) AND (users.CreationDate >= 1282580470) AND (users.DownVotes <= 0) AND (users.CreationDate <= 1409651406) AND (posts.CommentCount <= 10) AND (posts.Score <= 15) AND (posts.AnswerCount <= 3) AND (posts.ViewCount >= 0) AND (posts.Score >= 0) AND (posts.ViewCount <= 3002) GROUP BY DownVotes;
SELECT UserId, COUNT(*)  FROM comments, votes WHERE comments.UserId = votes.UserId AND (comments.CreationDate >= 1285965926) AND (comments.CreationDate <= 1409921477) AND votes.BountyAmount <= 100 GROUP BY UserId;
SELECT PostTypeId, COUNT(*)  FROM posts, tags WHERE posts.Id = tags.ExcerptPostId AND posts.CreationDate >= 1279591265 GROUP BY PostTypeId;
SELECT Score, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND posts.CreationDate >= 1279570117 GROUP BY Score;
SELECT Reputation, VoteTypeId, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.CreationDate >= 1280250957) AND (users.CreationDate <= 1409748462) AND (users.UpVotes >= 0) AND votes.CreationDate <= 1410480000 GROUP BY VoteTypeId, Reputation;
SELECT DownVotes, Views, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.DownVotes = 0 AND (votes.BountyAmount <= 50) AND (votes.BountyAmount >= 0) GROUP BY DownVotes, Views;
SELECT OwnerUserId, COUNT(*)  FROM postLinks, posts WHERE postLinks.PostId = posts.Id AND posts.Score >= 3 GROUP BY OwnerUserId;
SELECT RelatedPostId, postLinks.PostId, VoteTypeId, UserId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId AND (votes.VoteTypeId = 2) AND (votes.CreationDate <= 1410480000) GROUP BY VoteTypeId, UserId, RelatedPostId, postLinks.PostId;
SELECT Score, OwnerUserId, RelatedPostId, COUNT(*)  FROM postLinks, posts WHERE postLinks.RelatedPostId = posts.Id GROUP BY RelatedPostId, Score, OwnerUserId;
SELECT RelatedPostId, COUNT(*)  FROM postLinks, posts WHERE postLinks.RelatedPostId = posts.Id GROUP BY RelatedPostId;
SELECT comments.PostId, RelatedPostId, COUNT(*)  FROM postLinks, comments WHERE postLinks.RelatedPostId = comments.PostId AND (comments.CreationDate <= 1408989565) AND (comments.CreationDate >= 1279710337) GROUP BY RelatedPostId, comments.PostId;
SELECT DownVotes, Views, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.UpVotes >= 0) AND (users.CreationDate >= 1279566579) AND (users.UpVotes <= 12) AND (votes.BountyAmount <= 50) AND (votes.CreationDate <= 1410480000) GROUP BY DownVotes, Views;
SELECT Score, OwnerUserId, COUNT(*)  FROM badges, posts WHERE badges.UserId = posts.OwnerUserId AND (badges.Date <= 1409787369) AND (badges.Date >= 1279652542) AND (posts.Score >= -1) AND (posts.FavoriteCount <= 20) AND (posts.PostTypeId = 1) AND (posts.FavoriteCount >= 0) GROUP BY Score, OwnerUserId;
SELECT OwnerUserId, DownVotes, Reputation, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND (users.UpVotes >= 0) AND (users.CreationDate >= 1290742451) AND (users.DownVotes <= 2) AND (posts.Score >= -1) AND (posts.FavoriteCount <= 20) AND (posts.PostTypeId = 1) AND (posts.FavoriteCount >= 0) GROUP BY DownVotes, Reputation, OwnerUserId;
SELECT Score, PostTypeId, COUNT(*)  FROM badges, posts WHERE badges.UserId = posts.OwnerUserId AND (posts.CommentCount = 0) AND (posts.Score <= 30) AND (posts.CreationDate >= 1280244631) AND (posts.CreationDate <= 1409852710) AND (posts.Score >= 0) GROUP BY Score, PostTypeId;
SELECT OwnerUserId, PostTypeId, COUNT(*)  FROM badges, posts WHERE badges.UserId = posts.OwnerUserId AND (posts.CommentCount = 0) AND (posts.Score <= 30) AND (posts.CreationDate >= 1280244631) AND (posts.CreationDate <= 1409852710) AND (posts.Score >= 0) GROUP BY OwnerUserId, PostTypeId;
SELECT DownVotes, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND (posts.CommentCount = 0) AND (posts.Score <= 30) AND (posts.CreationDate >= 1280244631) AND (posts.CreationDate <= 1409852710) AND (posts.Score >= 0) GROUP BY DownVotes;
SELECT DownVotes, Reputation, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId GROUP BY DownVotes, Reputation;
SELECT Views, VoteTypeId, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.CreationDate >= 1289887384 AND votes.CreationDate <= 1409961600 GROUP BY VoteTypeId, Views;
SELECT Reputation, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.Views >= 0) AND (users.Views <= 783) AND (users.DownVotes > 0) AND (users.UpVotes <= 123) AND (users.DownVotes <= 1) AND (votes.CreationDate >= 1280102400) AND (votes.CreationDate <= 1410480000) GROUP BY Reputation;
SELECT DownVotes, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.Views >= 0) AND (users.Views <= 783) AND (users.DownVotes = 0) AND (users.UpVotes <= 123) AND (users.DownVotes <= 1) AND (votes.CreationDate >= 1280102400) AND (votes.CreationDate <= 1410480000) GROUP BY DownVotes;
SELECT DownVotes, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.Views >= 0) AND (users.Views <= 110) AND (users.UpVotes = 0) AND (users.CreationDate >= 1280345351) AND (users.CreationDate <= 1407994170) AND (users.Reputation >= 1) AND (votes.CreationDate >= 1280102400) AND (votes.CreationDate <= 1410134400) AND (votes.BountyAmount >= 0) GROUP BY DownVotes;
SELECT Reputation, UserId, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.Views >= 0) AND (users.Views <= 110) AND (users.UpVotes = 0) AND (users.CreationDate >= 1280345351) AND (users.CreationDate <= 1407994170) AND (users.Reputation >= 1) AND (votes.CreationDate >= 1280102400) AND (votes.CreationDate <= 1410134400) AND (votes.BountyAmount >= 0) GROUP BY UserId, Reputation;
SELECT comments.PostId, UserId, UserId, COUNT(*)  FROM comments, votes WHERE comments.UserId = votes.UserId AND (comments.Score = 1) AND (comments.CreationDate >= 1279667848) GROUP BY UserId, comments.PostId, UserId;
SELECT DownVotes, votes.PostId, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.CreationDate >= 1279589249 GROUP BY votes.PostId, DownVotes;
SELECT DownVotes, COUNT(*)  FROM users, comments WHERE users.Id = comments.UserId AND users.CreationDate >= 1279589249 AND (comments.Score = 1) AND (comments.CreationDate >= 1279667848) GROUP BY DownVotes;
SELECT comments.PostId, UserId, COUNT(*)  FROM comments, votes WHERE comments.UserId = votes.UserId AND comments.Score = 0 AND (votes.BountyAmount >= 0) AND (votes.CreationDate <= 1410393600) GROUP BY comments.PostId, UserId;
SELECT votes.PostId, UserId, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.DownVotes <= 57) AND (users.CreationDate <= 1407668499) AND (users.CreationDate >= 1282813291) AND (votes.BountyAmount >= 0) AND (votes.CreationDate <= 1410393600) GROUP BY votes.PostId, UserId;
SELECT votes.PostId, UserId, COUNT(*)  FROM comments, votes WHERE comments.UserId = votes.UserId AND comments.Score = 0 AND (votes.BountyAmount >= 0) AND (votes.BountyAmount <= 300) AND (votes.CreationDate >= 1280361600) GROUP BY votes.PostId, UserId;
SELECT votes.PostId, COUNT(*)  FROM badges, votes WHERE badges.UserId = votes.UserId AND (votes.BountyAmount >= 0) AND (votes.BountyAmount <= 300) AND (votes.CreationDate >= 1280361600) GROUP BY votes.PostId;
SELECT votes.PostId, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.UpVotes <= 18) AND (users.UpVotes >= 0) AND (votes.BountyAmount >= 0) AND (votes.BountyAmount <= 300) AND (votes.CreationDate >= 1280361600) GROUP BY votes.PostId;
SELECT VoteTypeId, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.UpVotes <= 18) AND (users.UpVotes >= 0) AND (votes.BountyAmount >= 0) AND (votes.BountyAmount <= 300) AND (votes.CreationDate >= 1280361600) GROUP BY VoteTypeId;
SELECT LinkTypeId, postLinks.PostId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND (postHistory.CreationDate <= 1410355194) AND (postHistory.CreationDate >= 1304804839) GROUP BY LinkTypeId, postLinks.PostId;
SELECT postHistory.PostId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND (postHistory.CreationDate <= 1410355194) AND (postHistory.CreationDate >= 1304804839) GROUP BY postHistory.PostId;
SELECT LinkTypeId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId GROUP BY LinkTypeId;
SELECT DownVotes, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND (users.CreationDate >= 1290894409) AND (users.Views >= 0) AND (users.UpVotes >= 0) AND (users.CreationDate <= 1408366822) AND posts.FavoriteCount <= 5 GROUP BY DownVotes;
SELECT OwnerUserId, UserId, VoteTypeId, COUNT(*)  FROM votes, posts WHERE votes.UserId = posts.OwnerUserId AND (posts.PostTypeId = 2) AND (posts.CreationDate <= 1409092826) GROUP BY UserId, VoteTypeId, OwnerUserId;
SELECT OwnerUserId, PostTypeId, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND users.Views >= 0 AND (posts.PostTypeId = 2) AND (posts.CreationDate <= 1409092826) GROUP BY OwnerUserId, PostTypeId;
SELECT Reputation, Views, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.Views >= 0 GROUP BY Reputation, Views;
SELECT Reputation, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.CreationDate >= 1292392824 GROUP BY Reputation;
SELECT UserId, Score, COUNT(*)  FROM comments, posts WHERE comments.UserId = posts.OwnerUserId AND comments.CreationDate >= 1280232220 AND (posts.ViewCount <= 6517) AND (posts.CreationDate >= 1280230160) AND (posts.Score <= 28) AND (posts.CreationDate <= 1410576615) AND (posts.AnswerCount >= 0) AND (posts.ViewCount >= 0) AND (posts.Score >= 0) AND (posts.FavoriteCount >= 0) AND (posts.AnswerCount <= 5) AND (posts.FavoriteCount <= 8) GROUP BY UserId, Score;
SELECT votes.PostId, VoteTypeId, COUNT(*)  FROM votes, posts WHERE votes.UserId = posts.OwnerUserId AND (posts.ViewCount <= 6517) AND (posts.CreationDate >= 1280230160) AND (posts.Score <= 28) AND (posts.CreationDate <= 1410576615) AND (posts.AnswerCount >= 0) AND (posts.ViewCount >= 0) AND (posts.Score >= 0) AND (posts.FavoriteCount >= 0) AND (posts.AnswerCount <= 5) AND (posts.FavoriteCount <= 8) GROUP BY votes.PostId, VoteTypeId;
SELECT votes.PostId, COUNT(*)  FROM badges, votes WHERE badges.UserId = votes.UserId GROUP BY votes.PostId;
SELECT Views, DownVotes, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.UpVotes <= 72) AND (users.UpVotes >= 0) AND (users.DownVotes <= 0) GROUP BY Views, DownVotes;
SELECT Views, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.DownVotes >= 0) AND (users.Views <= 433) AND (users.CreationDate <= 1410557859) GROUP BY Views;
SELECT Reputation, Views, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND (users.DownVotes >= 0) AND (users.Views <= 433) AND (users.CreationDate <= 1410557859) GROUP BY Reputation, Views;
SELECT comments.PostId, UserId, COUNT(*)  FROM comments, votes WHERE comments.UserId = votes.UserId AND (comments.Score = 1) AND (comments.CreationDate >= 1282918327) AND (votes.CreationDate >= 1279497600) AND (votes.VoteTypeId = 5) AND (votes.CreationDate <= 1410566400) GROUP BY comments.PostId, UserId;
SELECT votes.PostId, VoteTypeId, COUNT(*)  FROM badges, votes WHERE badges.UserId = votes.UserId AND badges.Date <= 1408444333 AND (votes.CreationDate >= 1279497600) AND (votes.VoteTypeId = 5) AND (votes.CreationDate <= 1410566400) GROUP BY votes.PostId, VoteTypeId;
SELECT votes.PostId, COUNT(*)  FROM users, comments, votes WHERE users.Id = votes.UserId AND comments.UserId = votes.UserId AND users.Reputation >= 1 AND (comments.Score = 1) AND (comments.CreationDate >= 1282918327) AND (votes.CreationDate >= 1279497600) AND (votes.VoteTypeId = 5) AND (votes.CreationDate <= 1410566400) GROUP BY votes.PostId;
SELECT Reputation, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.Reputation >= 1 AND (votes.CreationDate >= 1279497600) AND (votes.VoteTypeId = 5) AND (votes.CreationDate <= 1410566400) GROUP BY Reputation;
SELECT Views, COUNT(*)  FROM users, comments WHERE users.Id = comments.UserId AND users.Reputation >= 1 AND (comments.Score = 1) AND (comments.CreationDate >= 1282918327) GROUP BY Views;
SELECT votes.PostId, UserId, COUNT(*)  FROM badges, votes WHERE badges.UserId = votes.UserId GROUP BY votes.PostId, UserId;
SELECT comments.PostId, Score, COUNT(*)  FROM badges, comments WHERE badges.UserId = comments.UserId AND (comments.Score = 1) AND (comments.CreationDate >= 1279667848) GROUP BY comments.PostId, Score;
SELECT Reputation, DownVotes, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.CreationDate >= 1279589249 GROUP BY Reputation, DownVotes;
SELECT Views, Reputation, COUNT(*)  FROM users, comments WHERE users.Id = comments.UserId AND users.CreationDate >= 1279589249 AND (comments.Score = 1) AND (comments.CreationDate >= 1279667848) GROUP BY Views, Reputation;
SELECT Views, COUNT(*)  FROM users, comments WHERE users.Id = comments.UserId AND users.CreationDate >= 1279589249 AND (comments.Score = 1) AND (comments.CreationDate >= 1279667848) GROUP BY Views;
SELECT postLinks.PostId, RelatedPostId, COUNT(*)  FROM comments, postLinks WHERE comments.PostId = postLinks.PostId AND comments.Score = 0 AND (postLinks.CreationDate >= 1321915181) AND (postLinks.CreationDate <= 1409588996) GROUP BY postLinks.PostId, RelatedPostId;
SELECT postHistory.PostId, PostHistoryTypeId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND (postLinks.CreationDate >= 1321915181) AND (postLinks.CreationDate <= 1409588996) GROUP BY postHistory.PostId, PostHistoryTypeId;
SELECT LinkTypeId, RelatedPostId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId AND (votes.CreationDate <= 1410652800) AND (votes.CreationDate >= 1279756800) AND (postLinks.CreationDate >= 1321915181) AND (postLinks.CreationDate <= 1409588996) GROUP BY LinkTypeId, RelatedPostId;
SELECT OwnerUserId, Score, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND (postLinks.CreationDate >= 1321915181) AND (postLinks.CreationDate <= 1409588996) GROUP BY OwnerUserId, Score;
SELECT UserId, COUNT(*)  FROM comments, postLinks WHERE comments.PostId = postLinks.PostId AND comments.Score = 0 AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY UserId;
SELECT Score, RelatedPostId, COUNT(*)  FROM comments, postLinks WHERE comments.PostId = postLinks.PostId AND comments.Score = 0 AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY RelatedPostId, Score;
SELECT RelatedPostId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY RelatedPostId;
SELECT postLinks.PostId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY postLinks.PostId;
SELECT VoteTypeId, UserId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY VoteTypeId, UserId;
SELECT LinkTypeId, VoteTypeId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY VoteTypeId, LinkTypeId;
SELECT Score, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY Score;
SELECT RelatedPostId, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND (postLinks.CreationDate <= 1408737865) AND (postLinks.CreationDate >= 1300774714) GROUP BY RelatedPostId;
SELECT postLinks.PostId, COUNT(*)  FROM comments, postLinks WHERE comments.PostId = postLinks.PostId AND (postLinks.CreationDate >= 1287500562) AND (postLinks.LinkTypeId = 1) GROUP BY postLinks.PostId;
SELECT comments.PostId, UserId, COUNT(*)  FROM comments, postLinks WHERE comments.PostId = postLinks.PostId AND (postLinks.CreationDate >= 1287500562) AND (postLinks.LinkTypeId = 1) GROUP BY comments.PostId, UserId;
SELECT UserId, postHistory.PostId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND postHistory.CreationDate <= 1403111647 AND (postLinks.CreationDate >= 1287500562) AND (postLinks.LinkTypeId = 1) GROUP BY UserId, postHistory.PostId;
SELECT postLinks.PostId, RelatedPostId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId AND votes.CreationDate >= 1279584000 AND (postLinks.CreationDate >= 1287500562) AND (postLinks.LinkTypeId = 1) GROUP BY postLinks.PostId, RelatedPostId;
SELECT RelatedPostId, LinkTypeId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId AND votes.CreationDate >= 1279584000 AND (postLinks.CreationDate >= 1287500562) AND (postLinks.LinkTypeId = 1) GROUP BY RelatedPostId, LinkTypeId;
SELECT PostTypeId, Score, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND (postLinks.CreationDate >= 1287500562) AND (postLinks.LinkTypeId = 1) GROUP BY PostTypeId, Score;
SELECT Score, OwnerUserId, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND (postLinks.CreationDate >= 1287500562) AND (postLinks.LinkTypeId = 1) GROUP BY Score, OwnerUserId;
SELECT postLinks.PostId, RelatedPostId, COUNT(*)  FROM comments, postLinks WHERE comments.PostId = postLinks.PostId AND (postLinks.LinkTypeId = 1) AND (postLinks.CreationDate >= 1308058295) GROUP BY postLinks.PostId, RelatedPostId;
SELECT PostHistoryTypeId, postHistory.PostId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND (postLinks.LinkTypeId = 1) AND (postLinks.CreationDate >= 1308058295) GROUP BY PostHistoryTypeId, postHistory.PostId;
SELECT LinkTypeId, postLinks.PostId, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND (postLinks.LinkTypeId = 1) AND (postLinks.CreationDate >= 1308058295) GROUP BY LinkTypeId, postLinks.PostId;
SELECT LinkTypeId, COUNT(*)  FROM posts, postLinks WHERE posts.Id = postLinks.PostId AND (postLinks.LinkTypeId = 1) AND (postLinks.CreationDate >= 1308058295) GROUP BY LinkTypeId;
SELECT OwnerUserId, Score, Views, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND (users.CreationDate <= 1409652281) AND (users.CreationDate >= 1280361360) AND (users.Reputation <= 705) AND (posts.CommentCount <= 12) AND (posts.AnswerCount <= 4) AND (posts.CommentCount >= 0) AND (posts.FavoriteCount <= 89) AND (posts.CreationDate <= 1409653264) AND (posts.FavoriteCount >= 0) GROUP BY Views, OwnerUserId, Score;
SELECT Score, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND (users.CreationDate <= 1409652281) AND (users.CreationDate >= 1280361360) AND (users.Reputation <= 705) AND (posts.CommentCount <= 12) AND (posts.AnswerCount <= 4) AND (posts.CommentCount >= 0) AND (posts.FavoriteCount <= 89) AND (posts.CreationDate <= 1409653264) AND (posts.FavoriteCount >= 0) GROUP BY Score;
SELECT Score, PostTypeId, COUNT(*)  FROM badges, posts WHERE badges.UserId = posts.OwnerUserId AND (badges.Date >= 1279658847) AND (badges.Date <= 1410269068) AND (posts.CommentCount <= 12) AND (posts.AnswerCount <= 4) AND (posts.CommentCount >= 0) AND (posts.FavoriteCount <= 89) AND (posts.CreationDate <= 1409653264) AND (posts.FavoriteCount >= 0) GROUP BY Score, PostTypeId;
SELECT Score, COUNT(*)  FROM users, posts WHERE users.Id = posts.OwnerUserId AND users.CreationDate <= 1410560509 AND (posts.CreationDate <= 1409715155) AND (posts.AnswerCount >= 0) AND (posts.FavoriteCount >= 0) GROUP BY Score;
SELECT VoteTypeId, COUNT(*)  FROM badges, votes WHERE badges.UserId = votes.UserId AND badges.Date >= 1279576446 AND votes.CreationDate <= 1410307200 GROUP BY VoteTypeId;
SELECT VoteTypeId, UserId, COUNT(*)  FROM badges, votes WHERE badges.UserId = votes.UserId AND badges.Date <= 1409760792 AND votes.CreationDate <= 1410480000 GROUP BY VoteTypeId, UserId;
SELECT Reputation, Views, COUNT(*)  FROM users, votes WHERE users.Id = votes.UserId AND users.Views >= 0 GROUP BY Reputation, Views;
SELECT OwnerUserId, PostTypeId, comments.PostId, Score, COUNT(*)  FROM comments, posts WHERE comments.PostId = posts.Id AND comments.Score = 0 AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY comments.PostId, Score, OwnerUserId, PostTypeId;
SELECT Score, postLinks.PostId, RelatedPostId, COUNT(*)  FROM postLinks, posts WHERE postLinks.PostId = posts.Id AND (postLinks.CreationDate >= 1317937286) AND (postLinks.LinkTypeId = 1) AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY postLinks.PostId, RelatedPostId, Score;
SELECT PostTypeId, Score, COUNT(*)  FROM postLinks, posts WHERE postLinks.PostId = posts.Id AND (postLinks.CreationDate >= 1317937286) AND (postLinks.LinkTypeId = 1) AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY PostTypeId, Score;
SELECT PostHistoryTypeId, COUNT(*)  FROM postHistory, postLinks WHERE postHistory.PostId = postLinks.PostId AND (postLinks.CreationDate >= 1317937286) AND (postLinks.LinkTypeId = 1) GROUP BY PostHistoryTypeId;
SELECT postHistory.PostId, COUNT(*)  FROM postHistory, postLinks, posts WHERE postHistory.PostId = posts.Id AND postLinks.PostId = posts.Id AND (postLinks.CreationDate >= 1317937286) AND (postLinks.LinkTypeId = 1) AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY postHistory.PostId;
SELECT PostTypeId, postLinks.PostId, LinkTypeId, COUNT(*)  FROM postHistory, postLinks, posts WHERE postHistory.PostId = posts.Id AND postLinks.PostId = posts.Id AND (postLinks.CreationDate >= 1317937286) AND (postLinks.LinkTypeId = 1) AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY postLinks.PostId, LinkTypeId, PostTypeId;
SELECT OwnerUserId, Score, COUNT(*)  FROM postHistory, posts WHERE postHistory.PostId = posts.Id AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY OwnerUserId, Score;
SELECT OwnerUserId, Score, UserId, COUNT(*)  FROM postHistory, posts WHERE postHistory.PostId = posts.Id AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY UserId, OwnerUserId, Score;
SELECT RelatedPostId, LinkTypeId, votes.PostId, VoteTypeId, COUNT(*)  FROM votes, postLinks WHERE votes.PostId = postLinks.PostId AND votes.VoteTypeId = 2 AND (postLinks.CreationDate >= 1317937286) AND (postLinks.LinkTypeId = 1) GROUP BY votes.PostId, VoteTypeId, RelatedPostId, LinkTypeId;
SELECT UserId, votes.PostId, COUNT(*)  FROM votes, posts WHERE votes.PostId = posts.Id AND votes.VoteTypeId = 2 AND (posts.CreationDate <= 1410184361) AND (posts.CreationDate >= 1279850412) AND (posts.FavoriteCount >= 0) GROUP BY UserId, votes.PostId;
SELECT PostTypeId, OwnerUserId, comments.PostId, UserId, COUNT(*)  FROM comments, posts WHERE comments.PostId = posts.Id AND comments.CreationDate >= 1280664761 AND (posts.CreationDate >= 1281534836) AND (posts.Score <= 44) AND (posts.FavoriteCount <= 3) AND (posts.CreationDate <= 1409745156) AND (posts.FavoriteCount >= 0) GROUP BY comments.PostId, UserId, PostTypeId, OwnerUserId;
SELECT postLinks.PostId, LinkTypeId, COUNT(*)  FROM postLinks, posts WHERE postLinks.PostId = posts.Id AND (postLinks.CreationDate <= 1407777991) AND (postLinks.LinkTypeId = 1) AND (posts.CreationDate >= 1281534836) AND (posts.Score <= 44) AND (posts.FavoriteCount <= 3) AND (posts.CreationDate <= 1409745156) AND (posts.FavoriteCount >= 0) GROUP BY postLinks.PostId, LinkTypeId;