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