Lines 1937-1943
sub GetLateOrMissingIssues {
Link Here
|
1937 |
"SELECT |
1937 |
"SELECT |
1938 |
serialid, aqbooksellerid, name, |
1938 |
serialid, aqbooksellerid, name, |
1939 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1939 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1940 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1940 |
serial.status, serial.subscriptionid, claimdate, serial.notes AS notes, claims_count, |
1941 |
subscription.branchcode, serial.publisheddate |
1941 |
subscription.branchcode, serial.publisheddate |
1942 |
FROM serial |
1942 |
FROM serial |
1943 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1943 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
Lines 1955-1961
sub GetLateOrMissingIssues {
Link Here
|
1955 |
"SELECT |
1955 |
"SELECT |
1956 |
serialid, aqbooksellerid, name, |
1956 |
serialid, aqbooksellerid, name, |
1957 |
biblio.title, planneddate, serialseq, |
1957 |
biblio.title, planneddate, serialseq, |
1958 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1958 |
serial.status, serial.subscriptionid, claimdate, serial.notes AS notes, claims_count, |
1959 |
subscription.branchcode, serial.publisheddate |
1959 |
subscription.branchcode, serial.publisheddate |
1960 |
FROM serial |
1960 |
FROM serial |
1961 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1961 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |