SQLSTATE[42S22]: Column not found: 1054 Unknown column 'zjhj_bd_statistics_user_log.created_at' in 'where clause' The SQL being executed was: SELECT COUNT() FROM (SELECT su
. FROM zjhj_bd_statistics_user_log
su
LEFT JOIN zjhj_bd_user
u
ON zjhj_bd_statistics_user_log
.user_id = u.id WHERE ((su
.mall_id
=4) AND (su
.is_delete
=0)) AND (su
.mch_id
=501) AND (u
.be_mch_id
=501) AND (zjhj_bd_statistics_user_log
.created_at
>= '2021-08-20 00:00:00') AND (zjhj_bd_statistics_user_log
.created_at
<= '2021-08-20 23:59:59') GROUP BY zjhj_bd_statistics_user_log
.user_id
) `c
错误提示很明显,sql中的zjhj_bd_statistics_user_log.created_at字段不存在。