Ηλεκτρικα εργαλεια

select * from (select Row_Number() over ( ORDER BY [prodPrice] ) as RowIndex, * FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~163~',[prodKatID]) > 0 OR CHARINDEX('~391604~',[prodKatID]) > 0 OR CHARINDEX('~569~',[prodKatID]) > 0 OR CHARINDEX('~176~',[prodKatID]) > 0 OR CHARINDEX('~580~',[prodKatID]) > 0 OR CHARINDEX('~6335~',[prodKatID]) > 0 OR CHARINDEX('~605~',[prodKatID]) > 0 OR CHARINDEX('~16065~',[prodKatID]) > 0 OR CHARINDEX('~171~',[prodKatID]) > 0 OR CHARINDEX('~192~',[prodKatID]) > 0 OR CHARINDEX('~578~',[prodKatID]) > 0 OR CHARINDEX('~581~',[prodKatID]) > 0 OR CHARINDEX('~175~',[prodKatID]) > 0 OR CHARINDEX('~16066~',[prodKatID]) > 0 OR CHARINDEX('~16067~',[prodKatID]) > 0 OR CHARINDEX('~182~',[prodKatID]) > 0 OR CHARINDEX('~47198~',[prodKatID]) > 0 OR CHARINDEX('~191822~',[prodKatID]) > 0 OR CHARINDEX('~127875~',[prodKatID]) > 0 OR CHARINDEX('~187~',[prodKatID]) > 0 OR CHARINDEX('~178~',[prodKatID]) > 0 OR CHARINDEX('~582~',[prodKatID]) > 0 OR CHARINDEX('~585~',[prodKatID]) > 0 OR CHARINDEX('~181~',[prodKatID]) > 0 OR CHARINDEX('~4435~',[prodKatID]) > 0 OR CHARINDEX('~191~',[prodKatID]) > 0 OR CHARINDEX('~203867~',[prodKatID]) > 0 OR CHARINDEX('~309722~',[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('~163~',[prodKatID]) > 0 OR CHARINDEX('~391604~',[prodKatID]) > 0 OR CHARINDEX('~569~',[prodKatID]) > 0 OR CHARINDEX('~176~',[prodKatID]) > 0 OR CHARINDEX('~580~',[prodKatID]) > 0 OR CHARINDEX('~6335~',[prodKatID]) > 0 OR CHARINDEX('~605~',[prodKatID]) > 0 OR CHARINDEX('~16065~',[prodKatID]) > 0 OR CHARINDEX('~171~',[prodKatID]) > 0 OR CHARINDEX('~192~',[prodKatID]) > 0 OR CHARINDEX('~578~',[prodKatID]) > 0 OR CHARINDEX('~581~',[prodKatID]) > 0 OR CHARINDEX('~175~',[prodKatID]) > 0 OR CHARINDEX('~16066~',[prodKatID]) > 0 OR CHARINDEX('~16067~',[prodKatID]) > 0 OR CHARINDEX('~182~',[prodKatID]) > 0 OR CHARINDEX('~47198~',[prodKatID]) > 0 OR CHARINDEX('~191822~',[prodKatID]) > 0 OR CHARINDEX('~127875~',[prodKatID]) > 0 OR CHARINDEX('~187~',[prodKatID]) > 0 OR CHARINDEX('~178~',[prodKatID]) > 0 OR CHARINDEX('~582~',[prodKatID]) > 0 OR CHARINDEX('~585~',[prodKatID]) > 0 OR CHARINDEX('~181~',[prodKatID]) > 0 OR CHARINDEX('~4435~',[prodKatID]) > 0 OR CHARINDEX('~191~',[prodKatID]) > 0 OR CHARINDEX('~203867~',[prodKatID]) > 0 OR CHARINDEX('~309722~',[prodKatID]) > 0 ) ORDER BY katigories.katigoriaName) t SELECT IsNull(@klist, '')

SELECT MAX([prodPrice]) AS HighestPrice FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND ( CHARINDEX('~163~',[prodKatID]) > 0 OR CHARINDEX('~391604~',[prodKatID]) > 0 OR CHARINDEX('~569~',[prodKatID]) > 0 OR CHARINDEX('~176~',[prodKatID]) > 0 OR CHARINDEX('~580~',[prodKatID]) > 0 OR CHARINDEX('~6335~',[prodKatID]) > 0 OR CHARINDEX('~605~',[prodKatID]) > 0 OR CHARINDEX('~16065~',[prodKatID]) > 0 OR CHARINDEX('~171~',[prodKatID]) > 0 OR CHARINDEX('~192~',[prodKatID]) > 0 OR CHARINDEX('~578~',[prodKatID]) > 0 OR CHARINDEX('~581~',[prodKatID]) > 0 OR CHARINDEX('~175~',[prodKatID]) > 0 OR CHARINDEX('~16066~',[prodKatID]) > 0 OR CHARINDEX('~16067~',[prodKatID]) > 0 OR CHARINDEX('~182~',[prodKatID]) > 0 OR CHARINDEX('~47198~',[prodKatID]) > 0 OR CHARINDEX('~191822~',[prodKatID]) > 0 OR CHARINDEX('~127875~',[prodKatID]) > 0 OR CHARINDEX('~187~',[prodKatID]) > 0 OR CHARINDEX('~178~',[prodKatID]) > 0 OR CHARINDEX('~582~',[prodKatID]) > 0 OR CHARINDEX('~585~',[prodKatID]) > 0 OR CHARINDEX('~181~',[prodKatID]) > 0 OR CHARINDEX('~4435~',[prodKatID]) > 0 OR CHARINDEX('~191~',[prodKatID]) > 0 OR CHARINDEX('~203867~',[prodKatID]) > 0 OR CHARINDEX('~309722~',[prodKatID]) > 0 )