select * from (select Row_Number() over ( ORDER BY [prodPrice] ) as RowIndex, * FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~150~',[prodKatID]) > 0 OR CHARINDEX('~157916~',[prodKatID]) > 0 OR CHARINDEX('~200~',[prodKatID]) > 0 OR CHARINDEX('~206~',[prodKatID]) > 0 OR CHARINDEX('~207~',[prodKatID]) > 0 OR CHARINDEX('~209~',[prodKatID]) > 0 OR CHARINDEX('~119473~',[prodKatID]) > 0 OR CHARINDEX('~212~',[prodKatID]) > 0 OR CHARINDEX('~412705~',[prodKatID]) > 0 OR CHARINDEX('~249116~',[prodKatID]) > 0 OR CHARINDEX('~249115~',[prodKatID]) > 0 OR CHARINDEX('~97455~',[prodKatID]) > 0 OR CHARINDEX('~407406~',[prodKatID]) > 0 OR CHARINDEX('~301086~',[prodKatID]) > 0 OR CHARINDEX('~202~',[prodKatID]) > 0 OR CHARINDEX('~201~',[prodKatID]) > 0 OR CHARINDEX('~99306~',[prodKatID]) > 0 OR CHARINDEX('~197~',[prodKatID]) > 0 OR CHARINDEX('~211~',[prodKatID]) > 0 OR CHARINDEX('~267~',[prodKatID]) > 0 OR CHARINDEX('~102749~',[prodKatID]) > 0 OR CHARINDEX('~204~',[prodKatID]) > 0 OR CHARINDEX('~208~',[prodKatID]) > 0 OR CHARINDEX('~77978~',[prodKatID]) > 0 OR CHARINDEX('~104062~',[prodKatID]) > 0 OR CHARINDEX('~265~',[prodKatID]) > 0 OR CHARINDEX('~205~',[prodKatID]) > 0 OR CHARINDEX('~210~',[prodKatID]) > 0 )) as Sub Where Sub.RowIndex >= 1 and Sub.RowIndex <= 12;

---

/

---

---

DECLARE @klist NVARCHAR(MAX) SELECT @klist = COALESCE(@klist+'|' ,'') + CAST(katigoriaID as varchar(20)) + '~' + katigoriaName FROM (SELECT TOP 500 prods.prodKatID,katigories.katigoriaName,katigories.katigoriaID FROM prods INNER JOIN Katigories ON CHARINDEX('~'+ CAST(katigories.katigoriaID as varchar(20)) +'~',prods.prodKatID) > 0 WHERE ( CHARINDEX('~150~',[prodKatID]) > 0 OR CHARINDEX('~157916~',[prodKatID]) > 0 OR CHARINDEX('~200~',[prodKatID]) > 0 OR CHARINDEX('~206~',[prodKatID]) > 0 OR CHARINDEX('~207~',[prodKatID]) > 0 OR CHARINDEX('~209~',[prodKatID]) > 0 OR CHARINDEX('~119473~',[prodKatID]) > 0 OR CHARINDEX('~212~',[prodKatID]) > 0 OR CHARINDEX('~412705~',[prodKatID]) > 0 OR CHARINDEX('~249116~',[prodKatID]) > 0 OR CHARINDEX('~249115~',[prodKatID]) > 0 OR CHARINDEX('~97455~',[prodKatID]) > 0 OR CHARINDEX('~407406~',[prodKatID]) > 0 OR CHARINDEX('~301086~',[prodKatID]) > 0 OR CHARINDEX('~202~',[prodKatID]) > 0 OR CHARINDEX('~201~',[prodKatID]) > 0 OR CHARINDEX('~99306~',[prodKatID]) > 0 OR CHARINDEX('~197~',[prodKatID]) > 0 OR CHARINDEX('~211~',[prodKatID]) > 0 OR CHARINDEX('~267~',[prodKatID]) > 0 OR CHARINDEX('~102749~',[prodKatID]) > 0 OR CHARINDEX('~204~',[prodKatID]) > 0 OR CHARINDEX('~208~',[prodKatID]) > 0 OR CHARINDEX('~77978~',[prodKatID]) > 0 OR CHARINDEX('~104062~',[prodKatID]) > 0 OR CHARINDEX('~265~',[prodKatID]) > 0 OR CHARINDEX('~205~',[prodKatID]) > 0 OR CHARINDEX('~210~',[prodKatID]) > 0 ) ORDER BY katigories.katigoriaName) t SELECT IsNull(@klist, '')

---

SELECT MAX([prodPrice]) AS HighestPrice FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~150~',[prodKatID]) > 0 OR CHARINDEX('~157916~',[prodKatID]) > 0 OR CHARINDEX('~200~',[prodKatID]) > 0 OR CHARINDEX('~206~',[prodKatID]) > 0 OR CHARINDEX('~207~',[prodKatID]) > 0 OR CHARINDEX('~209~',[prodKatID]) > 0 OR CHARINDEX('~119473~',[prodKatID]) > 0 OR CHARINDEX('~212~',[prodKatID]) > 0 OR CHARINDEX('~412705~',[prodKatID]) > 0 OR CHARINDEX('~249116~',[prodKatID]) > 0 OR CHARINDEX('~249115~',[prodKatID]) > 0 OR CHARINDEX('~97455~',[prodKatID]) > 0 OR CHARINDEX('~407406~',[prodKatID]) > 0 OR CHARINDEX('~301086~',[prodKatID]) > 0 OR CHARINDEX('~202~',[prodKatID]) > 0 OR CHARINDEX('~201~',[prodKatID]) > 0 OR CHARINDEX('~99306~',[prodKatID]) > 0 OR CHARINDEX('~197~',[prodKatID]) > 0 OR CHARINDEX('~211~',[prodKatID]) > 0 OR CHARINDEX('~267~',[prodKatID]) > 0 OR CHARINDEX('~102749~',[prodKatID]) > 0 OR CHARINDEX('~204~',[prodKatID]) > 0 OR CHARINDEX('~208~',[prodKatID]) > 0 OR CHARINDEX('~77978~',[prodKatID]) > 0 OR CHARINDEX('~104062~',[prodKatID]) > 0 OR CHARINDEX('~265~',[prodKatID]) > 0 OR CHARINDEX('~205~',[prodKatID]) > 0 OR CHARINDEX('~210~',[prodKatID]) > 0 )