File name
Commit message
Commit date
SELECT b.BBS_NM
,a.BBS_ID
,a.NTT_ID AS ID
,a.NTT_ID
,a.NTT_SJ
,a.NTT_CN
,a.FRST_REGIST_PNTTM
,DATE_FORMAT(a.FRST_REGIST_PNTTM, '%Y-%m-%d') AS REGIST_DT
,CONCAT('/web/cop/bbs/selectBoardArticle.do?bbsId=', a.BBS_ID, '&nttId=', a.NTT_ID) AS URL
,c.MENU_NM
,get1DepthMenu(c.MENU_NO) AS CATEGORY
,getMenuCours(c.MENU_NO) AS MENU_COURS
FROM LETTNBBS a
INNER JOIN LETTNBBSMASTER b ON a.BBS_ID = b.BBS_ID
inner JOIN (
SELECT A.PROGRM_BBS_ID, B.MENU_NO, B.MENU_NM, B.MENU_USER_TYPE
FROM LETTNPROGRMLIST A
INNER JOIN LETTNMENUINFO B
ON A.PROGRM_FILE_NM = B.PROGRM_FILE_NM
) C ON a.BBS_ID = c.PROGRM_BBS_ID
WHERE a.USE_AT = 'Y'