What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 127 Stack Exchange communities.

Here's one for those who like a toasted brain sandwich.

I was running some stats using [data.SE] and noticed a few strange entries in the DB, so I wrote another query to single these out.


It looks for questions that have an accepted answer value and an accepted answer count of zero.

I would have expected this to return 0 row(s) in all cases, however running this query on the android tag I get 3 results.

At first I thought there was a definitive logic behind it based on question merging. Upon closer inspection I noticed something a little more curious:

  • #3428187 was merged and has no closed date
  • #5215141 was merged but this has a closed date
  • #2228827 not merged, no close date and has a creation date in a different format than the others

I tried to decipher what the story behind these was by looking at them on SO but my sleuthing deerstalker had been stolen by a klepto-maniacal lolcat while I was buried in SQL.

Can anybody shed some light on what I'm missing other than a tatty old hat and the fish I was going to cook for supper?

share|improve this question
"...but has a creation date in a different format than the others" - That's actually just my inability to count, sorry about that. –  Tim Stone Jul 14 '12 at 0:53
@TimStone +1 for honesty ;) –  Merlin Jul 14 '12 at 0:57
The third question has had its accepted answer deleted, but it is still marked as accepted. –  ughoavgfhw Jul 14 '12 at 1:07
add comment

You must log in to answer this question.

Browse other questions tagged .