Finding parent transactions in a New Relic NRQL query based on searching child transactions

gistfile1.txt

select count(*) from Transaction facet name where guid in (
   select parentId from (
      select count(*) from Transaction facet parentId
      where appName = '...' and request_user_id = ... and name = '...'
      limit max
   )
   limit max
)
since 3 days ago limit max