SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
  fcst_thresh,
'APCP_03' fcst_var,
  'FBIAS' stat_name,
  ld.total, ld.fy_oy, ld.fy_on, ld.fn_oy, ld.fn_on, 'NA' stat_value,
  'NA' stat_ncl,
  'NA' stat_ncu,
  'NA' stat_bcl,
  'NA' stat_bcu
FROM
  stat_header h,
  line_data_ctc ld
WHERE
    BINARY h.fcst_thresh IN ('>=0.254')
  AND   BINARY h.model IN ('HRRR_sppmp_mem1_ctrlvx_hrconus', 'HRRR_sppmp_mem2_ctrlvx_hrconus', 'HRRR_sppmp_mem3_ctrlvx_hrconus', 'HRRR_sppmp_mem4_ctrlvx_hrconus', 'HRRR_sppmp_mem5_ctrlvx_hrconus', 'HRRR_sppmp_mem6_ctrlvx_hrconus', 'HRRR_sppmp_mem7_ctrlvx_hrconus')
  AND   BINARY ld.fcst_lead IN ('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')
  AND   BINARY h.fcst_var = 'APCP_03'
  AND ld.stat_header_id = h.stat_header_id;

