#340 Create a report of novels in series

[Ahasuerus]

One of the questions that frequently arise during internet discussions of SF is whether more recent novels belong to series compared to the way things were in the past. The following SQL query provides at least a partial answer:

select substring(title_copyright,1,4),count(*) as total, count(series_id>0) as in_series, count(series_id>0)/count(*)*100 as ratio from titles where title_ttype='NOVEL' and substring(title_copyright,1,4)>1899 and title_parent=0 group by substring(title_copyright,1,4)

It would be nice to create a report that would show this information graphically. It could be run either in real time (the query takes about a second on the development server) or nightly, in which case the data would be stored in an HTML file.

[Ahasuerus]

Implemented in:

biblio/novels_in_series.py 1.1
biblio/stats-and-tops.py 1.8
biblio/TARGETS 1.22
common/library.py 1.36
nightly/nightly_update.py 1.6

Installed in r2014-48 on 2014-01-20. Closing.