SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 6) ExpressionList (children 3) Identifier URLHash Identifier EventDate 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 Function in (children 1) ExpressionList (children 2) Identifier TraficSourceID Literal Tuple_(Int64_-1, UInt64_6) Function equals (children 1) ExpressionList (children 2) Identifier RefererHash Function halfMD5 (children 1) ExpressionList (children 1) Literal \'http://example.ru/\' ExpressionList (children 2) Identifier URLHash Identifier EventDate ExpressionList (children 1) OrderByElement (children 1) Identifier PageViews Literal UInt64_100