Instead of relying on one query, catching and exception and then another
 fallback query, we now use a case statement which always work.