EXEC [dbo].[PR_Common_PagingLarge] 'PE_CommonModel CM ', 'CM.GeneralID', '*', @pagesize, @startrow, 'CM.Status = 99 AND CM.NodeID IN (151, 0 ) ', '', 'CM.GeneralID ASC' ;SELECT COUNT (CM.ItemID) FROM PE_CommonModel CM WHERE CM.Status = 99 AND CM.NodeID IN (151, 0 )