SELECT a.test_regist_idx
     , a.test_name
     , a.receipt_start_date
     , a.receipt_end_date
     , c.test_place_idx
     , c.test_place_num
     , c.test_place_name
     , b.personnel
     , COUNT(d.payment_idx) cnt
     , CASE WHEN receipt_start_date > NOW() THEN 'W'
            WHEN receipt_end_date   < NOW() THEN 'E'
            WHEN b.personnel <= COUNT(d.payment_idx) THEN 'E'
            ELSE 'I'
        END now_status
  FROM id_test_regist a
 INNER JOIN id_test_area_info b
    ON a.test_regist_idx = b.test_regist_idx
 INNER JOIN id_test_place  c
    ON b.test_place_idx  = c.test_place_idx
  LEFT OUTER JOIN id_payment d
    ON b.test_regist_idx = d.test_regist_idx
   AND b.test_place_idx  = d.test_place_idx
 GROUP BY a.test_regist_idx
     , a.test_name
     , a.receipt_start_date
     , a.receipt_end_date
     , c.test_place_idx
     , c.test_place_num
     , c.test_place_name
     , b.personnel
;