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 '%#190#%' or p.products_to_categories like '%#1247#%' or p.products_to_categories like '%#1248#%' or p.products_to_categories like '%#1249#%' or p.products_to_categories like '%#4005#%' or p.products_to_categories like '%#1250#%' or p.products_to_categories like '%#1251#%' or p.products_to_categories like '%#1252#%' or p.products_to_categories like '%#1276#%' or p.products_to_categories like '%#1308#%' or p.products_to_categories like '%#1341#%' or p.products_to_categories like '%#3192#%' or p.products_to_categories like '%#3361#%' or p.products_to_categories like '%#3398#%' or p.products_to_categories like '%#3709#%' or p.products_to_categories like '%#4120#%' or p.products_to_categories like '%#191#%' or p.products_to_categories like '%#3143#%' or p.products_to_categories like '%#3144#%' or p.products_to_categories like '%#3145#%' or p.products_to_categories like '%#3146#%' or p.products_to_categories like '%#3147#%' or p.products_to_categories like '%#3362#%' or p.products_to_categories like '%#3399#%' or p.products_to_categories like '%#4121#%' or p.products_to_categories like '%#192#%' or p.products_to_categories like '%#193#%' or p.products_to_categories like '%#194#%' or p.products_to_categories like '%#195#%' or p.products_to_categories like '%#196#%' or p.products_to_categories like '%#954#%' or p.products_to_categories like '%#955#%' or p.products_to_categories like '%#956#%' or p.products_to_categories like '%#957#%' or p.products_to_categories like '%#958#%' or p.products_to_categories like '%#1968#%' or p.products_to_categories like '%#3360#%' or p.products_to_categories like '%#3363#%' or p.products_to_categories like '%#3710#%' or p.products_to_categories like '%#3918#%' or p.products_to_categories like '%#4127#%' or p.products_to_categories like '%#197#%' or p.products_to_categories like '%#198#%' or p.products_to_categories like '%#1372#%' or p.products_to_categories like '%#3359#%' or p.products_to_categories like '%#4990#%' or p.products_to_categories like '%#199#%' or p.products_to_categories like '%#200#%' or p.products_to_categories like '%#948#%' or p.products_to_categories like '%#949#%' or p.products_to_categories like '%#950#%' or p.products_to_categories like '%#952#%' or p.products_to_categories like '%#953#%' or p.products_to_categories like '%#1361#%' or p.products_to_categories like '%#3364#%' or p.products_to_categories like '%#3417#%' or p.products_to_categories like '%#3445#%' or p.products_to_categories like '%#4134#%' or p.products_to_categories like '%#201#%' or p.products_to_categories like '%#1373#%' or p.products_to_categories like '%#3160#%' or p.products_to_categories like '%#3311#%' or p.products_to_categories like '%#3365#%' or p.products_to_categories like '%#3447#%' or p.products_to_categories like '%#3448#%' or p.products_to_categories like '%#3449#%' or p.products_to_categories like '%#202#%' or p.products_to_categories like '%#1254#%' or p.products_to_categories like '%#1255#%' or p.products_to_categories like '%#1256#%' or p.products_to_categories like '%#1257#%' or p.products_to_categories like '%#1259#%' or p.products_to_categories like '%#1310#%' or p.products_to_categories like '%#1360#%' or p.products_to_categories like '%#3366#%' or p.products_to_categories like '%#3419#%' or p.products_to_categories like '%#3450#%' or p.products_to_categories like '%#3876#%' or p.products_to_categories like '%#4117#%' or p.products_to_categories like '%#203#%' or p.products_to_categories like '%#204#%' or p.products_to_categories like '%#1992#%' or p.products_to_categories like '%#3239#%' or p.products_to_categories like '%#3240#%' or p.products_to_categories like '%#3338#%' or p.products_to_categories like '%#3367#%' or p.products_to_categories like '%#3420#%' or p.products_to_categories like '%#3446#%' or p.products_to_categories like '%#4136#%' or p.products_to_categories like '%#205#%' or p.products_to_categories like '%#206#%' or p.products_to_categories like '%#207#%' or p.products_to_categories like '%#4995#%' or p.products_to_categories like '%#208#%' or p.products_to_categories like '%#1312#%' or p.products_to_categories like '%#1357#%' or p.products_to_categories like '%#1358#%' or p.products_to_categories like '%#1359#%' or p.products_to_categories like '%#1991#%' or p.products_to_categories like '%#3175#%' or p.products_to_categories like '%#3368#%' or p.products_to_categories like '%#3431#%' or p.products_to_categories like '%#4143#%' or p.products_to_categories like '%#209#%' or p.products_to_categories like '%#4993#%' or p.products_to_categories like '%#211#%' or p.products_to_categories like '%#212#%' or p.products_to_categories like '%#1498#%' or p.products_to_categories like '%#3415#%' or p.products_to_categories like '%#213#%' or p.products_to_categories like '%#214#%' or p.products_to_categories like '%#3429#%' or p.products_to_categories like '%#4994#%' or p.products_to_categories like '%#215#%' or p.products_to_categories like '%#216#%' or p.products_to_categories like '%#1370#%' or p.products_to_categories like '%#3435#%' or p.products_to_categories like '%#4144#%' or p.products_to_categories like '%#4561#%' or p.products_to_categories like '%#219#%' or p.products_to_categories like '%#220#%' or p.products_to_categories like '%#221#%' or p.products_to_categories like '%#222#%' or p.products_to_categories like '%#826#%' or p.products_to_categories like '%#4991#%' or p.products_to_categories like '%#828#%' or p.products_to_categories like '%#1503#%' or p.products_to_categories like '%#830#%' or p.products_to_categories like '%#833#%' or p.products_to_categories like '%#834#%' or p.products_to_categories like '%#835#%' or p.products_to_categories like '%#841#%' or p.products_to_categories like '%#1010#%' or p.products_to_categories like '%#1011#%' or p.products_to_categories like '%#1012#%' or p.products_to_categories like '%#1013#%' or p.products_to_categories like '%#1014#%' or p.products_to_categories like '%#1016#%' or p.products_to_categories like '%#1017#%' or p.products_to_categories like '%#4992#%' or p.products_to_categories like '%#1019#%' or p.products_to_categories like '%#1021#%' or p.products_to_categories like '%#1022#%' or p.products_to_categories like '%#4989#%' or p.products_to_categories like '%#1023#%' or p.products_to_categories like '%#1024#%' or p.products_to_categories like '%#1026#%' or p.products_to_categories like '%#1027#%' or p.products_to_categories like '%#1028#%' or p.products_to_categories like '%#1031#%' or p.products_to_categories like '%#1033#%' or p.products_to_categories like '%#1034#%' or p.products_to_categories like '%#1040#%' or p.products_to_categories like '%#1041#%' or p.products_to_categories like '%#1044#%' or p.products_to_categories like '%#1045#%' or p.products_to_categories like '%#1046#%' or p.products_to_categories like '%#1047#%' or p.products_to_categories like '%#1048#%' or p.products_to_categories like '%#1049#%' or p.products_to_categories like '%#1050#%' or p.products_to_categories like '%#1051#%' or p.products_to_categories like '%#1052#%' or p.products_to_categories like '%#1053#%' or p.products_to_categories like '%#1054#%' or p.products_to_categories like '%#1056#%' or p.products_to_categories like '%#1057#%' or p.products_to_categories like '%#1068#%' or p.products_to_categories like '%#1071#%' or p.products_to_categories like '%#1#%') 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 '%#190#%' or p.products_to_categories like '%#1247#%' or p.products_to_categories like '%#1248#%' or p.products_to_categories like '%#1249#%' or p.products_to_categories like '%#4005#%' or p.products_to_categories like '%#1250#%' or p.products_to_categories like '%#1251#%' or p.products_to_categories like '%#1252#%' or p.products_to_categories like '%#1276#%' or p.products_to_categories like '%#1308#%' or p.products_to_categories like '%#1341#%' or p.products_to_categories like '%#3192#%' or p.products_to_categories like '%#3361#%' or p.products_to_categories like '%#3398#%' or p.products_to_categories like '%#3709#%' or p.products_to_categories like '%#4120#%' or p.products_to_categories like '%#191#%' or p.products_to_categories like '%#3143#%' or p.products_to_categories like '%#3144#%' or p.products_to_categories like '%#3145#%' or p.products_to_categories like '%#3146#%' or p.products_to_categories like '%#3147#%' or p.products_to_categories like '%#3362#%' or p.products_to_categories like '%#3399#%' or p.products_to_categories like '%#4121#%' or p.products_to_categories like '%#192#%' or p.products_to_categories like '%#193#%' or p.products_to_categories like '%#194#%' or p.products_to_categories like '%#195#%' or p.products_to_categories like '%#196#%' or p.products_to_categories like '%#954#%' or p.products_to_categories like '%#955#%' or p.products_to_categories like '%#956#%' or p.products_to_categories like '%#957#%' or p.products_to_categories like '%#958#%' or p.products_to_categories like '%#1968#%' or p.products_to_categories like '%#3360#%' or p.products_to_categories like '%#3363#%' or p.products_to_categories like '%#3710#%' or p.products_to_categories like '%#3918#%' or p.products_to_categories like '%#4127#%' or p.products_to_categories like '%#197#%' or p.products_to_categories like '%#198#%' or p.products_to_categories like '%#1372#%' or p.products_to_categories like '%#3359#%' or p.products_to_categories like '%#4990#%' or p.products_to_categories like '%#199#%' or p.products_to_categories like '%#200#%' or p.products_to_categories like '%#948#%' or p.products_to_categories like '%#949#%' or p.products_to_categories like '%#950#%' or p.products_to_categories like '%#952#%' or p.products_to_categories like '%#953#%' or p.products_to_categories like '%#1361#%' or p.products_to_categories like '%#3364#%' or p.products_to_categories like '%#3417#%' or p.products_to_categories like '%#3445#%' or p.products_to_categories like '%#4134#%' or p.products_to_categories like '%#201#%' or p.products_to_categories like '%#1373#%' or p.products_to_categories like '%#3160#%' or p.products_to_categories like '%#3311#%' or p.products_to_categories like '%#3365#%' or p.products_to_categories like '%#3447#%' or p.products_to_categories like '%#3448#%' or p.products_to_categories like '%#3449#%' or p.products_to_categories like '%#202#%' or p.products_to_categories like '%#1254#%' or p.products_to_categories like '%#1255#%' or p.products_to_categories like '%#1256#%' or p.products_to_categories like '%#1257#%' or p.products_to_categories like '%#1259#%' or p.products_to_categories like '%#1310#%' or p.products_to_categories like '%#1360#%' or p.products_to_categories like '%#3366#%' or p.products_to_categories like '%#3419#%' or p.products_to_categories like '%#3450#%' or p.products_to_categories like '%#3876#%' or p.products_to_categories like '%#4117#%' or p.products_to_categories like '%#203#%' or p.products_to_categories like '%#204#%' or p.products_to_categories like '%#1992#%' or p.products_to_categories like '%#3239#%' or p.products_to_categories like '%#3240#%' or p.products_to_categories like '%#3338#%' or p.products_to_categories like '%#3367#%' or p.products_to_categories like '%#3420#%' or p.products_to_categories like '%#3446#%' or p.products_to_categories like '%#4136#%' or p.products_to_categories like '%#205#%' or p.products_to_categories like '%#206#%' or p.products_to_categories like '%#207#%' or p.products_to_categories like '%#4995#%' or p.products_to_categories like '%#208#%' or p.products_to_categories like '%#1312#%' or p.products_to_categories like '%#1357#%' or p.products_to_categories like '%#1358#%' or p.products_to_categories like '%#1359#%' or p.products_to_categories like '%#1991#%' or p.products_to_categories like '%#3175#%' or p.products_to_categories like '%#3368#%' or p.products_to_categories like '%#3431#%' or p.products_to_categories like '%#4143#%' or p.products_to_categories like '%#209#%' or p.products_to_categories like '%#4993#%' or p.products_to_categories like '%#211#%' or p.products_to_categories like '%#212#%' or p.products_to_categories like '%#1498#%' or p.products_to_categories like '%#3415#%' or p.products_to_categories like '%#213#%' or p.products_to_categories like '%#214#%' or p.products_to_categories like '%#3429#%' or p.products_to_categories like '%#4994#%' or p.products_to_categories like '%#215#%' or p.products_to_categories like '%#216#%' or p.products_to_categories like '%#1370#%' or p.products_to_categories like '%#3435#%' or p.products_to_categories like '%#4144#%' or p.products_to_categories like '%#4561#%' or p.products_to_categories like '%#219#%' or p.products_to_categories like '%#220#%' or p.products_to_categories like '%#221#%' or p.products_to_categories like '%#222#%' or p.products_to_categories like '%#826#%' or p.products_to_categories like '%#4991#%' or p.products_to_categories like '%#828#%' or p.products_to_categories like '%#1503#%' or p.products_to_categories like '%#830#%' or p.products_to_categories like '%#833#%' or p.products_to_categories like '%#834#%' or p.products_to_categories like '%#835#%' or p.products_to_categories like '%#841#%' or p.products_to_categories like '%#1010#%' or p.products_to_categories like '%#1011#%' or p.products_to_categories like '%#1012#%' or p.products_to_categories like '%#1013#%' or p.products_to_categories like '%#1014#%' or p.products_to_categories like '%#1016#%' or p.products_to_categories like '%#1017#%' or p.products_to_categories like '%#4992#%' or p.products_to_categories like '%#1019#%' or p.products_to_categories like '%#1021#%' or p.products_to_categories like '%#1022#%' or p.products_to_categories like '%#4989#%' or p.products_to_categories like '%#1023#%' or p.products_to_categories like '%#1024#%' or p.products_to_categories like '%#1026#%' or p.products_to_categories like '%#1027#%' or p.products_to_categories like '%#1028#%' or p.products_to_categories like '%#1031#%' or p.products_to_categories like '%#1033#%' or p.products_to_categories like '%#1034#%' or p.products_to_categories like '%#1040#%' or p.products_to_categories like '%#1041#%' or p.products_to_categories like '%#1044#%' or p.products_to_categories like '%#1045#%' or p.products_to_categories like '%#1046#%' or p.products_to_categories like '%#1047#%' or p.products_to_categories like '%#1048#%' or p.products_to_categories like '%#1049#%' or p.products_to_categories like '%#1050#%' or p.products_to_categories like '%#1051#%' or p.products_to_categories like '%#1052#%' or p.products_to_categories like '%#1053#%' or p.products_to_categories like '%#1054#%' or p.products_to_categories like '%#1056#%' or p.products_to_categories like '%#1057#%' or p.products_to_categories like '%#1068#%' or p.products_to_categories like '%#1071#%' or p.products_to_categories like '%#1#%') 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]