|
Lines 306-318
sub SendAlerts {
Link Here
|
| 306 |
# search the biblionumber |
306 |
# search the biblionumber |
| 307 |
my $strsth = $type eq 'claimacquisition' |
307 |
my $strsth = $type eq 'claimacquisition' |
| 308 |
? qq{ |
308 |
? qq{ |
| 309 |
SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.*,aqbooksellers.*, |
309 |
SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.* |
| 310 |
aqbooksellers.id AS booksellerid |
|
|
| 311 |
FROM aqorders |
310 |
FROM aqorders |
| 312 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
311 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
| 313 |
LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber |
312 |
LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber |
| 314 |
LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber |
313 |
LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber |
| 315 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid=aqbooksellers.id |
|
|
| 316 |
WHERE aqorders.ordernumber IN ( |
314 |
WHERE aqorders.ordernumber IN ( |
| 317 |
} |
315 |
} |
| 318 |
: qq{ |
316 |
: qq{ |
| 319 |
- |
|
|