[Plugin: WP Most Popular] View Count

+1 (unless it’s resource intensive)

6 Months ago, probably not needed anymore but here goes anyway:

function get_post_views($postID, $period = 'all_time'){
    global $wpdb;

    $sql = "
        SELECT
            *
        FROM
            {$wpdb->prefix}most_popular mp
        WHERE
            post_id = {$postID}
    ";

    $result = $wpdb->get_row($sql, 'ARRAY_A');

    if (is_array($result))
    {
        switch ($period)
        {
            case 'all_time':
                return $result['all_time_stats'];
                break;
            case '1_day':
                return $result['1_day_stats'];
                break;
            case '7_day':
                return $result['7_day_stats'];
                break;
            case '30_day':
                return $result['30_day_stats'];
                break;
            default:
                return $result['all_time_stats'];
                break;
        }
    }
    else {
        return 0;
    }
}