SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 6) ExpressionList (children 5) Function uniq (children 1) ExpressionList (children 1) Identifier SearchPhrase Function max (children 1) ExpressionList (children 1) Identifier URL Function max (children 1) ExpressionList (children 1) Identifier Title Function count (alias c) (children 1) ExpressionList Function uniq (children 1) ExpressionList (children 1) Identifier UserID TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier test.hits_s3 Function and (children 1) ExpressionList (children 3) Function like (children 1) ExpressionList (children 2) Identifier Title Literal \'%Яндекс%\' Function notLike (children 1) ExpressionList (children 2) Identifier URL Literal \'%.yandex.%\' Function notEquals (children 1) ExpressionList (children 2) Identifier SearchPhrase Literal \'\' ExpressionList (children 1) Identifier SearchPhrase ExpressionList (children 1) OrderByElement (children 1) Identifier c Literal UInt64_10