skip to Main Content

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…

VIEW QUESTION

MYSQL and COUNT IF

enter image description herei have folowing table with emails an integer I would have to add up all the integers and group them with the email to get a result EMAIL | COUNT. is something like that possible? I try…

VIEW QUESTION
Back To Top
Search