SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
  vx_mask,
  HOUR(fcst_init_beg) init_hour,
  obtype,
'AOTK' fcst_var,
  'CSI' stat_name,
  'NA' stat_value,
  ld.total,
  ld.fbar,
  ld.obar,
  ld.fobar,
  ld.ffbar,
  ld.oobar,
 ld.mae
FROM
  stat_header h,
  line_data_cts ld
WHERE
    BINARY h.vx_mask IN ('CONUS')
  AND   BINARY ld.fcst_init_beg IN ('2023-07-02 00:00:00', '2023-07-03 00:00:00', '2023-07-04 00:00:00', '2023-07-05 00:00:00')
  AND HOUR(ld.fcst_init_beg) IN ('00')
  AND   BINARY h.obtype IN ('AERONET_AOD')
  AND   BINARY h.model IN ('RRFS_verification_mem000')
  AND   BINARY ld.fcst_lead IN ('0', '10000', '20000', '30000', '40000', '50000', '60000', '70000', '80000', '90000', '100000', '110000', '120000', '130000', '140000', '150000', '160000', '170000', '180000', '190000', '200000', '210000', '220000', '230000', '240000', '250000', '260000', '270000', '280000', '290000', '300000', '310000', '320000', '330000', '340000', '350000', '360000', '370000', '380000', '390000', '400000', '410000', '420000', '430000', '440000', '450000', '460000', '470000', '480000', '490000', '500000', '510000', '520000', '530000', '540000', '550000', '560000', '570000', '580000', '590000', '600000', '610000', '620000', '630000', '640000', '650000', '660000', '670000', '680000', '690000', '700000', '710000', '720000', '730000', '740000', '750000', '760000', '770000', '780000', '790000', '800000', '810000', '820000', '830000', '840000')
  AND   BINARY h.fcst_var = 'AOTK'
  AND ld.stat_header_id = h.stat_header_id;

