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 = 'pieter1'