We have been filtering out all the inactive albums (there are over 150, many of which are just dupes - I should probably delete those ones), but it looks like the boolean logic in the WHERE clause wasn't quite right given the operator precedence -- we had a AND b AND c OR d, when it should have been a AND ((b AND c) OR d). So, if there wasn't a release month or day, the last OR took precedence, and we got inactive albums on the bottom of the January calendars.
Anyway, it's fixed now. Thanks for finding this tricky one.
|