SELECT t1.*,
COUNT(CASE WHEN t2.time >= UNIX_TIMESTAMP() - 86400) AS 24_hours,
COUNT(CASE WHEN t2.time >= UNIX_TIMESTAMP() - 172800) AS 48_hours,
COUNT(CASE WHEN t2.time >= UNIX_TIMESTAMP() - 259200) AS 72_hours
FROM table1 AS t1
LEFT JOIN table2 AS t2 ON t2.t1_id = t1.id
这不起作用,我正在尝试计算,添加 3 个字段,每个字段 3 个时间段。我们需要计算第二个表中的记录数......