So it would be something like....Show all users who are NOT named "anonymous" AND (have a thumbnail OR entered "About Me" info OR wrote an article OR entered "User Map" info)
...but that is as far as I can figure out how to do an advanced filter for a user list. Help!username is NOT = "anonymous" AND
(is NOT EMPTY thumbnail OR
is NOT EMPTY "About Me" OR
is NOT EMPTY "Articles" OR
is NOT EMPTY "User Map")
Please Log in to join the conversation.
Please Log in to join the conversation.
What do you think? Also...I can't figure out how to add in....is NOT EMPTY "Articles".SELECT (FROM mos_users WHERE username != ‘Anonymous’ AND WHERE user_lastvisit > DATE_SUB(NOW(), INTERVAL 6 MONTH)) AND (FROM mos_comprofiler WHERE avatar != ‘NULL’ OR cb_aboutme != ‘NULL’ OR cb_geomangeocode != ‘NULL’)
Please Log in to join the conversation.
I can't get the last online thing to work at all (to pick up they must have been online in the last 6 months) and I have no idea how I can say "OR the articles tab isn't empty"(username !='Anonymous') AND (`avatar` IS NOT NULL OR `cb_geomangeocode` IS NOT NULL OR `cb_aboutme` IS NOT NULL)
Please Log in to join the conversation.
Please Log in to join the conversation.