|
Lines 24-32
sub get_counts() {
Link Here
|
| 24 |
(SELECT count(*) FROM statistics WHERE branch="NO_LIBRARY" ) AS NO_LIBRARY, |
24 |
(SELECT count(*) FROM statistics WHERE branch="NO_LIBRARY" ) AS NO_LIBRARY, |
| 25 |
(SELECT count(*) FROM statistics WHERE branch IS NULL) AS NULL_BRANCH, |
25 |
(SELECT count(*) FROM statistics WHERE branch IS NULL) AS NULL_BRANCH, |
| 26 |
(SELECT count(*) FROM statistics WHERE itemtype IS NULL AND itemnumber IS NOT NULL) AS NULL_ITEMTYPE, |
26 |
(SELECT count(*) FROM statistics WHERE itemtype IS NULL AND itemnumber IS NOT NULL) AS NULL_ITEMTYPE, |
| 27 |
(SELECT count(*) FROM statistics WHERE usercode IS NULL) AS NULL_USERCODE, |
|
|
| 28 |
(SELECT count(*) FROM statistics WHERE borrowernumber IS NULL) AS NULL_BORROWERNUMBER, |
27 |
(SELECT count(*) FROM statistics WHERE borrowernumber IS NULL) AS NULL_BORROWERNUMBER, |
| 29 |
(SELECT count(*) FROM statistics WHERE associatedborrower IS NULL) AS NULL_ASSOCIATEDBORROWER, |
|
|
| 30 |
(SELECT count(*) FROM statistics ) AS Total |
28 |
(SELECT count(*) FROM statistics ) AS Total |
| 31 |
); |
29 |
); |
| 32 |
my $sth = $dbh->prepare($query); |
30 |
my $sth = $dbh->prepare($query); |