오라클에서 mysql로 변환중입니다...
select
days.mdate ,
ifnull(login_cnt,0) as login_cnt ,
ifnull(logout_cnt,0) as logout_cnt
from ( select '2016-06-16' as mdate from ts_user where limit 1,1 ) days
left join ( select substr(vl_date,0,10) as mdate ,
sum(case when vl_login_yn = 'Y' then 1 else 0 end) login_cnt ,
sum(case when vl_login_yn != 'Y' then 1 else 0 end) logout_cnt
from
ts_visit_log
where substr(vl_date,0,10)
between ? and ?
group by substr(vl_date,0,10) ) log
on log.mdate = days.mdate
order by days.mdate asc
대체 이게 무슨말인가요?