|
Lines 58-64
SELECT
Link Here
|
| 58 |
ecost_tax_included, budgetdate, entrydate, |
58 |
ecost_tax_included, budgetdate, entrydate, |
| 59 |
aqbasket.booksellerid, |
59 |
aqbasket.booksellerid, |
| 60 |
aqbooksellers.name as vendorname, |
60 |
aqbooksellers.name as vendorname, |
| 61 |
itype, |
61 |
GROUP_CONCAT(DISTINCT itype), |
| 62 |
title |
62 |
title |
| 63 |
FROM (aqorders, aqbasket) |
63 |
FROM (aqorders, aqbasket) |
| 64 |
LEFT JOIN biblio ON |
64 |
LEFT JOIN biblio ON |
|
Lines 80-86
WHERE
Link Here
|
| 80 |
ecost_tax_included, budgetdate, entrydate, |
80 |
ecost_tax_included, budgetdate, entrydate, |
| 81 |
aqbasket.booksellerid, |
81 |
aqbasket.booksellerid, |
| 82 |
aqbooksellers.name, |
82 |
aqbooksellers.name, |
| 83 |
itype, |
|
|
| 84 |
title |
83 |
title |
| 85 |
EOQ |
84 |
EOQ |
| 86 |
|
85 |
|