1030 Got error 28 from storage engine
in:
[select p.products_image, p.products_name, p.quantity_map, p.products_quantity, p.products_id,p.hero_shirts,p.products_model,date(p.products_date_added) as products_date_added, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_description, IF(p.specials_status = 'Special', p.specials_price, NULL) as specials_new_products_price, IF(p.specials_status ='Special', p.specials_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,p.groupname_id_2 as groupname_id, p.size_id_2 as size_id from new_products p left join products_attributes pr ON p.products_id = pr.products_id where p.products_status = 1 and p.language_id = '1' and (p.products_to_categories like '%#73#%' or p.products_to_categories like '%#1367#%' or p.products_to_categories like '%#2013#%' or p.products_to_categories like '%#2014#%' or p.products_to_categories like '%#2015#%' or p.products_to_categories like '%#3166#%' or p.products_to_categories like '%#3358#%' or p.products_to_categories like '%#3397#%' or p.products_to_categories like '%#3831#%' or p.products_to_categories like '%#3705#%' or p.products_to_categories like '%#4115#%' or p.products_to_categories like '%#74#%' or p.products_to_categories like '%#77#%' or p.products_to_categories like '%#78#%' or p.products_to_categories like '%#79#%' or p.products_to_categories like '%#82#%' or p.products_to_categories like '%#83#%' or p.products_to_categories like '%#3252#%' or p.products_to_categories like '%#3369#%' or p.products_to_categories like '%#4147#%' or p.products_to_categories like '%#84#%' or p.products_to_categories like '%#85#%' or p.products_to_categories like '%#1996#%' or p.products_to_categories like '%#2009#%' or p.products_to_categories like '%#2030#%' or p.products_to_categories like '%#2031#%' or p.products_to_categories like '%#2032#%' or p.products_to_categories like '%#3370#%' or p.products_to_categories like '%#3666#%' or p.products_to_categories like '%#4131#%' or p.products_to_categories like '%#86#%' or p.products_to_categories like '%#2024#%' or p.products_to_categories like '%#2025#%' or p.products_to_categories like '%#2026#%' or p.products_to_categories like '%#2034#%' or p.products_to_categories like '%#3371#%' or p.products_to_categories like '%#3414#%' or p.products_to_categories like '%#3667#%' or p.products_to_categories like '%#4133#%' or p.products_to_categories like '%#87#%' or p.products_to_categories like '%#2010#%' or p.products_to_categories like '%#3214#%' or p.products_to_categories like '%#3372#%' or p.products_to_categories like '%#4149#%' or p.products_to_categories like '%#92#%' or p.products_to_categories like '%#93#%' or p.products_to_categories like '%#2006#%' or p.products_to_categories like '%#3216#%' or p.products_to_categories like '%#3373#%' or p.products_to_categories like '%#4152#%' or p.products_to_categories like '%#94#%' or p.products_to_categories like '%#4153#%' or p.products_to_categories like '%#95#%' or p.products_to_categories like '%#99#%' or p.products_to_categories like '%#100#%' or p.products_to_categories like '%#4139#%' or p.products_to_categories like '%#102#%' or p.products_to_categories like '%#4140#%' or p.products_to_categories like '%#105#%' or p.products_to_categories like '%#108#%' or p.products_to_categories like '%#111#%' or p.products_to_categories like '%#225#%' or p.products_to_categories like '%#2000#%' or p.products_to_categories like '%#2001#%' or p.products_to_categories like '%#2252#%' or p.products_to_categories like '%#2796#%' or p.products_to_categories like '%#3977#%' or p.products_to_categories like '%#4098#%' or p.products_to_categories like '%#4216#%' or p.products_to_categories like '%#4767#%' or p.products_to_categories like '%#2#%') group by p.products_id order by p.products_sort_order,ISNULL(p.groupname_id_1 || p.groupname_id_2),ISNULL(p.size_id_1 || p.size_id_2),p.groupname_id_1, p.size_id_1,p.groupname_id_2, p.size_id_2 asc,p.products_id DESC limit 0, 48]
in:
[select p.products_image, p.products_name, p.quantity_map, p.products_quantity, p.products_id,p.hero_shirts,p.products_model,date(p.products_date_added) as products_date_added, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_description, IF(p.specials_status = 'Special', p.specials_price, NULL) as specials_new_products_price, IF(p.specials_status ='Special', p.specials_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,p.groupname_id_2 as groupname_id, p.size_id_2 as size_id from new_products p left join products_attributes pr ON p.products_id = pr.products_id where p.products_status = 1 and p.language_id = '1' and (p.products_to_categories like '%#73#%' or p.products_to_categories like '%#1367#%' or p.products_to_categories like '%#2013#%' or p.products_to_categories like '%#2014#%' or p.products_to_categories like '%#2015#%' or p.products_to_categories like '%#3166#%' or p.products_to_categories like '%#3358#%' or p.products_to_categories like '%#3397#%' or p.products_to_categories like '%#3831#%' or p.products_to_categories like '%#3705#%' or p.products_to_categories like '%#4115#%' or p.products_to_categories like '%#74#%' or p.products_to_categories like '%#77#%' or p.products_to_categories like '%#78#%' or p.products_to_categories like '%#79#%' or p.products_to_categories like '%#82#%' or p.products_to_categories like '%#83#%' or p.products_to_categories like '%#3252#%' or p.products_to_categories like '%#3369#%' or p.products_to_categories like '%#4147#%' or p.products_to_categories like '%#84#%' or p.products_to_categories like '%#85#%' or p.products_to_categories like '%#1996#%' or p.products_to_categories like '%#2009#%' or p.products_to_categories like '%#2030#%' or p.products_to_categories like '%#2031#%' or p.products_to_categories like '%#2032#%' or p.products_to_categories like '%#3370#%' or p.products_to_categories like '%#3666#%' or p.products_to_categories like '%#4131#%' or p.products_to_categories like '%#86#%' or p.products_to_categories like '%#2024#%' or p.products_to_categories like '%#2025#%' or p.products_to_categories like '%#2026#%' or p.products_to_categories like '%#2034#%' or p.products_to_categories like '%#3371#%' or p.products_to_categories like '%#3414#%' or p.products_to_categories like '%#3667#%' or p.products_to_categories like '%#4133#%' or p.products_to_categories like '%#87#%' or p.products_to_categories like '%#2010#%' or p.products_to_categories like '%#3214#%' or p.products_to_categories like '%#3372#%' or p.products_to_categories like '%#4149#%' or p.products_to_categories like '%#92#%' or p.products_to_categories like '%#93#%' or p.products_to_categories like '%#2006#%' or p.products_to_categories like '%#3216#%' or p.products_to_categories like '%#3373#%' or p.products_to_categories like '%#4152#%' or p.products_to_categories like '%#94#%' or p.products_to_categories like '%#4153#%' or p.products_to_categories like '%#95#%' or p.products_to_categories like '%#99#%' or p.products_to_categories like '%#100#%' or p.products_to_categories like '%#4139#%' or p.products_to_categories like '%#102#%' or p.products_to_categories like '%#4140#%' or p.products_to_categories like '%#105#%' or p.products_to_categories like '%#108#%' or p.products_to_categories like '%#111#%' or p.products_to_categories like '%#225#%' or p.products_to_categories like '%#2000#%' or p.products_to_categories like '%#2001#%' or p.products_to_categories like '%#2252#%' or p.products_to_categories like '%#2796#%' or p.products_to_categories like '%#3977#%' or p.products_to_categories like '%#4098#%' or p.products_to_categories like '%#4216#%' or p.products_to_categories like '%#4767#%' or p.products_to_categories like '%#2#%') group by p.products_id order by p.products_sort_order,ISNULL(p.groupname_id_1 || p.groupname_id_2),ISNULL(p.size_id_1 || p.size_id_2),p.groupname_id_1, p.size_id_1,p.groupname_id_2, p.size_id_2 asc,p.products_id DESC limit 0, 48]