話說, 以相同統計方式計算(早上八時為新一日)...
現在這一刻 v2Alliance 日發貼數為 273 帖...
已經過左大魏既 257 帖了
Reference SQL:
複製內容到剪貼板
代碼:
SELECT day, count( testing ) AS ct
FROM (
SELECT pid, (
Floor( dateline /86400 ) -13141
) AS day
FROM `posts`
WHERE pid <20000
) AS t
GROUP BY day
HAVING ct >100
ORDER BY ct DESC