remove big sql query that not really used as this.

Remove unused methods too
remove big sql request