View’s SELECT contains a subquery in the FROM clause

As per documentation:

MySQL Docs

• The SELECT statement cannot contain a subquery in the FROM clause.

Your workaround would be to create a view for each of your subqueries.

Then access those views from within your view view_credit_status