query

SELECT
                                main.createTimeStamp AS registrationDate,
                                main.full_name AS member_name,
                                main.userName AS member_wallet,
                                CASE main.userType
                                    WHEN
                                        'Agent'
                                    THEN
                                        (CASE main.srWallet
                                            WHEN NOT NULL THEN main.srWallet
                                            ELSE main.distributorWallet
                                        END)
                                    WHEN 'SR' THEN main.distributorWallet
                                    WHEN 'MR' THEN main.merchantWallet
                                    WHEN 'subagent' THEN main.agentWallet
                                    WHEN 'unbanked' THEN main.agentWallet
                                    ELSE ''
                                END  AS parentWallet,
                                IFNULL(d.name,'') AS districtName,
                                IFNULL(t.name,'') AS thanaName,
                                main.userType userTypeName,
                                main.profinoUserStatus statusName
                            FROM
                                sc_user_temp_profile main
                                    LEFT JOIN
                                district d ON d.did = (CASE main.userType
                                    WHEN 'unbanked' THEN main.districtPresent
                                    WHEN 'banked' THEN main.districtPresent
                                    ELSE main.districtOffice
                                END)
                                    LEFT JOIN
                                thana t ON t.tid = (CASE main.userType
                                    WHEN 'unbanked' THEN main.psThanaPresent
                                    WHEN 'banked' THEN main.psThanaPresent
                                    ELSE main.psThanaOffice
                                END)