SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
'APCP_03' fcst_var,
  'FAR' 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_var IN ('APCP_03')
  AND   BINARY h.model IN ('HREF')
  AND   BINARY ld.fcst_lead IN ('30000')
  AND   BINARY h.fcst_var = 'APCP_03'
  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_03' fcst_var,
  'PODY' 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_var IN ('APCP_03')
  AND   BINARY h.model IN ('HREF')
  AND   BINARY ld.fcst_lead IN ('30000')
  AND   BINARY h.fcst_var = 'APCP_03'
  AND ld.stat_header_id = h.stat_header_id;

