SELECT
  fcst_lead,
  fcst_init,
  fcst_valid,
'APCP_000001' fcst_var,
  object_id,
  object_cat,
  '3D_CENTROID_LAT_AAA' stat_name,
  centroid_lat stat_value,
 '3d' object_type
FROM mtd_header, mtd_3d_obj_single 
WHERE
    BINARY fcst_lead IN ('0', '10000', '20000', '30000', '40000', '50000', '60000', '70000', '80000', '90000', '100000', '110000', '120000')
  AND   BINARY fcst_lead IN ('0', '30000', '90000', '120000')
 AND  BINARY  fcst_var = 'APCP_000001' AND mtd_header.mtd_header_id = mtd_3d_obj_single.mtd_header_id

