Unknown column 'endtime' in 'where clause'
select * from ***_ecms_zb where lspy='yingchao' and to_days('2025-05-02 11:22:45')=to_days(livetime) and (unix_timestamp(livetime)+7200>= 1746156165 or unix_timestamp(endtime)> 1746156165) order by unix_timestamp(livetime)