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.
https://data.stackexchange.com/stackoverflow/query/75337/bizarre-question-stats-by-tag
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?