Notice to me: More SQL fun

In order to find it faster the next time:

CREATE VIEW `ACCOUNTING` AS select
concat(`ACCOUNTING_RAW`.`StrippedUserName`,IF(`ACCOUNTING_RAW`.`Realm`,CONCAT('@',`ACCOUNTING_RAW`.`Realm`),'')) AS `UserName`,`ACCOUNTING_RAW`.`StrippedUserName` AS
`StrippedUserName`,`ACCOUNTING_RAW`.`Realm` AS
`Realm`,`ACCOUNTING_RAW`.`CallingStationId` AS
`CallingStationId`,`ACCOUNTING_RAW`.`ClientIPAddress` AS
`ClientIPAddress`,`ACCOUNTING_RAW`.`CalledStationId` AS
`CalledStationId`,substring_index(`ACCOUNTING_RAW`.`CalledStationId`,':',-(1)) AS `SSID`,`ACCOUNTING_RAW`.`NASIPAddress` AS
`NASIPAddress`,`ACCOUNTING_RAW`.`NASPortId` AS
`NASPortId`,`ACCOUNTING_RAW`.`AcctStartTime` AS
`AcctStartTime`,`ACCOUNTING_RAW`.`AcctStopTime` AS
`AcctStopTime`,`ACCOUNTING_RAW`.`AcctUniqueSessionId` AS
`AcctUniqueSessionId`,`ACCOUNTING_RAW`.`AcctSessionTime` AS
`AcctSessionTime`,`ACCOUNTING_RAW`.`AcctInputOctets` AS
`AcctInputOctets`,`ACCOUNTING_RAW`.`AcctOutputOctets` AS
`AcctOutputOctets`,`ACCOUNTING_RAW`.`AcctTerminateCause` AS
`AcctTerminateCause` from `ACCOUNTING_RAW`;
Advertisements