SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
'APCP_03' fcst_var,
  'ME' stat_name,
  IF(ld.me=-9999,'NA',ld.me ) stat_value,
  IF(ld.me_ncl=-9999,'NA',ld.me_ncl  ) stat_ncl,
  IF(ld.me_ncu=-9999,'NA',ld.me_ncu  ) stat_ncu,
  IF(ld.me_bcl=-9999,'NA',ld.me_bcl) stat_bcl,
  IF(ld.me_bcu=-9999,'NA',ld.me_bcu ) stat_bcu
FROM
  stat_header h,
  line_data_cnt ld
WHERE
    BINARY h.model IN ('HREF_mem01', 'HREF_mem02')
  AND   BINARY ld.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')
  AND   BINARY h.fcst_var = 'APCP_03'
  AND ld.stat_header_id = h.stat_header_id
  AND ld.me != -9999;

