SELECT
  DISTINCT(h.obs_thresh)
FROM
  stat_header h,
  line_data_pct ld
WHERE
    BINARY h.fcst_var IN ('APCP_03')
  AND   BINARY h.model IN ('HRRR_sppmp_ens_hrconus')
  AND h.stat_header_id = ld.stat_header_id
ORDER BY h.obs_thresh;

SELECT
  DISTINCT(h.fcst_thresh) thresh
FROM
  stat_header h,
  line_data_pct ld
WHERE
    BINARY h.fcst_var IN ('APCP_03')
  AND   BINARY h.model IN ('HRRR_sppmp_ens_hrconus')
  AND h.stat_header_id = ld.stat_header_id
ORDER BY h.fcst_thresh;

SELECT
    model,
  ldt.i_value,
  ldt.thresh_i,
  ldt.oy_i oy_i,
  ldt.on_i on_i,
   ld.fcst_valid_beg, 
   ld.fcst_lead 
FROM
  stat_header h,
  line_data_pct ld,
  line_data_pct_thresh ldt
WHERE
    BINARY h.fcst_var IN ('APCP_03')
  AND   BINARY h.model IN ('HRRR_sppmp_ens_hrconus')
  AND h.stat_header_id = ld.stat_header_id
  AND ld.line_data_id = ldt.line_data_id;

