Lines 223-229
my $strsth =
Link Here
|
223 |
$sqldatewhere |
223 |
$sqldatewhere |
224 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) |
224 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) |
225 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) |
225 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) |
226 |
AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL) |
226 |
AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL AND itemnumber IS NOT NULL) |
227 |
AND issues.itemnumber IS NULL |
227 |
AND issues.itemnumber IS NULL |
228 |
AND reserves.priority <> 0 |
228 |
AND reserves.priority <> 0 |
229 |
AND reserves.suspend = 0 |
229 |
AND reserves.suspend = 0 |
230 |
- |
|
|