SELECT
IFNULL(lo.logTime, 0) AS isOnline,
mem.signature, mem.location, mem.gender, mem.avatar, mem.ID_MEMBER,
mem.countPost, mem.countMuro, mem.countImg, mem.countCment,
mem.realName, mem.emailAddress, mem.dateRegistered, mem.websiteTitle,
mem.birthdate, mem.topics, mem.lastLogin, mem.memberIP, mem.memberIP2, mem.ID_GROUP,
mem.timeOffset, mem.usertitle,
mem.is_activated,
mem.totalTimeLoggedIn, mem.ID_POST_GROUP, lo.url, mg.onlineColor AS member_group_color, IFNULL(mg.groupName, '') AS member_group,
pg.onlineColor AS post_group_color, IFNULL(pg.groupName, '') AS post_group,
IF(mem.ID_GROUP = 0 OR mg.stars = '', pg.stars, mg.stars) AS stars, mem.posts, mem.passwordSalt
FROM cw_members AS mem
LEFT JOIN cw_log_online AS lo ON (lo.ID_MEMBER = mem.ID_MEMBER)
LEFT JOIN cw_membergroups AS pg ON (pg.ID_GROUP = mem.ID_POST_GROUP)
LEFT JOIN cw_membergroups AS mg ON (mg.ID_GROUP = mem.ID_GROUP)
WHERE mem.realName = 'DiamanteLoco'