SELECT TOP @pagesize * FROM PE_CommonModel CM INNER JOIN PE_U_Soft UT ON (CM.ItemID = UT.ID) WHERE CM.Status = 99 AND CM.DefaultPicUrl != '' AND CM.GeneralID NOT IN ( SELECT TOP @startrow ICM.GeneralID FROM PE_CommonModel ICM INNER JOIN PE_U_Soft IUT ON (ICM.ItemID = IUT.ID) WHERE ICM.Status = 99 AND ICM.DefaultPicUrl != '' ORDER BY ICM.UpdateTime DESC) ORDER BY CM.UpdateTime DESC