SET names utf8
SET charset utf8
UPDATE users SET last_action = NOW(),online = 0,autologin = '' WHERE id = '0'
UPDATE online_users SET user_ip='38.107.191.111', browsing='/admin_page' WHERE `key`='8bd037b64258ad54c750eaff24105c01'
SELECT users.id, users.name, users.username, users.show_age, user_pics.thumb, professions.profile as profession_type, TIMESTAMPDIFF(YEAR, birthdate, NOW()) as age, users.state_id, users.city, users.user_type, users.online, last_action, DATE_FORMAT(last_action, '%m/%d/%Y %h:%i') as last_act,professions.name as profession_name, MAX(msgs.id) as last_message, COUNT(msgs.id) as message_count FROM users JOIN friends ON users.id=friends.friend_id AND friends.state=1 AND users.online=1 AND friends.user_id=0 LEFT JOIN user_pics ON users.main_pic_id=user_pics.id INNER JOIN professions on users.user_type=professions.id LEFT JOIN msgs ON msgs.from_user_id=friend_id AND msgs.to_user_id=friends.user_id AND msgs.is_read=0 AND msgs.del_to=0 GROUP BY friend_id, msgs.from_user_id, msgs.to_user_id
Page generated for 0.0534sec. 5 queries executed.