A Database Error Occurred

Error Number: -493

Syntax: before ' ORDER BY cal.ymd' Unknown class "fu_crossword_score". select to_char(cal.ymd, 'YYYYMMDD'), nvl(ppcnt, 0), nvl(mvc...[CAS INFO-10.1.123.33:33000,2,18406].

SELECT TO_CHAR (cal.ymd, 'YYYYMMDD') reg, NVL (ppcnt, 0) ppcnt, NVL (mvcnt, 0) mvcnt, NVL (mvautocnt, 0) mvautocnt, NVL (socnt, 0) socnt, NVL (soautocnt, 0) soautocnt, NVL (qzcnt, 0) qzcnt FROM ( SELECT to_char(to_date('20171110', 'yyyymmdd') + rownum -1, 'yyyymmdd') ymd FROM db_attribute WHERE ROWNUM <= (to_date('20171117', 'yyyymmdd') - to_date('20171110', 'yyyymmdd'))) cal, ( SELECT TRUNC (st_date) ymd, SUM (page_cnt) ppcnt, SUM (movie_cnt) mvcnt, SUM (movie_auto_cnt) mvautocnt, SUM (song_cnt) socnt, SUM (song_auto_cnt) soautocnt, SUM (qz_cnt) qzcnt --FROM ( ( SELECT MAX (TRUNC (log_date, 'HH24')) st_date, FROM ( ( SELECT TRUNC (log_date, 'HH24') st_date, SUM (DECODE (log_type, 'P', 1, 0)) page_cnt, SUM (DECODE (log_type, 'M', 1, 0)) movie_cnt, SUM (DECODE (log_type, 'A', 1, 0)) movie_auto_cnt, SUM (DECODE (log_type, 'S', 1, 0)) song_cnt, SUM (DECODE (log_type, 'B', 1, 0)) song_auto_cnt, 0 qz_cnt, 0 cw_cnt FROM stat_study_log ssl, fox_contents c WHERE ssl.fc_id = c.fc_id AND fu_id = 'U201704062044380407' AND log_date > (SELECT TO_DATETIME (fi_value,'YYYY-MM-DD HH24:MI:SS') FROM fox_info WHERE fi_name = 'stat_study_hourly_acc_lastdate' ) AND log_date BETWEEN TO_DATE ('20171110', 'YYYYMMDD') AND TO_DATETIME('20171117235959','YYYYMMDDHH24MISS') GROUP BY ssl.fu_id, st_date UNION SELECT DATE_FORMAT (qr_str_date, '%Y-%m-%d') st_date, 0 page_cnt, 0 movie_cnt, 0 movie_auto_cnt, 0 song_cnt, 0 song_auto_cnt, COUNT ( * ) qz_cnt, 0 cw_cnt FROM fu_quiz_result WHERE fu_id = 'U201704062044380407' AND qr_str_date > (SELECT TO_CHAR (TO_DATETIME (fi_value,'YYYY-MM-DD HH24:MI:SS'),'YYYYMMDDHH24MISS')|| 00 FROM fox_info WHERE fi_name = 'stat_study_hourly_acc_lastdate') AND qr_str_date BETWEEN TO_DATE ('20171110', 'YYYYMMDD') AND TO_DATETIME('20171117235959','YYYYMMDDHH24MISS') GROUP BY st_date UNION SELECT MAX (TRUNC (play_date, 'HH24')) st_date, 0 page_cnt, 0 movie_cnt, 0 movie_auto_cnt, 0 song_cnt, 0 song_auto_cnt, 0 qz_cnt, COUNT ( * ) cw_cnt FROM fu_crossword_score WHERE fu_id = 'U201704062044380407' AND play_date > (SELECT TO_DATETIME (fi_value, 'YYYY-MM-DD HH24:MI:SS') FROM fox_info WHERE fi_name = 'stat_study_hourly_acc_lastdate') GROUP BY fu_id) UNION SELECT st_date, SUM(page_cnt) AS page_cnt, SUM(movie_cnt) AS movie_cnt, SUM(movie_auto_cnt) AS movie_auto_cnt, SUM(song_cnt) AS song_cnt, SUM(song_auto_cnt) AS song_auto_cnt, SUM(qz_cnt) AS qz_cnt, SUM(cw_cnt) AS cw_cnt FROM stat_study_hourly WHERE fu_id = 'U201704062044380407' AND st_date BETWEEN TO_DATE ('20171110', 'YYYYMMDD') AND TO_DATETIME('20171117235959','YYYYMMDDHH24MISS') GROUP BY st_date ) GROUP BY TRUNC (st_date) ) st WHERE cal.ymd = st.ymd(+) ORDER BY cal.ymd

Filename: models/Studylog_model.php

Line Number: 697