SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
'APCP_01' fcst_var,
  'NBR_FAR' stat_name,
  'NA' stat_value,
  ld.total,
  ld.fy_oy,
  ld.fy_on,
  ld.fn_oy,
  ld.fn_on,
  ld.ec_value 
FROM
  stat_header h,
  line_data_nbrctc ld
WHERE
    BINARY h.fcst_var IN ('APCP_01')
  AND   BINARY h.model IN ('HRRR_mem000')
  AND   BINARY ld.fcst_lead IN ('10000', '20000', '30000', '40000', '50000', '60000')
  AND   BINARY h.fcst_var = 'APCP_01'
  AND ld.stat_header_id = h.stat_header_id
UNION ALL
SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
'APCP_01' fcst_var,
  'NBR_PODY' stat_name,
  'NA' stat_value,
  ld.total,
  ld.fy_oy,
  ld.fy_on,
  ld.fn_oy,
  ld.fn_on,
  ld.ec_value 
FROM
  stat_header h,
  line_data_nbrctc ld
WHERE
    BINARY h.fcst_var IN ('APCP_01')
  AND   BINARY h.model IN ('HRRR_mem000')
  AND   BINARY ld.fcst_lead IN ('10000', '20000', '30000', '40000', '50000', '60000')
  AND   BINARY h.fcst_var = 'APCP_01'
  AND ld.stat_header_id = h.stat_header_id;

