RoomInfoServices.php#169rvsystem970μsselectcount(*) CNT,
RIR.CHCK_IN_DATE
from `ROOM_INFO` innerjoin `RESV_INFO_ROOM` as `RIR` on `RIR`.`ROOM_CODE` = `ROOM_INFO`.`ROOM_CODE` innerjoin `RESV_INFO` as `RI` on `RI`.`RESV_NO` = `RIR`.`RESV_NO` where (`ROOM_INFO`.`USE_YN` ='N'and `RI`.`USER_ID` ='hansanmarina'and `RIR`.`USER_ID` ='hansanmarina'and `ROOM_INFO`.`USER_ID` ='hansanmarina') and DATE_FORMAT(RIR.CHCK_IN_DATE,'%Y%m') >='202502'and `RI`.`RESV_STAT` in ('00', '01', '09') and `RIR`.`ROOM_CODE` in ('R024') groupby `RIR`.`CHCK_IN_DATE`
RoomInfoServices.php#188rvsystem850μsselectcount(*) CNT,
RDD.DSBL_DATE
from `ROOM_INFO` innerjoin `ROOM_DSBL_DATE` as `RDD` on `RDD`.`ROOM_CODE` = `ROOM_INFO`.`ROOM_CODE` where (`ROOM_INFO`.`USE_YN` ='N'and `RDD`.`USER_ID` ='hansanmarina'and `ROOM_INFO`.`USER_ID` ='hansanmarina') and DATE_FORMAT(RDD.DSBL_DATE,'%Y%m') >='202502'and `RDD`.`ROOM_CODE` in ('R024') groupby `RDD`.`DSBL_DATE`