Basic SQL-MapReduce Call Structure - Aster Analytics

SELECT ...
  FROM nPath (...
  SYMBOLS (pageid IN (10, 25) AS A,
    category = 10 OR (category = 20 AND pageid <> 33) AS B,
    category IN (SELECT pageid
      FROM clicks1
      GROUP BY userid
      HAVING COUNT(*) > 10
    ) AS C,
    referrer LIKE '%Amazon%' AS D,
    true AS X
  ) ...
) ...