SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',52,', p.categories)>0 OR p.categories='52') | pagerTotal=20 | filtering=False | catID=52 | kz.count=0 | title DESC | title | SELECT DISTINCT [id] FROM (SELECT Row_Number() OVER ( ORDER BY p.title DESC) AS RowIndex, p.id FROM [products] AS p WHERE p.id IN(2863,5771,8241,8412,8714,9075,12522,12524,12526,12542,14984,14986,15074,15089,16252,16427,16437,16438,16636,16638)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;