SELECT
LOG_DATE,
[0] AS L_SOC, 
[1]*1.0/10 AS L_BATT_VOLTS, 
CASE
WHEN [32] = '32768' THEN 'NORMAL'
WHEN [32] = '32770' THEN 'MPPT'
WHEN [32] = '32771' THEN 'EQUALISE'
WHEN [32] = '32772' THEN 'BOOST'
WHEN [32] = '32773' THEN 'FLOAT'
END AS 'STATUS',
[2]*1.0/100 AS L_BATT_CHARGE_AMPS, 
[5]*1.0/100 AS L_LOAD_AMPS, 
[6] AS L_LOAD_WATTS, 
[35]*1.0/100 AS L_DIRECT_LOAD_AMPS, 
[7]*1.0/10 AS L_SOLAR_VOLTS, 
[8]*1.0/100 AS L_SOLAR_AMPS,

CASE substr(printf('%08X', [3]), 7, 2)
WHEN '0A' THEN '10'
WHEN '0B' THEN '11'
WHEN '0C' THEN '12'
WHEN '0D' THEN '13'
WHEN '0E' THEN '14'
WHEN '0F' THEN '15'
WHEN '10' THEN '16'
WHEN '11' THEN '17'
WHEN '12' THEN '18'
WHEN '13' THEN '19'
WHEN '14' THEN '20'
WHEN '15' THEN '21'
WHEN '16' THEN '22'
WHEN '17' THEN '23'
WHEN '18' THEN '24'
WHEN '19' THEN '25'
WHEN '1A' THEN '26'
WHEN '1B' THEN '27'
WHEN '1C' THEN '28'
WHEN '1D' THEN '29'
WHEN '1E' THEN '30'
WHEN '1F' THEN '31'
WHEN '20' THEN '32'
WHEN '21' THEN '33'
WHEN '22' THEN '34'
WHEN '23' THEN '35'
WHEN '24' THEN '36'
WHEN '25' THEN '37'
WHEN '26' THEN '38'
WHEN '27' THEN '39'
WHEN '28' THEN '40'
WHEN '29' THEN '41'
WHEN '2A' THEN '42'
WHEN '2B' THEN '43'
WHEN '2C' THEN '44'
WHEN '2D' THEN '45'
WHEN '2E' THEN '46'
WHEN '2F' THEN '47'
WHEN '30' THEN '48'
WHEN '31' THEN '49'
WHEN '32' THEN '50'
ELSE substr(printf('%08X', [3]), 7, 2)
END AS 'L_BATT_TEMP',

CASE substr(printf('%08X', [3]), 5, 2)
WHEN '0A' THEN '10'
WHEN '0B' THEN '11'
WHEN '0C' THEN '12'
WHEN '0D' THEN '13'
WHEN '0E' THEN '14'
WHEN '0F' THEN '15'
WHEN '10' THEN '16'
WHEN '11' THEN '17'
WHEN '12' THEN '18'
WHEN '13' THEN '19'
WHEN '14' THEN '20'
WHEN '15' THEN '21'
WHEN '16' THEN '22'
WHEN '17' THEN '23'
WHEN '18' THEN '24'
WHEN '19' THEN '25'
WHEN '1A' THEN '26'
WHEN '1B' THEN '27'
WHEN '1C' THEN '28'
WHEN '1D' THEN '29'
WHEN '1E' THEN '30'
WHEN '1F' THEN '31'
WHEN '20' THEN '32'
WHEN '21' THEN '33'
WHEN '22' THEN '34'
WHEN '23' THEN '35'
WHEN '24' THEN '36'
WHEN '25' THEN '37'
WHEN '26' THEN '38'
WHEN '27' THEN '39'
WHEN '28' THEN '40'
WHEN '29' THEN '41'
WHEN '2A' THEN '42'
WHEN '2B' THEN '43'
WHEN '2C' THEN '44'
WHEN '2D' THEN '45'
WHEN '2E' THEN '46'
WHEN '2F' THEN '47'
WHEN '30' THEN '48'
WHEN '31' THEN '49'
WHEN '32' THEN '50'
ELSE substr(printf('%08X', [3]), 5, 2)
END AS 'L_DEV_TEMP',

[11]*1.0/10 AS D_BATT_VOLTS_MIN, 
[12]*1.0/10 AS D_BATT_VOLTS_MAX, 
[13]*1.0/100 AS D_BATT_CHARGE_AMPS_MAX, 
[14]*1.0/100 AS D_BATT_DISCHARGE_AMPS_MAX, 
[39]*1.0/100 AS D_DIRECT_LOAD_AMPS_MAX,
[15] AS D_BATT_CHARGE_WATTS_MAX, 
[16] AS D_BATT_DISCHARGE_WATTS_MAX, 
[17] AS D_CHARGE_AH, 
[18] AS D_DISCHARGE_AH, 
[36]*1.0/1000 AS D_DIRECT_LOAD_DISCHARGE_AH, 
[19]*1.0/1000 AS D_CHARGE_KWH, 
[20]*1.0/1000 AS D_DISCHARGE_KWH, 

[21] AS G_RUNNING_DAYS, 
[23] AS G_FULL_DAYS, 
[25] AS G_CHARGE_AH, 
[27] AS G_DISCHARGE_AH, 
[29]*1.0/1000 AS G_CHARGE_KWH, 
[31]*1.0/1000 AS G_DISCHARGE_KWH, 

[37] AS NO_INTERNET_COUNT, 
[38] AS INTERNET_RESET_DATE, 

[4],
[9],
[10],
[22],
[24],
[26],
[28],
[30],
[33],
[34]

FROM
LOG
ORDER BY LOG_DATE DESC