|
Lines 1893-1899
sub GetLateOrMissingIssues {
Link Here
|
| 1893 |
"SELECT |
1893 |
"SELECT |
| 1894 |
serialid, aqbooksellerid, name, |
1894 |
serialid, aqbooksellerid, name, |
| 1895 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1895 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
| 1896 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1896 |
serial.status, serial.subscriptionid, claimdate, serial.notes AS notes, claims_count, |
| 1897 |
subscription.branchcode, serial.publisheddate |
1897 |
subscription.branchcode, serial.publisheddate |
| 1898 |
FROM serial |
1898 |
FROM serial |
| 1899 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1899 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
|
Lines 1911-1917
sub GetLateOrMissingIssues {
Link Here
|
| 1911 |
"SELECT |
1911 |
"SELECT |
| 1912 |
serialid, aqbooksellerid, name, |
1912 |
serialid, aqbooksellerid, name, |
| 1913 |
biblio.title, planneddate, serialseq, |
1913 |
biblio.title, planneddate, serialseq, |
| 1914 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1914 |
serial.status, serial.subscriptionid, claimdate, serial.notes AS notes, claims_count, |
| 1915 |
subscription.branchcode, serial.publisheddate |
1915 |
subscription.branchcode, serial.publisheddate |
| 1916 |
FROM serial |
1916 |
FROM serial |
| 1917 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1917 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |