fixed different bugs in class of group, remove IGNORE in sql queries