关于MySQL 排序

select ci. itemAccountId,w.mobileNumber,ci.cooperationKey , ci.addAt,ci.outAt,@rownum :=@rownum + 1 AS times FROM (SELECT @rownum := 0) r ,.cpn_2021_festival_cooperation_item ci
left join.www_member w
on w.`key`=ci.itemAccountId
where ci.isCreate=0
and w.mobileNumber= 13213787292