Subqueries are the bane of my life.