|
Lines 276-282
sub GetSubscription {
Link Here
|
| 276 |
aqbooksellers.name AS aqbooksellername, |
276 |
aqbooksellers.name AS aqbooksellername, |
| 277 |
biblio.title AS bibliotitle, |
277 |
biblio.title AS bibliotitle, |
| 278 |
biblio.subtitle AS bibliosubtitle, |
278 |
biblio.subtitle AS bibliosubtitle, |
| 279 |
subscription.biblionumber as bibnum |
279 |
subscription.biblionumber as bibnum, |
|
|
280 |
subscription.subscriptionid as subscriptionid |
| 280 |
FROM subscription |
281 |
FROM subscription |
| 281 |
LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid |
282 |
LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid |
| 282 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id |
283 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id |
| 283 |
- |
|
|