Query command to delete inactive guilds

[Nightimarez]

Can anyone make a xampp query command that deletes guilds of leader's that haven't logged on for like a month?

DELETE FROM guilds WHERE ownerid < lastlogin < UNIX_TIMESTAMP() - 30*24*60*60

I tried this, but I failed. I know it has to direct it back to the player's last login, but it complicates it a bit for me.

Or better yet, make it so it delete's the guild if the player doesn't exist anymore.

DELETE FROM guilds WHERE ownerid notfound in players

Just an example

 

[Nightimarez]

......

 

[Nightimarez]

blah!

 

[Nightimarez]

meh.