SELECT 
				*, (SELECT COUNT(1) FROM ch_board_data WHERE 1=1 AND board_idx = 115785) AS totalcount
				, (SELECT COUNT(1) FROM ch_comment WHERE board_data_idx = bd.idx) AS comment_count
				, (SELECT COUNT(1) FROM ch_board_file WHERE board_data_idx = bd.idx AND filetype = 'file') AS file_count
				, (SELECT filename FROM ch_board_file WHERE board_data_idx = bd.idx AND filetype = 'image' ORDER BY filename LIMIT 1) AS image
				, (SELECT name FROM ch_board_category WHERE idx = bd.category_idx) AS category_name
				, (SELECT code FROM ch_board WHERE idx = bd.board_idx) AS code
			FROM ch_board_data bd
			WHERE 1=1 AND board_idx = 115785
			ORDER BY idx DESC
			 LIMIT 0, 1