محصولات کلید و پریز

select IdP,DescP,TypeP,Attr,GroupP,PriceP,TedadP,PictureP,NameP,ProductBarcode,OrderMinP,OrderMaxP,VahedP,FreeDeliveryP,FactoryId,MinPriceToFilter,MaxPriceToFilter,ProductSerial from Tb_Product inner join Tb_Users on Tb_Product.IdTamin=Tb_Users.IdU where PublishedP='1' and DeletedP='0' and GroupP LIKE '73,4956,5153%' order by CASE WHEN TedadP = 0 THEN Tb_Users.OrderId END ASC,Tb_Users.OrderId asc, IdP asc OFFSET 0 ROWS FETCH NEXT 24 ROWS ONLY