SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 6) ExpressionList (children 2) Identifier URL Function count (alias PageViews) (children 1) ExpressionList TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier test.hits_s3 Function and (children 1) ExpressionList (children 6) Function equals (children 1) ExpressionList (children 2) Identifier CounterID Literal UInt64_62 Function greaterOrEquals (children 1) ExpressionList (children 2) Identifier EventDate Literal \'2013-07-01\' Function lessOrEquals (children 1) ExpressionList (children 2) Identifier EventDate Literal \'2013-07-31\' Function not (children 1) ExpressionList (children 1) Identifier Refresh Identifier IsLink Function not (children 1) ExpressionList (children 1) Identifier IsDownload ExpressionList (children 1) Identifier URL ExpressionList (children 1) OrderByElement (children 1) Identifier PageViews Literal UInt64_1000