# 征文，第 202541 期 - 投票

**URL:** <https://idcflare.com/t/topic/31822>\
**Category:** 活动\
**Tags:** 公告\
**Created:** [2025 年10 月 16 日 03:24 UTC](https://idcflare.com/t/topic/31822 "2025-10-16T03:24:50Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![neo](https://idcflare.com/user_avatar/idcflare.com/neo/32/12_2.png) [@neo](https://idcflare.com/u/neo)\
**Post date:** [2025 年10 月 16 日 03:24 UTC](https://idcflare.com/t/topic/31822/1 "2025-10-16T03:24:50Z")

</div>

> [@征文，第 202541 期 - 结束](https://idcflare.com/t/topic/20901):
>
> 从[征文，第 202540 期 - 开启](https://idcflare.com/t/topic/15957)继续讨论： 感谢佬友们的支持，第一期社区征文完美落幕。先公布一下经过投票后的前三甲： 恭喜：@node @ICMPMeow @bamboo5320 获奖，请三位作者私信我选择是要礼品卡，还是折支付宝红包。 我们在此有个改动，4-10名将全部获得铜笔杆头衔，但无奖金。 现在，我们拉开第 202541 期征文活动。规则参考 202540 期，不过还…

根据上文的征文规则，今天应该是投票阶段了。本期超过10篇，我们按照文末的SQL来进行排名。 **一人一票** ，请为你最喜爱的帖子投票吧（投票列表按发表时间排序）：

 ![image](https://idcflare.com/uploads/default/original/3X/9/d/9dda1cf37da31a3d6336dc907e597e6dad405e24.png)

- [【面向小白教程】通过 saas 回源优选加速 Cloudflare 中国大陆访问](https://idcflare.com/t/topic/15650)
- [你的新一代简洁好用的 PVE 运维脚本 —— 目前已经支持 PVE7~9 版本](https://idcflare.com/t/topic/16307)
- [Docker 从安装到镜像制作以及部署私有化仓库全攻略](https://idcflare.com/t/topic/21471)
- [VPS到手，小白要做的N件事~](https://idcflare.com/t/topic/21493)
- [整个活，给大家表演个发明路由器](https://idcflare.com/t/topic/21706)
- [[猫猫教程]小白优雅的使用NAT机器 - 从入门到实战的完整指南](https://idcflare.com/t/topic/21816)
- [个性化 Komari 探针界面主题推荐](https://idcflare.com/t/topic/21991)
- [[新手教程]快速上手使用Linux（更新了）](https://idcflare.com/t/topic/22132)
- [免费服务器容器搭建Reality+hy2双协议节点](https://idcflare.com/t/topic/22988)
- [IP被墙了怎么办，如何避免，多久放出来](https://idcflare.com/t/topic/30033)

> [!warning]  
> 误投的佬友可以撤销后重新投票。

_Poll ([view on site](https://idcflare.com/t/topic/31822/1))_

* * *

附上统计SQL给佬友们 review（日期均已转换为+8）：

```sql
SELECT * FROM (
    WITH topic_stats AS (
      SELECT 
        t.id AS topic_id,
        t.title AS topic_title,
        t.user_id AS author_id,
        u.username AS author_username,
        t.created_at AT TIME ZONE 'UTC' AT TIME ZONE 'Asia/Shanghai' AS created_at_cst,
        
        -- 统计点赞数
        COALESCE((
          SELECT COUNT(DISTINCT pa.user_id)
          FROM post_actions pa
          JOIN posts p ON p.id = pa.post_id
          WHERE p.topic_id = t.id 
            AND p.post_number = 1 -- 主楼
            AND pa.post_action_type_id = 2 -- 点赞事件
            AND pa.deleted_at IS NULL
            AND pa.user_id != t.user_id -- 排除帖主
            AND pa.created_at AT TIME ZONE 'UTC' AT TIME ZONE 'Asia/Shanghai' < :end_date_cst
        ), 0) AS likes_count,
        
        -- 统计回帖数
        COALESCE((
          SELECT COUNT(*)
          FROM posts p
          WHERE p.topic_id = t.id 
            AND p.post_number > 1 -- 跟帖
            AND p.post_type = 1 -- 普通回帖
            AND p.user_id != t.user_id -- 排除帖主
            AND p.deleted_at IS NULL
            AND p.hidden = false
            AND p.created_at AT TIME ZONE 'UTC' AT TIME ZONE 'Asia/Shanghai' < :end_date_cst
        ), 0) AS reply_count
        
      FROM topics t
      JOIN users u ON u.id = t.user_id
      WHERE t.category_id = :category_id
        AND t.deleted_at IS NULL
        AND t.visible = true
        AND t.archetype = 'regular'
        AND t.created_at AT TIME ZONE 'UTC' AT TIME ZONE 'Asia/Shanghai' < :end_date_cst
    )
    SELECT 
      concat('https://idcflare.com/t/topic/', topic_id) as topic_link,
      topic_id as tid,
      topic_title,
      author_username,
      created_at_cst,
      likes_count,
      reply_count,
      (likes_count * 1 + reply_count * 2) AS total_score,
      ROW_NUMBER() OVER (ORDER BY (likes_count * 1 + reply_count * 2) DESC, topic_id DESC) AS ranking
    FROM topic_stats
    WHERE (likes_count * 1 + reply_count * 2) > 0
    ORDER BY total_score DESC, topic_id DESC
    LIMIT 10
) AS top10
ORDER BY created_at_cst ASC

```

---

<div class="post-metadata">

**Author:** ![neo](https://idcflare.com/user_avatar/idcflare.com/neo/32/12_2.png) [@neo](https://idcflare.com/u/neo)\
**Post date:** [2025 年10 月 16 日 03:25 UTC](https://idcflare.com/t/topic/31822/2 "2025-10-16T03:25:24Z")

</div>



---

<div class="post-metadata">

**Author:** ![lemon](https://idcflare.com/user_avatar/idcflare.com/lemon/32/7266_2.png) [@lemon](https://idcflare.com/u/lemon)\
**Post date:** [2025 年10 月 16 日 03:29 UTC](https://idcflare.com/t/topic/31822/3 "2025-10-16T03:29:48Z")

</div>

好久没见过这么复杂的SQL了 :tieba_091:

---

<div class="post-metadata">

**Author:** ![Luis](https://idcflare.com/user_avatar/idcflare.com/luis/32/247_2.png) [@Luis](https://idcflare.com/u/Luis)\
**Post date:** [2025 年10 月 16 日 03:30 UTC](https://idcflare.com/t/topic/31822/4 "2025-10-16T03:30:38Z")

</div>

好难投啊，都想投怎么办~ 🤣

---

<div class="post-metadata">

**Author:** ![linuxdo](https://idcflare.com/user_avatar/idcflare.com/linuxdo/32/12085_2.png) [@linuxdo](https://idcflare.com/u/linuxdo)\
**Post date:** [2025 年10 月 16 日 03:37 UTC](https://idcflare.com/t/topic/31822/5 "2025-10-16T03:37:21Z")

</div>

来啦来啦

---

<div class="post-metadata">

**Author:** ![kkx](https://idcflare.com/user_avatar/idcflare.com/kkx/32/22838_2.png) [@kkx](https://idcflare.com/u/kkx)\
**Post date:** [2025 年10 月 16 日 03:37 UTC](https://idcflare.com/t/topic/31822/6 "2025-10-16T03:37:47Z")

</div>

投票开始了，激动人心的时刻 😅 🫣

---

<div class="post-metadata">

**Author:** ![bluthondyoub](https://idcflare.com/user_avatar/idcflare.com/bluthondyoub/32/225_2.png) [@bluthondyoub](https://idcflare.com/u/bluthondyoub)\
**Post date:** [2025 年10 月 16 日 03:39 UTC](https://idcflare.com/t/topic/31822/7 "2025-10-16T03:39:44Z")

</div>

先看文章再说

* * *

佬友文章质量依旧能打，排版质量高，

---

<div class="post-metadata">

**Author:** ![0xbba](https://idcflare.com/user_avatar/idcflare.com/0xbba/32/8040_2.png) [@0xbba](https://idcflare.com/u/0xbba)\
**Post date:** [2025 年10 月 16 日 03:40 UTC](https://idcflare.com/t/topic/31822/8 "2025-10-16T03:40:30Z")

</div>

感觉越靠前的选项票数都更高，上次L站也是。这么多文章没时间看完，要么乱投，要么看标题就投了

---

<div class="post-metadata">

**Author:** ![Lindo](https://idcflare.com/user_avatar/idcflare.com/lindo/32/1427_2.png) [@Lindo](https://idcflare.com/u/Lindo)\
**Post date:** [2025 年10 月 16 日 03:40 UTC](https://idcflare.com/t/topic/31822/9 "2025-10-16T03:40:36Z")

</div>

开始投票

---

<div class="post-metadata">

**Author:** ![fgozxy](https://idcflare.com/user_avatar/idcflare.com/fgozxy/32/12201_2.png) [@fgozxy](https://idcflare.com/u/fgozxy)\
**Post date:** [2025 年10 月 16 日 03:41 UTC](https://idcflare.com/t/topic/31822/10 "2025-10-16T03:41:47Z")

</div>

后排支持

---

<div class="post-metadata">

**Author:** ![bai](https://idcflare.com/user_avatar/idcflare.com/bai/32/605_2.png) [@bai](https://idcflare.com/u/bai)\
**Post date:** [2025 年10 月 16 日 03:42 UTC](https://idcflare.com/t/topic/31822/11 "2025-10-16T03:42:15Z")

</div>

已经狠狠地投票啦

---

<div class="post-metadata">

**Author:** ![TapTap](https://idcflare.com/user_avatar/idcflare.com/taptap/32/1510_2.png) [@TapTap](https://idcflare.com/u/TapTap)\
**Post date:** [2025 年10 月 16 日 03:45 UTC](https://idcflare.com/t/topic/31822/12 "2025-10-16T03:45:26Z")

</div>

让我们搞点 linux 吧。

---

<div class="post-metadata">

**Author:** ![neo](https://idcflare.com/user_avatar/idcflare.com/neo/32/12_2.png) [@neo](https://idcflare.com/u/neo)\
**Post date:** [2025 年10 月 16 日 03:46 UTC](https://idcflare.com/t/topic/31822/13 "2025-10-16T03:46:55Z")

</div>

不会啊，这次明显不是靠前的高。

---

<div class="post-metadata">

**Author:** ![llllllll](https://idcflare.com/user_avatar/idcflare.com/llllllll/32/362_2.png) [@llllllll](https://idcflare.com/u/llllllll)\
**Post date:** [2025 年10 月 16 日 03:48 UTC](https://idcflare.com/t/topic/31822/14 "2025-10-16T03:48:29Z")

</div>

都是好文！

---

<div class="post-metadata">

**Author:** ![0xbba](https://idcflare.com/user_avatar/idcflare.com/0xbba/32/8040_2.png) [@0xbba](https://idcflare.com/u/0xbba)\
**Post date:** [2025 年10 月 16 日 03:57 UTC](https://idcflare.com/t/topic/31822/15 "2025-10-16T03:57:50Z")

</div>

好吧 看错了 🫠

---

<div class="post-metadata">

**Author:** ![lvbu](https://idcflare.com/user_avatar/idcflare.com/lvbu/32/17815_2.png) [@lvbu](https://idcflare.com/u/lvbu)\
**Post date:** [2025 年10 月 16 日 04:08 UTC](https://idcflare.com/t/topic/31822/16 "2025-10-16T04:08:51Z")

</div>

我来晚了 😂，才看到这个：[本期技术好文出炉，再来拉拉票 - 搞七捻三 - LINUX DO](https://linux.do/t/topic/1050179) 。义父还有下一期吗 😃

---

<div class="post-metadata">

**Author:** ![neo](https://idcflare.com/user_avatar/idcflare.com/neo/32/12_2.png) [@neo](https://idcflare.com/u/neo)\
**Post date:** [2025 年10 月 16 日 04:12 UTC](https://idcflare.com/t/topic/31822/17 "2025-10-16T04:12:04Z")

</div>

> [@征文，第 202540 期 - 结束](https://idcflare.com/t/topic/15957):
>
> 古早混 [linux.do](http://linux.do) 的佬友应该都知道，之前我做过一次征文活动，主题是 《我与linux的那些事》，帖子还可以在这里看到： 不知道为什么，一搞 linux 社区，我就想征文，可能是因为我真的想看点 linux 吧？ 我打算在本社区搞一个长期征文的活动。活动按周进行，活动细则如下： 征文主题内容为：IDC 相关技术类文章，标准大概是：能发到 #教程 版块的内容。 参与征文内容要求能过朱…

包有的，这是本站周期性特色活动。

---

<div class="post-metadata">

**Author:** ![Charlie](https://idcflare.com/user_avatar/idcflare.com/charlie/32/3693_2.png) [@Charlie](https://idcflare.com/u/Charlie)\
**Post date:** [2025 年10 月 16 日 04:14 UTC](https://idcflare.com/t/topic/31822/18 "2025-10-16T04:14:53Z")

</div>

这么多好文，有的学了呀

---

<div class="post-metadata">

**Author:** ![Bosa](https://idcflare.com/user_avatar/idcflare.com/bosa/32/1705_2.png) [@Bosa](https://idcflare.com/u/Bosa)\
**Post date:** [2025 年10 月 16 日 04:31 UTC](https://idcflare.com/t/topic/31822/19 "2025-10-16T04:31:15Z")

</div>

古法编程的魅力 🤓

---

<div class="post-metadata">

**Author:** ![DouBao](https://idcflare.com/user_avatar/idcflare.com/doubao/32/9953_2.png) [@DouBao](https://idcflare.com/u/DouBao)\
**Post date:** [2025 年10 月 16 日 05:10 UTC](https://idcflare.com/t/topic/31822/20 "2025-10-16T05:10:11Z")

</div>

好多精品,我要全部收藏

[下一页](https://idcflare.com/t/topic/31822.md?page=2)