另一个比较经典的分页SQL

select c.*,d.*
from (
select distinct date(sign_in_time) sign_date,b.id,b.name
from sign_on_log a , users b
where b.status=0
) c left outer join sign_on_log d on c.sign_date=date(d.sign_in_time) and c.id=d.user_id

order by sign_date desc,name