1030 Got error 28 from storage engine
in:
[select p.products_id, p.products_type,p.products_status,p.products_price,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products_quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and ( p2c.categories_id =3230 or p2c.categories_id =3646 or p2c.categories_id =3648 or p2c.categories_id =3654 or p2c.categories_id =3656 or p2c.categories_id =3657 or p2c.categories_id =3661 or p2c.categories_id =3662 or p2c.categories_id =3663 or p2c.categories_id =3664 or p2c.categories_id =3665 or p2c.categories_id =3666 or p2c.categories_id =3669 or p2c.categories_id =3681 or p2c.categories_id =3695 or p2c.categories_id =3697 or p2c.categories_id =3698 or p2c.categories_id =3706 or p2c.categories_id =3729 or p2c.categories_id =3734 or p2c.categories_id =3740 or p2c.categories_id =3332 or p2c.categories_id =3338 or p2c.categories_id =3644 or p2c.categories_id =3714 or p2c.categories_id =3715 or p2c.categories_id =3716 or p2c.categories_id =3717 or p2c.categories_id =3718 or p2c.categories_id =3719 or p2c.categories_id =3720 or p2c.categories_id =3738 or p2c.categories_id =3346 or p2c.categories_id =3670 or p2c.categories_id =3671 or p2c.categories_id =3673 or p2c.categories_id =3674 or p2c.categories_id =3675 or p2c.categories_id =3676 or p2c.categories_id =3677 or p2c.categories_id =3679 or p2c.categories_id =3678 or p2c.categories_id =3680 or p2c.categories_id =3683 or p2c.categories_id =3699 or p2c.categories_id =3708 or p2c.categories_id =3709 or p2c.categories_id =3721 or p2c.categories_id =3722 or p2c.categories_id =3723 or p2c.categories_id =3724 or p2c.categories_id =3725 or p2c.categories_id =3726 or p2c.categories_id =3727 or p2c.categories_id =3737 or p2c.categories_id =3739 or p2c.categories_id =3649 or p2c.categories_id =3650 or p2c.categories_id =3705 or p2c.categories_id =3730 or p2c.categories_id =3731 or p2c.categories_id =3732 or p2c.categories_id =3651 or p2c.categories_id =3652 or p2c.categories_id =3653 or p2c.categories_id =3685 or p2c.categories_id =3686 or p2c.categories_id =3687 or p2c.categories_id =3688 or p2c.categories_id =3689 or p2c.categories_id =3690 or p2c.categories_id =3691 or p2c.categories_id =3692 or p2c.categories_id =3693 or p2c.categories_id =3694 or p2c.categories_id =3655 or p2c.categories_id =3658 or p2c.categories_id =3659 or p2c.categories_id =3700 or p2c.categories_id =3701 or p2c.categories_id =3702 or p2c.categories_id =3704 or p2c.categories_id =3707 or p2c.categories_id =3660 or p2c.categories_id =3667 or p2c.categories_id =3668 or p2c.categories_id =3696 or p2c.categories_id =3710 or p2c.categories_id =3711 or p2c.categories_id =3712 or p2c.categories_id =3733 or p2c.categories_id =3735 or p2c.categories_id =3736) order by p.products_date_added DESC]