mysql> SELECT l.payuserid,l.ispay,l.id,if(l.title!='' and l.title is not null,l.title,l2.title) title FROM
local_email as l left join t_users as t
on l.suid=t.userid
left join t_users as t2
on l.ruid=t2.userid
left join t_users as t3
on l.payuserid=t3.userid
left join local_email l2
on l.pid=l2.id
where (l.ruid=1602241320282666 or (l.ispay='1' and l.receiveid=1603021316454064)) and l.sisdel='0' order by l.isr,l.id desc;