Lines 1863-1869
sub GetLateOrMissingIssues {
Link Here
|
1863 |
serialid, aqbooksellerid, name, |
1863 |
serialid, aqbooksellerid, name, |
1864 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1864 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1865 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1865 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1866 |
subscription.branchcode |
1866 |
subscription.branchcode, serial.publisheddate |
1867 |
FROM serial |
1867 |
FROM serial |
1868 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1868 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1869 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
1869 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
Lines 1881-1887
sub GetLateOrMissingIssues {
Link Here
|
1881 |
serialid, aqbooksellerid, name, |
1881 |
serialid, aqbooksellerid, name, |
1882 |
biblio.title, planneddate, serialseq, |
1882 |
biblio.title, planneddate, serialseq, |
1883 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1883 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1884 |
subscription.branchcode |
1884 |
subscription.branchcode, serial.publisheddate |
1885 |
FROM serial |
1885 |
FROM serial |
1886 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1886 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1887 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
1887 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |