SELECT
  model,
  fcst_init,
  fcst_valid,
  fcst_lead,
  fcst_lev,
  fcst_thr,
'APCP_000001' fcst_var,
  object_id,
  object_cat,
  area,
  fcst_flag,
  simple_flag,
  matched_flag,
 '2d' object_type
FROM mtd_header, mtd_2d_obj
WHERE
    BINARY fcst_lev IN ('R1')
  AND   BINARY fcst_thr IN ('>=2.0')
  AND   BINARY model IN ('HRRRE')
  AND   BINARY fcst_lead IN ('0', '30000', '60000', '90000', '120000')
 AND  BINARY  fcst_var = 'APCP_000001'  AND mtd_header.mtd_header_id = mtd_2d_obj.mtd_header_id

