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 'd%')
)
ORDER BY u.display_name
LIMIT 0,1000
What can I say, like everyone else on here, I am a massive Zombie fan. I am a rocking Mom of 3. Our youngest daughter has been rocking to Zombie since I pushed her little ass out! Right now, her fave song is Sick Bubble Gum, and walks around saying "RoCk A MothEr FUckEr!"..but it's ok...Zombie is GOD! I have seen RZ in concert 2 times now, and that is not nearly enough!! But, when you live in the middle of the fucking sticks, in Bumblefuck NY, you don't have many chances. Can't wait for Lords of Salem to come out!! Keep rocking our world Mr. Zombie! Much fucking Love Man!!
LATEST FAN COMMENTS