Skip to main content
Add total count.
Source Link
WinEunuuchs2Unix
  • 104.4k
  • 11
  • 18

I've started a VTC project based on abandoned questions about EOL Ubuntu versions. Tonight I VTC'd only one so far: https://askubuntu.com/questions/127013/boot-failure-after-shutdown-during-upgrade-from-11-10-to-12-04.

However over the last few nights I've probably VTC'd 20 or 30. I'm wondering what the etiquette is for how many per night to VTC using the same old same old "not reproducible" reason?

Because the VTC candidates are derived from SQL I could go nuts and VTC my max 50 flags per day. I haven't written a query to count how candidates there are but it could be many thousand.

So what would be an appropriate number to VTC each day without annoying you? 5, 10, 20?


Here is the query:

SELECT p.Title, p.Id, p.Score, p.ViewCount, p.CreationDate, p.ClosedDate, p.AnswerCount, u.DisplayName
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.AnswerCount = 0
and p.ClosedDate is null
order by p.CreationDate ASC

In total there are 43,981 unanswered questions.

I've started a VTC project based on abandoned questions about EOL Ubuntu versions. Tonight I VTC'd only one so far: https://askubuntu.com/questions/127013/boot-failure-after-shutdown-during-upgrade-from-11-10-to-12-04.

However over the last few nights I've probably VTC'd 20 or 30. I'm wondering what the etiquette is for how many per night to VTC using the same old same old "not reproducible" reason?

Because the VTC candidates are derived from SQL I could go nuts and VTC my max 50 flags per day. I haven't written a query to count how candidates there are but it could be many thousand.

So what would be an appropriate number to VTC each day without annoying you? 5, 10, 20?


Here is the query:

SELECT p.Title, p.Id, p.Score, p.ViewCount, p.CreationDate, p.ClosedDate, p.AnswerCount, u.DisplayName
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.AnswerCount = 0
and p.ClosedDate is null
order by p.CreationDate ASC

I've started a VTC project based on abandoned questions about EOL Ubuntu versions. Tonight I VTC'd only one so far: https://askubuntu.com/questions/127013/boot-failure-after-shutdown-during-upgrade-from-11-10-to-12-04.

However over the last few nights I've probably VTC'd 20 or 30. I'm wondering what the etiquette is for how many per night to VTC using the same old same old "not reproducible" reason?

Because the VTC candidates are derived from SQL I could go nuts and VTC my max 50 flags per day. I haven't written a query to count how candidates there are but it could be many thousand.

So what would be an appropriate number to VTC each day without annoying you? 5, 10, 20?


Here is the query:

SELECT p.Title, p.Id, p.Score, p.ViewCount, p.CreationDate, p.ClosedDate, p.AnswerCount, u.DisplayName
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.AnswerCount = 0
and p.ClosedDate is null
order by p.CreationDate ASC

In total there are 43,981 unanswered questions.

Add SQL query code
Source Link
WinEunuuchs2Unix
  • 104.4k
  • 11
  • 18

I've started a VTC project based on abandoned questions about EOL Ubuntu versions. Tonight I VTC'd only one so far: https://askubuntu.com/questions/127013/boot-failure-after-shutdown-during-upgrade-from-11-10-to-12-04.

However over the last few nights I've probably VTC'd 20 or 30. I'm wondering what the etiquette is for how many per night to VTC using the same old same old "not reproducible" reason?

Because the VTC candidates are derived from SQL I could go nuts and VTC my max 50 flags per day. I haven't written a query to count how candidates there are but it could be many thousand.

So what would be an appropriate number to VTC each day without annoying you? 5, 10, 20?


Here is the query:

SELECT p.Title, p.Id, p.Score, p.ViewCount, p.CreationDate, p.ClosedDate, p.AnswerCount, u.DisplayName
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.AnswerCount = 0
and p.ClosedDate is null
order by p.CreationDate ASC

I've started a VTC project based on abandoned questions about EOL Ubuntu versions. Tonight I VTC'd only one so far: https://askubuntu.com/questions/127013/boot-failure-after-shutdown-during-upgrade-from-11-10-to-12-04.

However over the last few nights I've probably VTC'd 20 or 30. I'm wondering what the etiquette is for how many per night to VTC using the same old same old "not reproducible" reason?

Because the VTC candidates are derived from SQL I could go nuts and VTC my max 50 flags per day. I haven't written a query to count how candidates there are but it could be many thousand.

So what would be an appropriate number to VTC each day without annoying you? 5, 10, 20?

I've started a VTC project based on abandoned questions about EOL Ubuntu versions. Tonight I VTC'd only one so far: https://askubuntu.com/questions/127013/boot-failure-after-shutdown-during-upgrade-from-11-10-to-12-04.

However over the last few nights I've probably VTC'd 20 or 30. I'm wondering what the etiquette is for how many per night to VTC using the same old same old "not reproducible" reason?

Because the VTC candidates are derived from SQL I could go nuts and VTC my max 50 flags per day. I haven't written a query to count how candidates there are but it could be many thousand.

So what would be an appropriate number to VTC each day without annoying you? 5, 10, 20?


Here is the query:

SELECT p.Title, p.Id, p.Score, p.ViewCount, p.CreationDate, p.ClosedDate, p.AnswerCount, u.DisplayName
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1
AND p.AnswerCount = 0
and p.ClosedDate is null
order by p.CreationDate ASC
Source Link
WinEunuuchs2Unix
  • 104.4k
  • 11
  • 18

What are the acceptable number of close votes to initiate per day?

I've started a VTC project based on abandoned questions about EOL Ubuntu versions. Tonight I VTC'd only one so far: https://askubuntu.com/questions/127013/boot-failure-after-shutdown-during-upgrade-from-11-10-to-12-04.

However over the last few nights I've probably VTC'd 20 or 30. I'm wondering what the etiquette is for how many per night to VTC using the same old same old "not reproducible" reason?

Because the VTC candidates are derived from SQL I could go nuts and VTC my max 50 flags per day. I haven't written a query to count how candidates there are but it could be many thousand.

So what would be an appropriate number to VTC each day without annoying you? 5, 10, 20?