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 DontCountHits Function not (children 1) ExpressionList (children 1) Identifier Refresh Function notEmpty (children 1) ExpressionList (children 1) Identifier URL ExpressionList (children 1) Identifier URL ExpressionList (children 1) OrderByElement (children 1) Identifier PageViews Literal UInt64_10