select related from relatedkeywords where keyword = 'snowphyll' and unixtimestamp > (UNIX_TIMESTAMP(now()) - (30 * 24 * 60 * 60))