|
Пользователь не найден. Возможно аккаунт был удален. 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 = 1 AND u.group_id = g.id
LIMIT 1
|