SELECT P1.*, P2.* from dots_promotion_master P1 left join dots_promotion_detail P2 on (P1.prom_id = P2.prom_id) where P1.prom_content_type = '25' AND P2.prom_lang = 'KR' AND P2.prom_publishing_status = 'Y' ORDER BY P1.prom_mdate DESC limit 0, 6
>
채용정보
채용공고