|
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 |