> -AND items.itemnumber NOT IN (SELECT itemnumber FROM issues) > +AND issues.itemnumber IS NULL >
Now that's an important change! It keeps the subquery from crippling the system hitting every row in the issues table. -- Joe Atzberger LibLime - Open Source Library Solutions
_______________________________________________ Koha-patches mailing list [email protected] http://lists.koha.org/mailman/listinfo/koha-patches
