one mega query to rule them all