1194 Table 'products' is marked as crashed and should be repaired
in:
[select count(p.products_id) as count from products p , products_to_categories p2c where p.products_status = 1 and p.products_id = p2c.products_id and p.parent_module='' and p.is_model = 1 and ( p2c.categories_id =2031 or p2c.categories_id =203101 or p2c.categories_id =203103 or p2c.categories_id =203105 or p2c.categories_id =203106 or p2c.categories_id =100005584 or p2c.categories_id =100005587 or p2c.categories_id =200000581 or p2c.categories_id =200003555 or p2c.categories_id =200003556 or p2c.categories_id =200003599 or p2c.categories_id =200003641 or p2c.categories_id =200003642 or p2c.categories_id =100005588 or p2c.categories_id =100005589 or p2c.categories_id =100005601 or p2c.categories_id =100005605 or p2c.categories_id =100005606 or p2c.categories_id =100006067 or p2c.categories_id =100007473 or p2c.categories_id =100007474 or p2c.categories_id =100007475 or p2c.categories_id =200003645 or p2c.categories_id =200000457 or p2c.categories_id =200000531 or p2c.categories_id =200000536 or p2c.categories_id =200000538 or p2c.categories_id =200000540 or p2c.categories_id =200000542 or p2c.categories_id =200000543 or p2c.categories_id =200000544 or p2c.categories_id =200000545 or p2c.categories_id =200000546 or p2c.categories_id =200000566 or p2c.categories_id =200000567 or p2c.categories_id =200000547 or p2c.categories_id =200000568 or p2c.categories_id =200000570 or p2c.categories_id =200000571 or p2c.categories_id =200000548 or p2c.categories_id =200000573 or p2c.categories_id =200000577 or p2c.categories_id =200000584 or p2c.categories_id =200000589 or p2c.categories_id =200002214 or p2c.categories_id =200002216 or p2c.categories_id =200003608 or p2c.categories_id =200003623 or p2c.categories_id =200000550 or p2c.categories_id =200000572 or p2c.categories_id =200000574 or p2c.categories_id =200000582 or p2c.categories_id =200000583 or p2c.categories_id =200000585 or p2c.categories_id =200000604 or p2c.categories_id =200000605 or p2c.categories_id =200000606 or p2c.categories_id =200000617 or p2c.categories_id =200000912 or p2c.categories_id =200003559 or p2c.categories_id =200003595 or p2c.categories_id =200003596 or p2c.categories_id =200003597 or p2c.categories_id =200003640 or p2c.categories_id =200000551 or p2c.categories_id =200000607 or p2c.categories_id =200000627 or p2c.categories_id =200000637 or p2c.categories_id =200000651 or p2c.categories_id =200000552 or p2c.categories_id =200000608 or p2c.categories_id =200000618 or p2c.categories_id =200000628 or p2c.categories_id =200000643 or p2c.categories_id =200000652 or p2c.categories_id =200003650 or p2c.categories_id =200000555 or p2c.categories_id =200000609 or p2c.categories_id =200000629 or p2c.categories_id =200000644 or p2c.categories_id =200000556 or p2c.categories_id =200000620 or p2c.categories_id =200000630 or p2c.categories_id =200000639 or p2c.categories_id =200000654 or p2c.categories_id =200000557 or p2c.categories_id =200000588 or p2c.categories_id =200000610 or p2c.categories_id =200000621 or p2c.categories_id =200000631 or p2c.categories_id =200000660 or p2c.categories_id =200003598 or p2c.categories_id =200003600 or p2c.categories_id =200003601 or p2c.categories_id =200003628 or p2c.categories_id =200003629 or p2c.categories_id =200000558 or p2c.categories_id =200000590 or p2c.categories_id =200000592 or p2c.categories_id =200000612 or p2c.categories_id =200000622 or p2c.categories_id =200000559 or p2c.categories_id =200000593 or p2c.categories_id =200000594 or p2c.categories_id =200000611 or p2c.categories_id =200000632 or p2c.categories_id =200000659 or p2c.categories_id =200000560 or p2c.categories_id =200000633 or p2c.categories_id =200000635 or p2c.categories_id =200000658 or p2c.categories_id =200000910 or p2c.categories_id =200000561 or p2c.categories_id =200000640 or p2c.categories_id =200000657 or p2c.categories_id =200000880 or p2c.categories_id =200003557 or p2c.categories_id =200003558 or p2c.categories_id =200000562 or p2c.categories_id =30108 or p2c.categories_id =30109 or p2c.categories_id =200000595 or p2c.categories_id =200000596 or p2c.categories_id =200000597 or p2c.categories_id =200000598 or p2c.categories_id =200000600 or p2c.categories_id =200003631 or p2c.categories_id =200003632 or p2c.categories_id =200000563 or p2c.categories_id =200000601 or p2c.categories_id =200000602 or p2c.categories_id =200000603 or p2c.categories_id =200000613 or p2c.categories_id =200000623 or p2c.categories_id =200000634 or p2c.categories_id =200000656 or p2c.categories_id =200000909 or p2c.categories_id =200003651 or p2c.categories_id =200000564 or p2c.categories_id =200000624 or p2c.categories_id =200000641 or p2c.categories_id =200000661 or p2c.categories_id =200002218 or p2c.categories_id =200000565 or p2c.categories_id =200000614 or p2c.categories_id =200000625 or p2c.categories_id =200000649 or p2c.categories_id =200000655 or p2c.categories_id =200000881 or p2c.categories_id =200000882 or p2c.categories_id =200000883 or p2c.categories_id =200003604 or p2c.categories_id =200003614 or p2c.categories_id =100005670 or p2c.categories_id =200000575 or p2c.categories_id =200000586 or p2c.categories_id =200000587 or p2c.categories_id =200003617 or p2c.categories_id =200003618 or p2c.categories_id =200003619 or p2c.categories_id =200003620 or p2c.categories_id =200003621 or p2c.categories_id =200003672 or p2c.categories_id =200003627 or p2c.categories_id =200003633 or p2c.categories_id =200003634 or p2c.categories_id =200003635 or p2c.categories_id =200003638 or p2c.categories_id =200003643 or p2c.categories_id =200001809 or p2c.categories_id =200001810 or p2c.categories_id =200001811 or p2c.categories_id =200003644 or p2c.categories_id =200003652)]