How to fix mysql subquery display
===

   

     SELECT User.username, IFNULL( (
    SUM( credit ) - SUM( debit ) ) , 0
    ) AS total, (
    
    SELECT (
    SUM( Bid.credit ) - SUM( Bid.debit )
    ) AS freebids
    FROM users AS User
    LEFT JOIN bids AS Bid ON Bid.user_id = User.id
    WHERE Bid.type =2
    ) AS FreeBids, (
    
    SELECT (
    SUM( Bid.credit ) - SUM( Bid.debit )
    ) AS Normalbids
    FROM users AS User
    LEFT JOIN bids AS Bid ON Bid.user_id = User.id
    WHERE Bid.type =0
    OR Bid.type =1
    ) AS NormalBids
    FROM users AS User
    LEFT JOIN bids AS Bid ON Bid.user_id = User.id
    GROUP BY User.id

But I am having problem in displaying the subquery (Freebids and Normalbids) are all has the same value here are the sample display:


    username 	total 	FreeBids 	NormalBids
    user1 	    10 	     12809 	        965
    user2  	    20 	     12809 	        965
    user3  	    9 	     12809 	        965
    user4  	    0 	     12809 	        965

I can't figure out where did I go worng in my query.
Any suggestion to solve my problem?
Thank you for your help.