Problems w/ selecting model data in the right order

Your join is wrong. Should be ON users.id = accounts.user_id