Vanilla 1.1.9 is a product of Lussumo. More Information: Documentation, Community Support.
Is there a way to list questions that were formerly featured but are now solved so someone has gained the bounty? How about those that were featured but the bounty has expired?
You can search the public database dumps. When somebody starts a bounty on a question, they "vote" to do it with VoteTypeId="8". So you can get a list of the post IDs by searching votes.xml
. Here's a complete list produced from the latest dump with the following command
grep 'VoteTypeId="8"' votes.xml | sed -e 's|.*PostId="\([0-9]*\)".*|\[\1\](http://mathoverflow.net/questions/\1)|'
(broken into multiple posts because of meta's character limit)
138 410 689 385 959 2853 2791 3312 1527 3219 2888 2082 3701 1666 981 2369 3249 3430 1959 4661 4994 6271 4724 6442 6820 6749 6923 4790 6890 6379 6627 7016 7732 7318 7800 8247 8223 7650 4841 9321 8854 9492 8534 9645 7110 9756 9921 10116 9874 10356 10468 11091 10619 11301 11923 12078 9558 12765 11716 11603 10799 13394 13437 11675 5364 13873 14492 12322 15165 15359 15087 15243 8993 16132 15775 16078 12085 17250
8933 17861 15472 18338 18981 20161 20705 20890 9785 20622 13714 20915 21298 21225 21282 10347 11283 10408 18483 16892 21607 3965 15592 8697 17486 22078 22211 12638 20007 23009 13021 22533 23386 23299 22316 23002 24683 24813 24545 23829 24117 18902 13188 25817 26166 26608 26737 26961 27134 27334 27345 25691 27534 26117 28195 28871 24586 19234 13112 29478 30224 30527 29000 30874 31373 32000 32098 32345 18932 31249 29961 29323 32999 33405 32889 33421 31786 34631 34651 34755 33585 35057 34625 35207 35220 6444
35567 29543 35218 36127 36219 36670 36813 36386 37529 37344 37582 38026 37993 37161 29169 38912 38116 13933 39429 22897 39798 39976 40465 36396 40801 40090 40800 41041 7492 41804 41628 42124 37964 44183 44312 44474 35617 43915 44934 44608 45094 43507 45379 45638 45534 45855 46708 45016 47071 43918 47641 47788 48488 48708 50071 50359 50479 43680 50804 51085 50700 50867 51684 47258 53047 49647 53456 39823 53075 53534 53525 49686 51367
Thanks for the help, Anton.
1 to 5 of 5