thinkphp querying MySQL database data time sorting problem

Now there are three states, the first one has expired, the second does not expire, the third is the time to determine the effect that I want now is the non-expiry time before, to determine the time in the middle, the expiration time after, the sort statement should be how to write?

$list = $activity->where (' is_check=1 ')->order (' actdate desc ')->limit ($Page->firstrow. ', '. $Page listRows)->select ();

Now the sort is only according to the time Desc sort, because the related pagination, so not very will write, please help. Thank you.

Reply to discussion (solution)

What is your status field? The field of assumed state is Zhuangtai
Then the SQL statement inside order is written as ORDER by Zhuangtai Desc,actdate Desc will be sorted by state and then (in the same state) sorted by time

