SELECT TOP @pagesize * FROM PE_CommonModel CM INNER JOIN PE_U_Article UT ON (CM.ItemID = UT.ID) WHERE CM.Status = 99 AND CM.NodeID IN (143, 0 ) AND CM.GeneralID NOT IN(SELECT TOP @startrow CM.GeneralID FROM PE_CommonModel CM INNER JOIN PE_U_Article UT ON (CM.ItemID = UT.ID) WHERE CM.Status = 99 AND CM.NodeID IN (143, 0 ) ORDER BY CM.UpdateTime DESC, CM.GeneralID DESC) ORDER BY CM.UpdateTime DESC, CM.GeneralID DESCSELECT COUNT (CM.GeneralID) FROM PE_CommonModel CM INNER JOIN PE_U_Article UT ON (CM.ItemID = UT.ID) WHERE CM.Status = 99 AND CM.NodeID IN (143, 0 )