There are <% $books %> in the catalog.
I have found <% $not_pd %> books at Google Books with a possible publication date prior to 1922 which are considered not public domain by Google Books.
There are <% $marc %> MARC records loaded for <% $unique %> books.
There are <% $lccn %> books with probable LCCN numbers.
There are <% $oclc %> books with probable OCLC numbers.
<%init> use Apache::DBI; my $dbh=DBI->connect('dbi:Pg:dbname=pdbooks', 'webserver_proxy', ''); my ($books) = $dbh->selectrow_array("select count(*) from books where google_view = 'Full'"); my ($not_pd) = $dbh->selectrow_array("select count(*) from books where google_view != 'Full'"); my ($unique, $marc) = $dbh->selectrow_array('select count(distinct book_id), count(*) from book_marcs'); $marc=0 unless $marc; my ($lccn) = $dbh->selectrow_array("select count(*) from books where book_url like '%LCCN%'"); my ($oclc) = $dbh->selectrow_array("select count(*) from books where book_url like '%OCLC%'"); $dbh->disconnect;