SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 6) ExpressionList (children 2) Identifier Title 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 Title ExpressionList (children 1) Identifier Title ExpressionList (children 2) OrderByElement (children 1) Identifier PageViews OrderByElement (children 1) Identifier Title Literal UInt64_10