SELECT NUM, NID, MUSICS_NO , CASE when STATUS = '1' then 'DANCE' when STATUS = '2' then 'BALLAD' END STATUS, DATE_FORMAT(MUSIC_DT, '%Y-%m-%d') AS MUSIC_DT FROM MUSIC_LOG WHERE 1=1 AND NID LIKE CONCAT('0825G293SYJ18ANK18A000186') AND MUSICS_NO LIKE CONCAT ('1') AND MUSIC_DT BETWEEN '2021-05-06' AND '2021-05-06' AND DATE_FORMAT(MUSIC_DT , '%H:00') BETWEEN '09:00' AND '10:00'
AND DATE_FORMAT(MUSIC_DT , '%H:00') BETWEEN '09:00' AND '10:00'
보라색표시 해놓은 쿼리만 추가하면 실행은 되는데 아무것도 뜨지않습니다.
어떤부분이 문제인건가요?