操作数应包含1列[重复]

您不应该在子查询中包括

COUNT(p.post_id) AS total_posts

SELECt

SELECT topic_id   FROM phpbb_topics AS tWHERe t.topic_id IN (    SELECt p.topic_id --, COUNT(p.post_id) AS total_posts     FROM phpbb_posts AS p    WHERe p.poster_id = 61640    GROUP BY p.topic_id    HAVINg t.topic_replies_real = COUNT(p.post_id) - 1);