View | Details | Raw Unified | Return to bug 25223
Collapse All | Expand All

(-)a/acqui/ordered.pl (-3 / +2 lines)
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
- 

Return to bug 25223