Ben Reiniger wrote on Tue, Jun 30, 2020 03:19 AM UTC:
I fixed a bug on this page: the query ordered by CreationDate but tried to group for display based on ModifiedDate; I think here having the query order by ModifiedDate makes more sense. However, there are a handful of pages here with ModifiedDate=0000-00-00, which get tacked on at the end.
@Fergus, I'm not sure what causes a page will have this degenerate ModifiedDate? Even your test page that has revisions in the table suffers that affliction.
I fixed a bug on this page: the query ordered by CreationDate but tried to group for display based on ModifiedDate; I think here having the query order by ModifiedDate makes more sense. However, there are a handful of pages here with ModifiedDate=0000-00-00, which get tacked on at the end.
@Fergus, I'm not sure what causes a page will have this degenerate ModifiedDate? Even your test page that has revisions in the table suffers that affliction.