select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from radacct where (1=1) and Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00'
and
(ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '')
MediaInfo (after update from mediaproxy) is NOT null... the rest of the fields are ok.
Look again at the SQL query of above:
MediaInfo is NULL or MediaInfo != ''
It's not needed that MediaInfo is NULL, it can be any value except NULL or empty string.
That's it, it IS an empry string, so it will never rate it