Fix bug in sql statement, fix publisher encoding problem.