SELECT u.ID as uid, u.display_name, cast(m4.meta_value as datetime) as last_activity, 99999 as distance FROM wp_users u LEFT JOIN wp_usermeta m4 ON u.ID = m4.user_id WHERE m4.meta_key = 'symposium_last_activity' AND (u.display_name IS NOT NULL) AND ( (lower(u.display_name) LIKE 'q%') ) ORDER BY cast(m4.meta_value as datetime) DESC LIMIT 0,1000