delete cdb_members , cdb_memberfields from cdb_members , cdb_memberfields where cdb_members.lastvisit+90*86400< UNIX_TIMESTAMP() and cdb_memberfields.uid=cdb_members.uid; [error]
delete cdb_members , cdb_memberfields from cdb_members , cdb_memberfields
where
cdb_members.lastactivity+90*86400<UNIX_TIMESTAMP()
or (cdb_members.lastactivity+90*86400<=UNIX_TIMESTAMP() and cdb_members.lastactivity>0)
and cdb_memberfields.uid=cdb_members.uid;[right]
![](https://img2024.cnblogs.com/blog/35695/202408/35695-20240826070647288-243310440.jpg)