LIVE! 채용정보

서비스 바로가기

지원형태별 채용공고더보기

select *, count(if(a1.new_gb='1',1,NULL)) as cnt1 , count(if(a1.intern_gb='1',1,NULL)) as cnt2 , count(if(a1.record_gb='1',1,NULL)) as cnt3, date_format(career_start_dt,'%Y%m') ddd from ((select no, title, new_gb, intern_gb, record_gb, career_start_dt, career_end_dt, date_input, aptitude_start_dt, aptitude_end_dt, nCom_scd, (select company_nm from category_company_t where company_no = nCom_scd) as com_nm, (select cate_big_no from category_group_relation_t where company_no = nCom_scd) as group_no, (select cate_big_nm from category_group_big_t where cate_big_no = group_no) as group_nm, 'main' as gubun from recruit_company_main_t where flag_view = 'Y' and (left(career_start_dt,7) = '2024-3' or left(career_start_dt,7) = '2023-03' or left(career_start_dt,7) = '2022-03')) union (select no, title, new_gb, intern_gb, record_gb, career_start_dt, career_end_dt, date_input, aptitude_start_dt, aptitude_end_dt, nCom_scd, (select company_nm from category_company_t where company_no = nCom_scd) as com_nm, (select cate_big_no from category_group_relation_t where company_no = nCom_scd) as group_no, (select cate_big_nm from category_group_big_t where cate_big_no = group_no) as group_nm, 'past' as gubun from recruit_company_past_t where flag_view = 'Y' and (left(career_start_dt,7) = '2024-3' or left(career_start_dt,7) = '2023-03' or left(career_start_dt,7) = '2022-03'))) as a1 where a1.group_no != '6' and a1.group_no != '47' group by date_format(career_start_dt,'%Y-%m')
Subquery returns more than 1 row