bug 2429 fix up index by using IN / NOT IN instead of (!= and !=)