SELECT `nickid`, `realname`, `hiddenhostname`, `username`, `connecttime`, `servid`, `server`, `ctcpversion`,
											`country`, IF(`away`='Y', 'Yes', 'No') AS `away`,
											if(`away`='Y', CONCAT('(', `awaymsg`, ')'), '') AS `awaymsg`,
											IF(`online`='Y',
												'Yes',
												CONCAT('No, last seen saying: ', `lastquitmsg`,
													if(`lastquit`!=NULL,
														CONCAT(' at ', DATE_FORMAT(`lastquit`, '%W %M %e %X at %r')),
														'')
												)) AS `online`
											FROM `user` WHERE `nick` IN (SELECT `nick` FROM `aliases` WHERE `uname`='" . $users[0]['username'] . "') OR
											`nick` IN (SELECT `nick` FROM `anope_ns_alias` WHERE `display`='" . $users['username'] . "')