beauti-nof/database/update.sql

delete from mobile where not EXISTS(select * from mobile_info where mobile_info.mobile_id=mobile.id)

update mobile set sort_line=sort;
update mobile set sort_line=-20 where top_time=1;
update mobile set sort_line=-10 where rec_time=1;
update mobile set sort_line=-activity_time where is_activity=1;