对不正确的楼层进行排序

set @x=0; 
UPDATE roll_work w 
INNER JOIN (SELECT * from (SELECT wr.id,wr.cur_page,@x:=@x+1 as xsort from roll_work wr WHERE wr.work_total_id=11244 AND wr.status<>4 ORDER BY id asc) a where a.cur_page!=a.xsort) b 

ON b.id=w.id SET w.cur_page=b.xsort; 

cur_page是楼层

work_total_id是关联id