MYSQL EXAMPLES
lpad(hex(mac_addr),12,"0") mac_addr
CONVERT(inet_ntoa(ip_addr) USING ASCII) ip_addr
CONVERT_TZ(meter_online_timestamp,'+0:00','SYSTEM') as meter_online_timestamp,
CONVERT_TZ(lastedit_utc_timestamp,'+0:00','SYSTEM') as last_edit_timestamp,
left join customerinfo.backend_user bu on bu.id_backend_user = meter_info.lastedit_by_id_backend_user
left join meter_type mt on mt.idMeter_Type = meter_info.meter_type_id