SELECT Top 10 ROW_NUMBER() OVER( ORDER BY b.reg_date asc )as rown ,a.mem_num , replace(a.mem_name,char(10),'') , a.mem_id , b.log_num , c.lec_subject , cntListened = 0 , cntSubChapter = 0 , b.reg_date , c.lec_period , a.last_login_date , lastStudyDate = (SELECT MAX(lis_date) FROM L007 WHERE mem_id = a.mem_id AND lec_num = b.lec_num AND log_num=b.log_num) , c.per_progress , c.per_work , c.per_test , b.start_date , b.end_date , mem_hp1 , mem_hp2 , mem_hp3 , a.mem_email , (a.mem_hp1+''+a.mem_hp2+''+a.mem_hp3) as tel_hp , cntDate = '' , chkIssue1 = 0 , chkIssue2 = 0 , b.total_score , b.test_score , b.work_score , b.lis_rate , b.lis_score , b.completion , isnull(a.mem_work1,'개인') as company , is_open , a.mem_work2 , b.test_rate , b.test2_score , b.test2_rate , b.work_rate , b.discuss_score , b.discuss_rate , b.note_rate , b.note_score , a.mem_jumin1 , a.mem_jumin2 , isNull(b.eachPoint, 0) , isNull(b.eachPoint_score, 0) , b.total_scoring , isNull(b.avg_total, '') , isNull(b.avg_grade, '') , cntEach = (select count(*) from l014_pt where is_del='no' and log_num = b.log_num) , gyosunm = (select top 1 name +'('+id+')' from M007 where lec_num=b.lec_num AND class=b.class) , b.class , (SELECT lis_rate FROM L065 WHERE log_num = b.log_num), (SELECT test_score FROM L065 WHERE log_num = b.log_num), (SELECT test2_score FROM L065 WHERE log_num = b.log_num), (SELECT work_score FROM L065 WHERE log_num = b.log_num), (SELECT note_score FROM L065 WHERE log_num = b.log_num), (SELECT discuss_score FROM L065 WHERE log_num = b.log_num), (SELECT eachpoint_score FROM L065 WHERE log_num = b.log_num), (SELECT total_score FROM L065 WHERE log_num = b.log_num), (SELECT avg_total FROM L065 WHERE log_num = b.log_num), (SELECT avg_grade FROM L065 WHERE log_num = b.log_num), (SELECT isNull(total_scoring, '') FROM L065 WHERE log_num = b.log_num), (SELECT pkg_num FROM L065 WHERE log_num = b.log_num) , (select crm_name from m005 where a.gm_num = crm_num) as crm_name , cntEach2 = (select count(*) from l014_pt2 where is_del='no' and log_num = b.log_num) , (select distinct crm_name from m005 where a.gm_num = crm_num and b.mem_id ='') as crm_name , (select count(lms_class) from l000 where lec_num = b.lec_num and b.mem_id ='') as lms_count FROM A013 a, L001 b, L000 c WHERE a.mem_id = b.mem_id AND b.lec_num = c.lec_num AND b.is_del = 'no' and b.is_open='on' ORDER BY rown desc SELECT Top 10 ROW_NUMBER() OVER( ORDER BY b.reg_date asc )as rown ,a.mem_num , replace(a.mem_name,char(10),'') , a.mem_id , b.log_num , c.lec_subject , cntListened = 0 , cntSubChapter = 0 , b.reg_date , c.lec_period , a.last_login_date , lastStudyDate = (SELECT MAX(lis_date) FROM L007 WHERE mem_id = a.mem_id AND lec_num = b.lec_num AND log_num=b.log_num) , c.per_progress , c.per_work , c.per_test , b.start_date , b.end_date , mem_hp1 , mem_hp2 , mem_hp3 , a.mem_email , (a.mem_hp1+''+a.mem_hp2+''+a.mem_hp3) as tel_hp , cntDate = '' , chkIssue1 = 0 , chkIssue2 = 0 , b.total_score , b.test_score , b.work_score , b.lis_rate , b.lis_score , b.completion , isnull(a.mem_work1,'개인') as company , is_open , a.mem_work2 , b.test_rate , b.test2_score , b.test2_rate , b.work_rate , b.discuss_score , b.discuss_rate , b.note_rate , b.note_score , a.mem_jumin1 , a.mem_jumin2 , isNull(b.eachPoint, 0) , isNull(b.eachPoint_score, 0) , b.total_scoring , isNull(b.avg_total, '') , isNull(b.avg_grade, '') , cntEach = (select count(*) from l014_pt where is_del='no' and log_num = b.log_num) , gyosunm = (select top 1 name +'('+id+')' from M007 where lec_num=b.lec_num AND class=b.class) , b.class , (SELECT lis_rate FROM L065 WHERE log_num = b.log_num), (SELECT test_score FROM L065 WHERE log_num = b.log_num), (SELECT test2_score FROM L065 WHERE log_num = b.log_num), (SELECT work_score FROM L065 WHERE log_num = b.log_num), (SELECT note_score FROM L065 WHERE log_num = b.log_num), (SELECT discuss_score FROM L065 WHERE log_num = b.log_num), (SELECT eachpoint_score FROM L065 WHERE log_num = b.log_num), (SELECT total_score FROM L065 WHERE log_num = b.log_num), (SELECT avg_total FROM L065 WHERE log_num = b.log_num), (SELECT avg_grade FROM L065 WHERE log_num = b.log_num), (SELECT isNull(total_scoring, '') FROM L065 WHERE log_num = b.log_num), (SELECT pkg_num FROM L065 WHERE log_num = b.log_num) , (select crm_name from m005 where a.gm_num = crm_num) as crm_name , cntEach2 = (select count(*) from l014_pt2 where is_del='no' and log_num = b.log_num) , (select distinct crm_name from m005 where a.gm_num = crm_num and b.mem_id ='') as crm_name , (select count(lms_class) from l000 where lec_num = b.lec_num and b.mem_id ='') as lms_count FROM A013 a, L001 b, L000 c WHERE a.mem_id = b.mem_id AND b.lec_num = c.lec_num AND b.is_del = 'no' and b.is_open='on' ORDER BY rown desc