SELECT A.idx,A.m_idkey, A.c1_idkey, A.n_upload_file , A.cate1, A.cate2, A.cate3, B.idkey FROM ( SELECT idx, m_idkey, c1_idkey, n_upload_file, use_yn, cate1, cate2, cate3 FROM TB_LANDING_UPLOAD_INFO WHERE use_yn = 'Y' AND f_gubun = '0' ) as A LEFT OUTER JOIN TB_AD_MEDIA B ON A.m_idkey = B.m_idkey AND A.c1_idkey = B.c1_idkey WHERE a.use_yn = 'Y' AND b.use_yn = 'Y' AND b.code_nm = '자체 랜딩' AND a.cate1 = 'CATE11' AND a.cate2 = '' AND a.cate3 = '' ORDER BY NEWID()
전체
건강
다이어트
화장품
주식
교육
렌트/리스
병의원
번역
부동산
IT
법률
