SELECT brd.board_seq
, mem.mb_id
, BRD.content
, BRD.title
, UNIX_TIMESTAMP(brd.reg_dt) reg_dt
, BRD.hit_count
, mem.hw_upso_location1
, ( select code_name from sm_comm_code cd where cd.code_seq = BRD.LOCATION1 ) hw_upso_location1_nm
, mem.hw_upso_location2
, ( select code_name from sm_comm_code cd where cd.code_seq = BRD.LOCATION2 ) hw_upso_location2_nm
, mem.jump_dt
, mem.mb_nick
, mem.mb_name
FROM G5_MEMBER MEM INNER JOIN SM_BOARD BRD ON BRD.MB_NO = MEM.MB_NO
WHERE (BRD.CONTENT LIKE CONCAT('%', '여성환영','%') OR MEM.HW_THEME LIKE CONCAT('%','','%') )
LIMIT 0, 30
검색된 자료가 하나도 없습니다.