SELECT
  model,
  NOW()  fcst_init,
  fcst_valid,
  fcst_lead,
  fcst_thr,
'REFC' fcst_var,
  'INT90_FSA' stat_name,
  intensity_90 stat_value
FROM
  mode_header ,
  mode_obj_single ,
  mode_cts 
WHERE
    BINARY fcst_thr IN ('>=20')
  AND   BINARY model IN ('GSL_05_MPAS', 'HRRR', 'NSSL_MPAS_HN', 'NSSL_MPAS_HT', 'NSSL_MPAS_RT', 'RRFS')
  AND   BINARY fcst_lead IN ('0', '10000', '20000', '30000', '40000', '50000', '60000', '70000', '80000', '90000', '100000', '110000', '120000', '130000', '140000', '150000', '160000', '170000', '180000', '190000', '200000', '210000', '220000', '230000', '240000', '250000', '260000', '270000', '280000', '290000', '300000', '310000', '320000', '330000', '340000', '350000', '360000')
 AND  BINARY  fcst_var = 'REFC'
  AND fcst_flag = 1
  AND simple_flag = 1  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'

