SELECT
  model,
  fcst_init,
  fcst_valid,
  fcst_lead,
'REFC' fcst_var,
  object_id,
  object_cat,
  area,
  total,
  fcst_flag,
  simple_flag,
  matched_flag
FROM
  mode_header ,
  mode_obj_single ,
  mode_cts 
WHERE
    BINARY model IN ('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', '370000', '380000', '390000', '400000', '410000', '420000')
 AND  BINARY  fcst_var = 'REFC'  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'

