EXEC [dbo].[PR_Common_PagingLarge] 'PE_CommonModel CM INNER JOIN PE_SpecialInfos SI ON (CM.GeneralID = SI.GeneralID) ', 'CM.GeneralID', '*', @pagesize, @startrow, 'CM.Status = 99 AND SI.SpecialID IN (9) ', '', 'CM.UpdateTime DESC,CM.GeneralID DESC' ;SELECT COUNT (CM.ItemID) FROM PE_CommonModel CM INNER JOIN PE_SpecialInfos SI ON (CM.GeneralID = SI.GeneralID) WHERE CM.Status = 99 AND SI.SpecialID IN (9)