Lines 60-66
SELECT
Link Here
|
60 |
aqbooksellers.name as vendorname, |
60 |
aqbooksellers.name as vendorname, |
61 |
GROUP_CONCAT(DISTINCT itype SEPARATOR '|') AS itypes, |
61 |
GROUP_CONCAT(DISTINCT itype SEPARATOR '|') AS itypes, |
62 |
title |
62 |
title |
63 |
FROM (aqorders, aqbasket) |
63 |
FROM aqorders |
|
|
64 |
JOIN aqbasket USING (basketno) |
64 |
LEFT JOIN biblio ON |
65 |
LEFT JOIN biblio ON |
65 |
biblio.biblionumber=aqorders.biblionumber |
66 |
biblio.biblionumber=aqorders.biblionumber |
66 |
LEFT JOIN aqorders_items ON |
67 |
LEFT JOIN aqorders_items ON |
Lines 70-76
LEFT JOIN items ON
Link Here
|
70 |
LEFT JOIN aqbooksellers ON |
71 |
LEFT JOIN aqbooksellers ON |
71 |
aqbasket.booksellerid = aqbooksellers.id |
72 |
aqbasket.booksellerid = aqbooksellers.id |
72 |
WHERE |
73 |
WHERE |
73 |
aqorders.basketno=aqbasket.basketno AND |
|
|
74 |
budget_id=? AND |
74 |
budget_id=? AND |
75 |
(datecancellationprinted IS NULL OR |
75 |
(datecancellationprinted IS NULL OR |
76 |
datecancellationprinted='0000-00-00') AND |
76 |
datecancellationprinted='0000-00-00') AND |
77 |
- |
|
|