SELECT DISTINCT b.user_id as uid FROM jswup_users as a INNER JOIN jswup_ihc_user_levels as b ON a.ID=b.user_id INNER JOIN jswup_usermeta as c on a.ID=c.user_id INNER JOIN jswup_usermeta as d on a.ID=d.user_id INNER JOIN jswup_usermeta as f ON a.ID=f.user_id WHERE 1=1 AND ( b.level_id='2' OR b.level_id='4' OR b.level_id='5' OR b.level_id='6' OR b.level_id='7' OR b.level_id='8' OR b.level_id='9' OR b.level_id='10' OR b.level_id='12' OR b.level_id='16' OR b.level_id='17') AND b.expire_time>'2021-07-25 03:27:01' AND f.meta_key='last_name' ORDER BY a.user_registered descSELECT DISTINCT b.user_id as user_id FROM jswup_users as a INNER JOIN jswup_ihc_user_levels as b ON a.ID=b.user_id INNER JOIN jswup_usermeta as c on a.ID=c.user_id INNER JOIN jswup_usermeta as d on a.ID=d.user_id INNER JOIN jswup_usermeta as f ON a.ID=f.user_id WHERE 1=1 AND ( b.level_id='2' OR b.level_id='4' OR b.level_id='5' OR b.level_id='6' OR b.level_id='7' OR b.level_id='8' OR b.level_id='9' OR b.level_id='10' OR b.level_id='12' OR b.level_id='16' OR b.level_id='17') AND b.expire_time>'2021-07-25 03:27:01' AND f.meta_key='last_name' ORDER BY a.user_registered desc LIMIT 20 OFFSET 0
ShortCode :