SELECT*,@rownum:=@rownum+1 AS rownum FROM `T_CRM_PARTY_MEMBER`,(SELECT @rownum:=0) r ORDER BY addtime LIMIT 4,1100