Cacher is the code snippet organizer for pro developers

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