#94 Serials not sorted chronologically on Summary and Title page

[Ahasuerus]

Serial records are not sorted chronologically on the Title page, e.g. Ray Cumming's "The Man on the Meteor" (http://www.isfdb.org/cgi-bin/title.cgi?1018277) lists the related Serial records in the following order:

* The Man on the Meteor (Complete Novel) (1941)
* The Man on the Meteor (Part 1 of 14) (1975)
* The Man on the Meteor (Part 1 of 9) (1924)
* The Man on the Meteor (Part 10 of 14) (Chapters 23 & 24) (1975)
* The Man on the Meteor (Part 11 of 14) (Chapters 25 & 26) (1975)
* The Man on the Meteor (Part 12 of 14) (1976)
* The Man on the Meteor (Part 13 of 14) (1976)
* The Man on the Meteor (Part 14 of 14) (1976)
* The Man on the Meteor (Part 2 of 14) (1975)
* The Man on the Meteor (Part 2 of 9) (1924)
* The Man on the Meteor (Part 3 of 14) (Chapters 5-7) (1975)
* The Man on the Meteor (Part 3 of 9) (1924)
* The Man on the Meteor (Part 4 of 14) (1975)
* The Man on the Meteor (Part 4 of 9) (1924)
* The Man on the Meteor (Part 5 of 14) (1975)
* The Man on the Meteor (Part 5 of 9) (1924)
* The Man on the Meteor (Part 6 of 14) (1975)
* The Man on the Meteor (Part 6 of 9) (1924)
* The Man on the Meteor (Part 7 of 14) (1975)
* The Man on the Meteor (Part 7 of 9) (1924)
* The Man on the Meteor (Part 8 of 14) (Chapters 19 & 20) (1975)
* The Man on the Meteor (Part 8 of 9) (1924)
* The Man on the Meteor (Part 9 of 14) (Chapters 21 & 22) (1975)
* The Man on the Meteor (Part 9 of 9) (1924)

Apparently, the lexical match display logic alphabetizes Serial titles without paying attention to dates. This is likely to change once we convert Serial to VTs, but we need to make sure that the end result sorts by date first and by title second.

[Ahasuerus]

Assigned to Marty.

[MartyD]

A similar problem existed on the Summary page. This is fixed by the commits of common/SQLparsing.py 1.23 (for SQLgetAuthorVariants, used in the Summary page) and 1.24 (for SQLgetTitleVariants, used in the Title page). The queries were unsorted; added primary sort by title_copyright and secondary sort by title_title (helps serials when all installments have the same date; this breaks down when there are 10 or more installments, but it's better than nothing).

[Ahasuerus]

Implemented in r2009-22.