-- 최신순은 쉽네...
select * from g5_write_notice where wr_is_comment = 0 order by wr_datetime desc, wr_num desc;
-- 인기순... 아뇌... 추천순으로 할걸... 괜히 복잡해짐...
-- 추천(wr_good)은 10점, 비추(wr_nogood)은 -10점, 스크랩(wr_scrap)은 5점, 댓글(wr_comment)은 3점, 조회수(wr_hit)는 1점
-- 날짜 개념이 들어가야 할 것 같은데... 오래 된건 차감이 되어야 한다...
-- 지난 날짜 수당 -10점. 추천만큼 차감하면 되지 않을까...
select
    wr_id, wr_subject, wr_good, wr_nogood, wr_comment,
    (select count(ms_id) FROM g5_scrap AS s WHERE s.bo_table = 'notice' AND s.wr_id = b.wr_id) AS scrap_cnt
from g5_write_notice AS b where wr_is_comment = 0;
-- 아래 쿼리가 인기순 쿼리로 사용될 것.
SELECT
    ms.*,
    (ms.wr_good*10 + ms.wr_nogood*(-10) + ms.past_day*(-10) + ms.wr_comment*3 + wr_hit) AS hot_score
FROM (
    select
        b.*, TIMESTAMPDIFF(DAY, wr_datetime, curdate()) AS past_day,
        (select count(ms_id) FROM g5_scrap AS s WHERE s.bo_table = 'notice' AND s.wr_id = b.wr_id) AS scrap_cnt
from g5_write_notice AS b
where wr_is_comment = 0
) AS ms
ORDER BY hot_score DESC;

// 테이블명, 게새글/댓글 구분, 정렬구분 등을 전달 받아 게시글의 리스트를 돌려줌.
// latest() 함수를 참고하여 만들었고, 스킨과 캐싱부분만 제외시켰음. by tank. at 200704.
function get_board_list( $bo_table, $br_gubun, $ord_gubun, $rows=5, $subject_len=40 ) {
    global $g5;
    $list = array();
    $tmp_write_table = $g5['write_prefix'] . $bo_table; // 게시판 테이블 전체이름
    if ( $ord_gubun == "NEW" ) {
        $sql = "SELECT * FROM {$tmp_write_table} WHERE wr_is_comment = {$br_gubun} AND wr_option != 'secret' ORDER BY wr_datetime desc, wr_num desc LIMIT 0, {$rows}";
    } else if ( $ord_gubun == "HOT" ) {
        $sql = "SELECT
                    ms.*, (ms.wr_good*10 + ms.wr_nogood*(-10) + ms.past_day*(-10) + ms.wr_comment*3 + wr_hit) AS hot_score
                FROM (
                    select
                        b.*, TIMESTAMPDIFF(DAY, wr_datetime, curdate()) AS past_day,
                        (select count(ms_id) FROM g5_scrap AS s WHERE s.bo_table = 'notice' AND s.wr_id = b.wr_id) AS scrap_cnt
                from {$tmp_write_table} AS b
                where wr_is_comment = {$br_gubun} AND wr_option != 'secret'
                ) AS ms
                ORDER BY hot_score DESC
                LIMIT 0, {$rows}";
    }
    $result = sql_query($sql);                                  //tLog($sql, $result);
    for ($i=0; $row = sql_fetch_array($result); $i++) {         //tLog("row", $row);
        try {
            unset($row['wr_password']);     //패스워드 저장 안함( 아예 삭제 )
        } catch (Exception $e) {
        }
        $row['wr_email'] = '';              //이메일 저장 안함
        if (strstr($row['wr_option'], 'secret')){           // 비밀글일 경우 내용, 링크, 파일 저장 안함
            $row['wr_content'] = $row['wr_link1'] = $row['wr_link2'] = '';
            $row['file'] = array('count'=>0);
        }
        $list[$i] = $row;
        $list[$i]['bo_table'] = $bo_table;
    }
    return $list;
}

<?php
if (!defined('_GNUBOARD_')) exit; // 개별 페이지 접근 불가
$new_list = get_board_list($bo_table, 0, "NEW");       //tLog("new_list", $new_list); //새글 리스트
$hot_list = get_board_list($bo_table, 0, "HOT");       //tLog("hot_list", $hot_list); //인기글 리스트
$new_rep_list = get_board_list($bo_table, 1, "NEW");   //tLog("new_rep_list", $new_rep_list); //새 댓글 리스트
$hot_rep_list = get_board_list($bo_table, 1, "HOT");   //tLog("hot_rep_list", $hot_rep_list); //인기 댓글 리스트
include_once($board_skin_path.'/view_side.skin.php');
?>