Βιδοειδη

select * from (select Row_Number() over ( ORDER BY [prodPrice] ) as RowIndex, * FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~475~',[prodKatID]) > 0 OR CHARINDEX('~340161~',[prodKatID]) > 0 OR CHARINDEX('~476~',[prodKatID]) > 0 OR CHARINDEX('~477~',[prodKatID]) > 0 OR CHARINDEX('~480~',[prodKatID]) > 0 OR CHARINDEX('~481~',[prodKatID]) > 0 OR CHARINDEX('~486~',[prodKatID]) > 0 OR CHARINDEX('~487~',[prodKatID]) > 0 OR CHARINDEX('~488~',[prodKatID]) > 0 OR CHARINDEX('~489~',[prodKatID]) > 0 OR CHARINDEX('~496~',[prodKatID]) > 0 OR CHARINDEX('~498~',[prodKatID]) > 0 OR CHARINDEX('~499~',[prodKatID]) > 0 OR CHARINDEX('~500~',[prodKatID]) > 0 OR CHARINDEX('~501~',[prodKatID]) > 0 OR CHARINDEX('~502~',[prodKatID]) > 0 OR CHARINDEX('~503~',[prodKatID]) > 0 OR CHARINDEX('~507~',[prodKatID]) > 0 OR CHARINDEX('~508~',[prodKatID]) > 0 OR CHARINDEX('~509~',[prodKatID]) > 0 OR CHARINDEX('~510~',[prodKatID]) > 0 OR CHARINDEX('~511~',[prodKatID]) > 0 OR CHARINDEX('~615~',[prodKatID]) > 0 OR CHARINDEX('~616~',[prodKatID]) > 0 OR CHARINDEX('~340003~',[prodKatID]) > 0 OR CHARINDEX('~340160~',[prodKatID]) > 0 OR CHARINDEX('~407410~',[prodKatID]) > 0 OR CHARINDEX('~8309~',[prodKatID]) > 0 OR CHARINDEX('~111462~',[prodKatID]) > 0 OR CHARINDEX('~76431~',[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('~475~',[prodKatID]) > 0 OR CHARINDEX('~340161~',[prodKatID]) > 0 OR CHARINDEX('~476~',[prodKatID]) > 0 OR CHARINDEX('~477~',[prodKatID]) > 0 OR CHARINDEX('~480~',[prodKatID]) > 0 OR CHARINDEX('~481~',[prodKatID]) > 0 OR CHARINDEX('~486~',[prodKatID]) > 0 OR CHARINDEX('~487~',[prodKatID]) > 0 OR CHARINDEX('~488~',[prodKatID]) > 0 OR CHARINDEX('~489~',[prodKatID]) > 0 OR CHARINDEX('~496~',[prodKatID]) > 0 OR CHARINDEX('~498~',[prodKatID]) > 0 OR CHARINDEX('~499~',[prodKatID]) > 0 OR CHARINDEX('~500~',[prodKatID]) > 0 OR CHARINDEX('~501~',[prodKatID]) > 0 OR CHARINDEX('~502~',[prodKatID]) > 0 OR CHARINDEX('~503~',[prodKatID]) > 0 OR CHARINDEX('~507~',[prodKatID]) > 0 OR CHARINDEX('~508~',[prodKatID]) > 0 OR CHARINDEX('~509~',[prodKatID]) > 0 OR CHARINDEX('~510~',[prodKatID]) > 0 OR CHARINDEX('~511~',[prodKatID]) > 0 OR CHARINDEX('~615~',[prodKatID]) > 0 OR CHARINDEX('~616~',[prodKatID]) > 0 OR CHARINDEX('~340003~',[prodKatID]) > 0 OR CHARINDEX('~340160~',[prodKatID]) > 0 OR CHARINDEX('~407410~',[prodKatID]) > 0 OR CHARINDEX('~8309~',[prodKatID]) > 0 OR CHARINDEX('~111462~',[prodKatID]) > 0 OR CHARINDEX('~76431~',[prodKatID]) > 0 ) ORDER BY katigories.katigoriaName) t SELECT IsNull(@klist, '')

SELECT MAX([prodPrice]) AS HighestPrice FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~475~',[prodKatID]) > 0 OR CHARINDEX('~340161~',[prodKatID]) > 0 OR CHARINDEX('~476~',[prodKatID]) > 0 OR CHARINDEX('~477~',[prodKatID]) > 0 OR CHARINDEX('~480~',[prodKatID]) > 0 OR CHARINDEX('~481~',[prodKatID]) > 0 OR CHARINDEX('~486~',[prodKatID]) > 0 OR CHARINDEX('~487~',[prodKatID]) > 0 OR CHARINDEX('~488~',[prodKatID]) > 0 OR CHARINDEX('~489~',[prodKatID]) > 0 OR CHARINDEX('~496~',[prodKatID]) > 0 OR CHARINDEX('~498~',[prodKatID]) > 0 OR CHARINDEX('~499~',[prodKatID]) > 0 OR CHARINDEX('~500~',[prodKatID]) > 0 OR CHARINDEX('~501~',[prodKatID]) > 0 OR CHARINDEX('~502~',[prodKatID]) > 0 OR CHARINDEX('~503~',[prodKatID]) > 0 OR CHARINDEX('~507~',[prodKatID]) > 0 OR CHARINDEX('~508~',[prodKatID]) > 0 OR CHARINDEX('~509~',[prodKatID]) > 0 OR CHARINDEX('~510~',[prodKatID]) > 0 OR CHARINDEX('~511~',[prodKatID]) > 0 OR CHARINDEX('~615~',[prodKatID]) > 0 OR CHARINDEX('~616~',[prodKatID]) > 0 OR CHARINDEX('~340003~',[prodKatID]) > 0 OR CHARINDEX('~340160~',[prodKatID]) > 0 OR CHARINDEX('~407410~',[prodKatID]) > 0 OR CHARINDEX('~8309~',[prodKatID]) > 0 OR CHARINDEX('~111462~',[prodKatID]) > 0 OR CHARINDEX('~76431~',[prodKatID]) > 0 )