SELECT u.*, p.*, u.id as id, u.is_deleted as is_deleted, IFNULL(p.gender, 0) as gender,
					g.title as grp,
					IF(DATE_FORMAT(u.regdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(u.regdate, 'Сегодня, %H:%i'), DATE_FORMAT(u.regdate, '%d, %M %Y')) as fregdate,
					IF(DATE_FORMAT(u.birthdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(u.birthdate, 'Сегодня!'), DATE_FORMAT(u.birthdate, '%d, %M %Y')) as birthdate,
					IF(DATE_FORMAT(u.logdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(u.logdate, 'Cегодня в %H:%i'), 
					IF(DATEDIFF(NOW(), u.logdate)=1, DATE_FORMAT(u.logdate, 'Вчера в %H:%i'),DATE_FORMAT(u.logdate, '%d-%m-%Y в %H:%i') ))  as flogdate
			FROM cms_users u, cms_user_profiles p, cms_user_groups g
			WHERE u.is_locked = 0 AND p.user_id = u.id AND u.id = 43 AND u.group_id = g.id
			LIMIT 1