SELECT DISTINCT p.id,[markaID],[retail_store_price],[Categories] FROM [products] AS p CROSS APPLY (SELECT TOP 1 [filepath] FROM [photos] WHERE [photos].object_Type='Product' AND [photos].object_ID=p.id AND [photos].filepath<>'' AND [photos].filepath IS NOT NULL) AS ph WHERE ('1' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ( ('5' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('6' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('7' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('9' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('10' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('11' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('13' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('27' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('28' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('30' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('32' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('33' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('34' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('36' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('38' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('41' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('43' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('46' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('134' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('197' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('249' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('445' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('512' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('846' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('907' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('490' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('491' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('58' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('65' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('69' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('85' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('102' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('109' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('110' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('111' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('933' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('937' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('938' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('942' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('943' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('952' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('964' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('74' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('75' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('77' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('78' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('79' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('81' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('493' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('909' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('946' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('948' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('949' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('50' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('52' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('89' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('90' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('91' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('93' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('94' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('998' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('53' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('95' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('96' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('497' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('968' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('126' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('140' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('63' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('64' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('120' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('935' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('939' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('70' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('71' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('72' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('73' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('945' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('86' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('101' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('104' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('105' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('944' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('146' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('951' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('953' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) ) | pagerTotal=874 | filtering=False | catID=1 | kz.count=25 | title DESC | title | SELECT DISTINCT [id] FROM (SELECT Row_Number() OVER ( ORDER BY p.title DESC) AS RowIndex,p.id FROM [products] AS p CROSS APPLY (SELECT TOP 1 [filepath] FROM [photos] WHERE [photos].object_Type='Product' AND [photos].object_ID=p.id AND [photos].filepath<>'' AND [photos].filepath IS NOT NULL) AS ph WHERE ('1' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ( ('5' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('6' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('7' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('9' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('10' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('11' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('13' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('27' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('28' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('30' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('32' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('33' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('34' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('36' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('38' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('41' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('43' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('46' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('134' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('197' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('249' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('445' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('512' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('846' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('907' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('490' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('491' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('58' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('65' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('69' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('85' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('102' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('109' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('110' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('111' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('933' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('937' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('938' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('942' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('943' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('952' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('964' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('74' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('75' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('77' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('78' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('79' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('81' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('493' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('909' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('946' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('948' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('949' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('50' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('52' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('89' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('90' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('91' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('93' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('94' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('998' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('53' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('95' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('96' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('497' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('968' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('126' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('140' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('63' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('64' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('120' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('935' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('939' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('70' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('71' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('72' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('73' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('945' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('86' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('101' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('104' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('105' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('944' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('146' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('951' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('953' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) )) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,5,6,7,9,10,11,13,27,28,30,32,33,34,36,38,41,43,46,134,197,249,445,512,846,907,490,491,58,65,69,85,102,109,110,111,933,937,938,942,943,952,964,74,75,77,78,79,81,493,909,946,948,949,50,52,89,90,91,93,94,998,53,95,96,497,968,126,140,63,64,120,935,939,70,71,72,73,945,86,101,104,105,944,146,951,953