SELECT u.username, u.email, up.nick, up.created_at, COUNT(p.id) as regs, SUM(t.amount) as deps, MAX(t.created_at) as maxt
                                                               FROM users u LEFT JOIN users_profile up ON u.id = up.user_id LEFT JOIN players p ON p.partner_id = u.id
                                                                            LEFT JOIN transactions t ON t.user_id = p.user_id
                                                                WHERE t.project_id = p.project_id and t.direction = 1
                                                                GROUP BY u.id