added path enumeration to make our child queries much easier and less abusive on the database