SELECT
  model,
  NOW()  fcst_init,
  fcst_valid,
  fcst_lead,
  fcst_thr,
'WRF_precip' fcst_var,
  'AREATHR_FSU' stat_name,
  area_thresh stat_value
FROM
  mode_header ,
  mode_obj_single ,
  mode_cts 
WHERE
    BINARY fcst_thr IN ('>=2.54')
  AND   BINARY model IN ('AI_step06')
  AND   BINARY fcst_lead IN ('10000', '20000', '30000', '40000', '50000', '60000', '70000', '80000', '90000', '100000', '110000', '120000')
 AND  BINARY  fcst_var = 'WRF_precip'
  AND fcst_flag = 1
  AND simple_flag = 1
  AND matched_flag = 0  AND mode_obj_single.mode_header_id = mode_header.mode_header_id
  AND mode_cts.mode_header_id = mode_obj_single.mode_header_id
  AND mode_cts.field = 'OBJECT'

SELECT
  model,
  NOW()  fcst_init,
  fcst_valid,
  fcst_lead,
  fcst_thr,
'WRF_precip' fcst_var,
  'AREATHR_OSU' stat_name,
  area_thresh stat_value
FROM
  mode_header ,
  mode_obj_single ,
  mode_cts 
WHERE
    BINARY fcst_thr IN ('>=2.54')
  AND   BINARY model IN ('AI_step06')
  AND   BINARY fcst_lead IN ('10000', '20000', '30000', '40000', '50000', '60000', '70000', '80000', '90000', '100000', '110000', '120000')
 AND  BINARY  fcst_var = 'WRF_precip'
  AND fcst_flag = 0
  AND simple_flag = 1
  AND matched_flag = 0  AND mode_obj_single.mode_header_id = mode_header.mode_header_id
  AND mode_cts.mode_header_id = mode_obj_single.mode_header_id
  AND mode_cts.field = 'OBJECT'

