Short position

select P.client_id as UserID, if(U.email is NULL,U.telephone,U.email)as User, P.position, P.`leverage`, P.`bankrupt_price`
from t_position P
left join management.t_trade_user as U on P.client_id = U.user_id
where P.direction = 'Sell' and P.position != 0
order by P.position desc