select available_balance as credit_limit,
(SELECT company_name from users where id=1) as company_name,
(select amount from accounts where share_to_user_id=1 and share_by_user_id=25  and account_type="balance" order by createdAt DESC limit 0,1) as last_debited_amount,
(select DATE_FORMAT(createdAt,"%d-%m-%Y") from accounts where share_to_user_id=1 and share_by_user_id=25  and account_type="balance" order by createdAt DESC limit 0,1) as last_debited_date,   
(select amount from accounts where share_to_user_id=1 and share_by_user_id=25 and account_type="booking" order by createdAt DESC limit 0,1) as last_transaction_amount,
(select DATE_FORMAT(createdAt,"%d-%m-%Y") from accounts where share_to_user_id=1 and share_by_user_id=25 and account_type="booking" order by createdAt DESC limit 0,1) as last_transaction_date
from accounts where share_to_user_id=1 and share_by_user_id=25 order by createdAt DESC limit 0,1