You also might want to try casting every column in the query as VARCHAR. Then insert into a temp table/physical table to see if any value in a column of int is not an int.

These conversion errors with a lot of tables/views can be hard to debug and pinpoint exactly what column the error is coming from.