SELECT distinct(ID), um.meta_value, um1.meta_value from wp_users as us INNER JOIN wp_usermeta as um on us.id = um.user_id INNER JOIN wp_usermeta as um1 on us.id = um1.user_id WHERE um.meta_key = 'role' AND um1.meta_key = 'last_name' AND ( um.meta_value='s2member_level4' OR um.meta_value='s2member_level3' OR um.meta_value='s2member_level2' ) ORDER bY um.meta_value DESC, um1.meta_value ASC LIMIT 0, 50-
Sorry, no matching records found.
