SELECT
  model,
  fcst_init,
  fcst_valid,
  fcst_lead,
'APCP_01_ENS_NEP_ge2.54_NBRHD729' fcst_var,
  object_id,
 'NA' object_cat,
  'ANGLEDIFF_CM' stat_name,
  angle_diff stat_value
FROM
  mode_header,
  mode_obj_pair
WHERE
    BINARY model IN ('nostoch', 'stoch')
  AND   BINARY fcst_lead IN ('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 = 'APCP_01_ENS_NEP_ge2.54_NBRHD729'
  AND  simple_flag = 0
  AND  matched_flag = 1  AND mode_header.mode_header_id = mode_obj_pair.mode_header_id ;

