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