Lines 1867-1873
sub GetLateOrMissingIssues {
Link Here
|
1867 |
serialid, aqbooksellerid, name, |
1867 |
serialid, aqbooksellerid, name, |
1868 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1868 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1869 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1869 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1870 |
subscription.branchcode |
1870 |
subscription.branchcode, serial.publisheddate |
1871 |
FROM serial |
1871 |
FROM serial |
1872 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1872 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1873 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
1873 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
Lines 1885-1891
sub GetLateOrMissingIssues {
Link Here
|
1885 |
serialid, aqbooksellerid, name, |
1885 |
serialid, aqbooksellerid, name, |
1886 |
biblio.title, planneddate, serialseq, |
1886 |
biblio.title, planneddate, serialseq, |
1887 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1887 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1888 |
subscription.branchcode |
1888 |
subscription.branchcode, serial.publisheddate |
1889 |
FROM serial |
1889 |
FROM serial |
1890 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1890 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1891 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
1891 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |