1030 Got error 28 from storage engine
in:
[select distinct p.products_id, p.products_type, 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 zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_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 IN(24,26,25,27,28,29,31,30,99,32,34,33,35,101,37,36,38,40,102,103,104,42,41,39,43,44,45,46,105,81,47,48,100,106,49,50,51,53,52,93,94,54,55,56,57,58,59,60,61,62,63,107,96,95,64,65,108,97,109,66,67,68,110,69,70,73,71,72,74,75,76,77,111,78,79,80,98,82,83,84,85,86,87,88,112,89,114,90,91,92,113)]