EXEC [dbo].[PR_Common_PagingLarge] 'PE_SD_Product LEFT JOIN PE_SD_Company ON PE_SD_Product.UserName = PE_SD_Company.UserName','PE_SD_Product.ProductID','PE_SD_Product.*,PE_SD_Company.CompanyName,PE_SD_Company.City,PE_SD_Company.Province',@pagesize, @startrow,'PE_SD_Product.Status>0 AND PE_SD_Product.Type=1 AND PE_SD_Product.Validdate>getdate()-1
AND PE_SD_Company.Province LIKE ''%陕西省%''
AND PE_SD_Product.CategoryID IN (38,39,40,41,42,43,44,45,46,66,67,68,69,79,80,81,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104)
','','PE_SD_Product.ProductID DESC'
