Not a good indentation. Took me time to see what this is doing.

Maybe try something like this: 
```sql
 (select * from featured_projects) union
 (select * from recommended_projects) union
 (select * from expiring_projects) union
 (select * from soon_projects) union
 (select * from successful_projects)
```