MySQL WordPress database: How to find users who have not posted since a number of weeks, as I can't use max(date) in select clause?
Here is what I am at right now, but it does not return anything select wp_users.user_nicename, wp_users.user_email, max(yearweek(wp_wpforo_posts.created)) as w from LeBearCNC.wp_users, wp_wpforo_posts where wp_users.ID = wp_wpforo_posts.userid and not exists (select max(yearweek(wp_wpforo_posts.created)) where wp_users.ID = wp_wpforo_posts.userid) /*and yearweek(current_date()) - 12…