DIAG: loading caches... | DIAG: markes OK (79) | DIAG: categories OK (196) | DIAG: product_options OK (1950) | DIAG: product_options_records OK (5458) | DIAG: photos OK (4448) | DIAG: phz_list OK (4448) | SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',7,', p.categories)>0 OR p.categories='7') OR ( (CHARINDEX(',74,', p.categories)>0 OR p.categories='74') OR (CHARINDEX(',75,', p.categories)>0 OR p.categories='75') OR (CHARINDEX(',77,', p.categories)>0 OR p.categories='77') OR (CHARINDEX(',78,', p.categories)>0 OR p.categories='78') OR (CHARINDEX(',79,', p.categories)>0 OR p.categories='79') OR (CHARINDEX(',80,', p.categories)>0 OR p.categories='80') OR (CHARINDEX(',81,', p.categories)>0 OR p.categories='81') OR (CHARINDEX(',493,', p.categories)>0 OR p.categories='493') OR (CHARINDEX(',909,', p.categories)>0 OR p.categories='909') OR (CHARINDEX(',946,', p.categories)>0 OR p.categories='946') OR (CHARINDEX(',948,', p.categories)>0 OR p.categories='948') OR (CHARINDEX(',949,', p.categories)>0 OR p.categories='949')) | Timer 0: 2 ms | Timer 1: 199 ms | Timer 2: 1 ms | pagerTotal=96 | filtering=False | Timer 3: 2715 ms | catID=7 | kz.count=12 | title DESC | title | Timer 4: 24 ms | 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(2248,2578,2590,4787,6258,6366,7596,7653,8191,8781,8814,11201,11619,11666,11797,11813,11816,11852,11881,12074,12258,12279,12390,12391,12504,12515,12517,12518,12519,12520,12521,12726,12729,12732,12814,12815,12816,12818,13891,14981,14982,14983,15045,15076,15088,15103,16136,16450,16481,16490,16505,16506,16507,16508,16509,16537,16550,16551,16552,16629,16664,16665,16702,16703,16712,16713,16754,16756,16766,16771,16778,16801,16817,16930,18955,18958,19050,19053,19054,19055,19056,19057,19058,19059,19101,19119,19120,19121,19125,19136,19144,19170,19181,19201,19229,20038)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;

,74,75,77,78,79,80,81,493,909,946,948,949