>Your problem has nothing to do with CTEs, you are combining implicit

> (SQL-89) joins and explicit (SQL-92) joins, and referencing the
>implicitly joined table from the explicitly joined tables. The rules for
>these have changed in Firebird 3 to be compliant with the SQL
>specification and to avoid hard to diagnose bugs.