SELECT
  model,
  fcst_init,
  fcst_valid,
  fcst_lead,
  HOUR(fcst_valid) valid_hour,
'WRF_precip' 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 ('AI_run1')
  AND HOUR(fcst_valid) IN ('02', '04', '08', '11')
 AND  BINARY  fcst_var = 'WRF_precip'  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'

