SELECT *, date_format(NEWS_REGDATE, '%Y-%m-%d') AS REGDATE_, LEFT( fnStripTags(CONTENTS_),100) AS CONTENTS_, (
CASE
WHEN IFNULL(IMG_URL ,'') = '' THEN
CASE
WHEN C_CATE = 'c_tra' THEN 'http://taxtok.kr/resources/images/qna_tra.jpg'
WHEN C_CATE = 'c_inh' THEN 'http://taxtok.kr/resources/images/qna_inh.jpg'
WHEN C_CATE = 'c_gtx' THEN 'http://taxtok.kr/resources/images/qna_give.jpg'
WHEN C_CATE = 'c_hos' THEN 'http://taxtok.kr/resources/images/qna_hos.jpg'
ELSE 'http://taxtok.kr/resources/images/default.png'
END
ELSE IMG_URL
END
) AS IMG_URL_
FROM dbsschina.SS_NEWS WHERE VISIBLE='Y' AND SITE_GUBUN <> 'HOS' AND CATE = 'OPE' ORDER BY NEWS_REGDATE DESC LIMIT 0, 12 ;
