Table './azb74/SC_products' is marked as crashed and should be repaired
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE ( (p.productID IN (1564,1565,1729,1730,2481,2484,3794,3797,3801,3802,3805,3806,3807,3808,3809,3811,3813,3819,3820,3983,3986,3987,4047,4048,4062,4063,4078,4089,4090,4096,4097,5094,5178,5179,5221,5224,5225,5229,5230,6216,6217,11901,11902,11903,11905,11913,11915,11916,11918,11919,11922,11923,12076,12085,12088,12098,12583,12585,13368,13369,13553,15130,15131,15132,15183,15193,15197,15203,15387,15388,15389,16455,16456,16460,16462,17071,17074,17075,17078,17079,17081,17082,20388,20389,20390,20463,21412,22905,22906,24419,24441,24455,27213,27215,32249,32250,32256,32257,32258,32259,32260,33635,33636,33637,34687,34688,35504,35505,37301,37302,37303,37359,37360,39119,39122,39123,39476,39581,39765,39766,39767,39768,40239,42306,42310,42325,42326,43563,43568,43571,46427,46436,46440,46441,47120,47434,47436)) OR (categoryID IN (695)) ) AND ( enabled=1) AND status_off <> 1