SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
  vx_mask,
  obtype,
'TMP' fcst_var,
  'ME' 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_sl1l2 ld
WHERE
    BINARY ld.fcst_init_beg IN ('2022-07-21 00:00:00', '2022-07-22 00:00:00', '2022-07-23 00:00:00', '2022-07-24 00:00:00', '2022-07-25 00:00:00', '2022-07-26 00:00:00', '2022-07-27 00:00:00', '2022-07-28 00:00:00')
  AND   BINARY h.vx_mask IN ('CONUS')
  AND   BINARY h.obtype IN ('ADPSFC')
  AND   BINARY h.model IN ('RRFS_smoke_test_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 = 'TMP'
  AND ld.stat_header_id = h.stat_header_id;

