본문바로가기

Error Code :1242
Error Msg : Subquery returns more than 1 row
Error Query : select case (SELECT MAX(right(level,3)) FROM KRITRTool.T_ResumeSchool WHERE muno=a.uno) when 100 then \'고등학교 졸업\' when 200 then \'전문대(전문학사) 졸업\' when 300 then \'대학(학사) 졸업\' when 400 then \'대학원(석사) 졸업\' when 500 then \'대학원(박사) 졸업\' else \'학력정보없음\' end as last_academic, (SELECT round(avg(quest1)) FROM KRITRTool.T_ProjectFeedBack where to_muno=a.uno and answer_date!=\'\' group by to_name) as skill, (SELECT round(avg(quest3)) FROM KRITRTool.T_ProjectFeedBack where to_muno=a.uno and answer_date!=\'\' group by to_name) as sincerity, (SELECT round(avg(quest2)) FROM KRITRTool.T_ProjectFeedBack where to_muno=a.uno and answer_date!=\'\' group by to_name) as teamwork, (SELECT if(Floor(sum(datediff(inenddate,instartdate))/30)>=3 and Floor(sum(datediff(inenddate,instartdate))/30)<=6,\'Orange\', if(Floor(sum(datediff(inenddate,instartdate))/30)>=7 and Floor(sum(datediff(inenddate,instartdate))/30)<=12,\'Silver\', if(Floor(sum(datediff(inenddate,instartdate))/30)>=13 and Floor(sum(datediff(inenddate,instartdate))/30)<=24,\'Gold\', if(Floor(sum(datediff(inenddate,instartdate))/30)>=25 and Floor(sum(datediff(inenddate,instartdate))/30)<=60,\'Diamond\', if(Floor(sum(datediff(inenddate,instartdate))/30)>=61 and Floor(sum(datediff(inenddate,instartdate))/30)<=120,\'Platinum\', if(Floor(sum(datediff(inenddate,instartdate))/30)>=121,\'Master\',\'Basic\')))))) as P_level FROM T_ProjectSelected AS PS INNER JOIN T_Project AS PL ON PS.puno=PL.seq WHERE ( PL.code=\'재택\' OR PL.code=\'상주\' ) AND PS.totalprojectmoney>0 AND PS.muno=a.uno GROUP BY PS.muno ) as P_levelkey, a.korname,(date_format(curdate( ),\'%Y\')-if(left(a.jumin,2)>=50 and left(a.jumin,2)<=99,CONCAT(\'19\',left(a.jumin,2)), if(left(a.jumin,2)>=0 and left(a.jumin,2)<50,CONCAT(\'20\'+left(a.jumin,2)),null) ))+1 as age, a.uno,a.class as db_level,ABS(DATEDIFF(NOW(),a.jobdate)) as jobdd,a.id,a.jumin,a.career,a.workplace,a.hopejobtype,a.txt_keyword,a.jobdate,a.lastdate,a.mdate, (select ABS(DATEDIFF(NOW(),mdate)) from KRITRTool.T_ResumeProject c where c.muno=a.uno order by mdate desc limit 1) as Project_md, ABS(DATEDIFF(NOW(),b.mdate)) as resume_md, ABS(DATEDIFF(NOW(),a.lastdate)) as lastdd, ABS(DATEDIFF(NOW(),a.mdate)) as mdd from KRITRTool.T_Member a, KRITRTool.T_MemberPersonal b WHERE ( a.uno=b.muno and a.uno=\'1147680\' and a.type=\'이랜서\' and a.jobchk=\'Y\' and a.code!=\'탈퇴\' and a.code!=\'직원\' and a.format=\'개인\' and a.workplace!=\'\' and b.introduction!=\'\' and a.class!=\'\' and a.txt_keyword!=\'\' and a.level1!=\'BL\')