SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 3) ExpressionList (children 3) Identifier conversion.conversionId (alias myConversionId) Identifier click.clickId (alias myClickId) Identifier click.myValue (alias myValue) TablesInSelectQuery (children 3) TablesInSelectQueryElement (children 1) TableExpression (children 1) Subquery (alias conversion) (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 2) ExpressionList (children 2) Identifier conversionId Identifier value (alias myValue) TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier tableConversion TablesInSelectQueryElement (children 2) TableExpression (children 1) Subquery (alias click) (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 2) ExpressionList (children 3) Identifier clickId Identifier conversionId Identifier value (alias myValue) TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier tableClick TableJoin (children 1) Function equals (children 1) ExpressionList (children 2) Identifier click.conversionId Identifier conversion.conversionId TablesInSelectQueryElement (children 2) TableExpression (children 1) Subquery (alias dummy) (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 2) ExpressionList (children 1) Asterisk TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier leftjoin TableJoin (children 1) Function equals (children 1) ExpressionList (children 2) Identifier dummy.id Identifier conversion.conversionId ExpressionList (children 1) OrderByElement (children 1) Identifier myValue