Lines 62-71
SELECT
Link Here
|
62 |
FROM (aqorders, aqbasket) |
62 |
FROM (aqorders, aqbasket) |
63 |
LEFT JOIN biblio ON |
63 |
LEFT JOIN biblio ON |
64 |
biblio.biblionumber=aqorders.biblionumber |
64 |
biblio.biblionumber=aqorders.biblionumber |
65 |
LEFT JOIN aqorders_items ON |
65 |
LEFT JOIN |
66 |
aqorders.ordernumber=aqorders_items.ordernumber |
66 |
(SELECT ordernumber, GROUP_CONCAT(DISTINCT itype) as itype |
67 |
LEFT JOIN items ON |
67 |
FROM aqorders_items |
68 |
items.itemnumber=aqorders_items.itemnumber |
68 |
LEFT JOIN items USING (itemnumber) |
|
|
69 |
GROUP BY ordernumber) aqitems USING (ordernumber) |
69 |
LEFT JOIN aqbooksellers ON |
70 |
LEFT JOIN aqbooksellers ON |
70 |
aqbasket.booksellerid = aqbooksellers.id |
71 |
aqbasket.booksellerid = aqbooksellers.id |
71 |
WHERE |
72 |
WHERE |
Lines 74-80
WHERE
Link Here
|
74 |
(datecancellationprinted IS NULL OR |
75 |
(datecancellationprinted IS NULL OR |
75 |
datecancellationprinted='0000-00-00') AND |
76 |
datecancellationprinted='0000-00-00') AND |
76 |
(quantity > quantityreceived OR quantityreceived IS NULL) |
77 |
(quantity > quantityreceived OR quantityreceived IS NULL) |
77 |
GROUP BY aqorders.ordernumber |
|
|
78 |
EOQ |
78 |
EOQ |
79 |
|
79 |
|
80 |
my $sth = $dbh->prepare($query); |
80 |
my $sth = $dbh->prepare($query); |