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, '&amp;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'
			