SELECT u.ID as uid, u.display_name, cast(m4.meta_value as datetime) as last_activity, 99999 as distance,
CASE
WHEN u.display_name LIKE '% %' THEN right(u.display_name, length(u.display_name)-locate(' ', u.display_name))
ELSE u.display_name
END AS surname
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 'x%')
)
ORDER BY cast(m4.meta_value as datetime) DESC
LIMIT 0,1000
This Internet site provides information of a general nature and is designed for educational purposes only. If you have any concerns about your own health or the health of your child, you should always consult with a physician or other healthcare professional. Please review the Terms of Use before using this site. Your use of the site indicates your agreement to be bound by the Terms of Use.
This site is published by STDZip L.L.C., which is responsible for its contents as further described and qualified in the Terms of Use.
Latest Comments