CTEs would be such a blessing. I am stuck using mysql 5.6. So many queries would just get simpler.