웹에이전시
Introduce the best projects with valuable customers
-
질경이 Jilgyungyi
하우동천한국어,
쇼핑몰,
-
간판닷컴 쇼핑몰
간판닷컴한국어,
쇼핑몰,
var_strTables = TB_BOARD A WITH(NOLOCK)
var_strFields = A.BOARD_SEQ, A.DIVISION, A.SUBJECT, A.CONTENT , A.HIT, A.NOTICE_YN, A.VIEW_YN, A.USER_NAME, A.PASSWORD , A.DELEGATE_IMG_PATH, A.DELEGATE_IMG_FILE, A.DELEGATE_IMG_SAVE, A.DELEGATE_IMG_ALT , A.EXPLAIN_IMG_PATH, A.EXPLAIN_IMG_FILE, A.EXPLAIN_IMG_SAVE, A.EXPLAIN_IMG_ALT , A.REGISTER_IP, A.DEL_YN, A.LANGUAGE_TYPE, A.REG_DATE , A.ETC_1, A.ETC_2, A.ETC_3, A.ETC_4, A.ETC_5 , A.ETC_6, A.ETC_7, A.ETC_8, A.ETC_9, A.ETC_10 , A.ORDER_PORT, A.ORDER_PORTALL, A.ORDER_BUSINESS, A.ORDER_MAIN , A.CATEGORY_SEQ, A.STORY_BOARD_SEQ , ( SELECT SUBJECT FROM TB_CATEGORY B WHERE A.CATEGORY_SEQ = B.CATEGORY_SEQ) AS CATEGORY_SUBJECT , ( SELECT COUNT(FILE_SEQ) FROM TB_BOARD_FILE B WHERE A.BOARD_SEQ = B.BOARD_SEQ) AS FILE_COUNT , ( SELECT PARENT_CATEGORY_SEQ FROM TB_CATEGORY B WHERE B.CATEGORY_SEQ = A.CATEGORY_SEQ) AS PARENT_CATEGORY_SEQ , dbo.fnGetCateNavi('BUSINESS', 'KOR', A.CATEGORY_SEQ, ' > ') AS CATENAVI
var_strFilter = A.DEL_YN= 'N' AND A.NOTICE_YN= 'N' AND A.DIVISION = 'PORTFOLIO' AND (0 < A.ETC_1 & 16) AND A.LANGUAGE_TYPE = 'KOR' AND A.CATEGORY_SEQ IN ( 1, 2, 11, 12, 16, 158) AND A.VIEW_YN = 'Y'
var_strSort = A.ORDER_PORT ASC, A.BOARD_SEQ DESC
