I need to find users who have not uploaded certain contents in last 30 days. I have tried this query it is not working. Can anyone help me?
select uid, max(created) as max_created from node where node.type in ('page','story') AND max_created < UNIX_TIMESTAMP()-2592000
I am getting error in phpmyadmin:
1054 - Unknown column 'max_created' in 'where clause'