SELECT
  DISTINCT(h.obs_thresh)
FROM
  stat_header h,
  line_data_pct ld
WHERE
  HOUR(ld.fcst_valid_beg) IN ('06', '12')
  AND   BINARY h.fcst_var IN ('PROB(APCP_06>12.700)')
  AND   BINARY h.model IN ('EAS-Frac')
  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
  HOUR(ld.fcst_valid_beg) IN ('06', '12')
  AND   BINARY h.fcst_var IN ('PROB(APCP_06>12.700)')
  AND   BINARY h.model IN ('EAS-Frac')
  AND h.stat_header_id = ld.stat_header_id
ORDER BY h.fcst_thresh;

SELECT
    model,
HOUR(fcst_valid_beg) valid_hour,
  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
  HOUR(ld.fcst_valid_beg) IN ('06', '12')
  AND   BINARY h.fcst_var IN ('PROB(APCP_06>12.700)')
  AND   BINARY h.model IN ('EAS-Frac')
  AND h.stat_header_id = ld.stat_header_id
  AND ld.line_data_id = ldt.line_data_id
;

