Problem while filtering by ‘category_name’

This:

WHERE 1=1 AND 0 = 1

Usually indicates a meta_query or tax_query failure, in you case, the latter. This doesn’t mean there are no results it means …

1. That the taxonomy doesn’t exist. In this case, you are dealing with
   a Core taxonomy so this is unlikely.
2. The term is bad. This is a strong possibility. Make sure the term is
   correct and that you are using the slug and not the name,
   despite the parameter name.
3. The taxonomy is not valid for the chosen post type. You claim that
   there is content assigned to the term. In order for that to be true
   you would have to have registered the taxonomy to the post type.
   Still, I suspect that this is the problem.