- Post "Diagnostic info" from Admin > Troubleshooting.
- Post which database type you are querying.
- You are using a different filter table reference than what you are using in your query.
Read this: https://www.metabase.com/learn/sql-questions/field-filters.html