|
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 |
- |
|
|