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 '%#112#%' or p.products_to_categories like '%#5182#%' or p.products_to_categories like '%#113#%' or p.products_to_categories like '%#3374#%' or p.products_to_categories like '%#3400#%' or p.products_to_categories like '%#4122#%' or p.products_to_categories like '%#114#%' or p.products_to_categories like '%#1313#%' or p.products_to_categories like '%#1323#%' or p.products_to_categories like '%#1324#%' or p.products_to_categories like '%#1329#%' or p.products_to_categories like '%#1332#%' or p.products_to_categories like '%#1338#%' or p.products_to_categories like '%#3312#%' or p.products_to_categories like '%#3341#%' or p.products_to_categories like '%#3343#%' or p.products_to_categories like '%#3344#%' or p.products_to_categories like '%#3375#%' or p.products_to_categories like '%#3408#%' or p.products_to_categories like '%#4123#%' or p.products_to_categories like '%#115#%' or p.products_to_categories like '%#116#%' or p.products_to_categories like '%#117#%' or p.products_to_categories like '%#118#%' or p.products_to_categories like '%#119#%' or p.products_to_categories like '%#120#%' or p.products_to_categories like '%#121#%' or p.products_to_categories like '%#122#%' or p.products_to_categories like '%#1315#%' or p.products_to_categories like '%#1325#%' or p.products_to_categories like '%#1326#%' or p.products_to_categories like '%#1327#%' or p.products_to_categories like '%#1328#%' or p.products_to_categories like '%#1339#%' or p.products_to_categories like '%#1342#%' or p.products_to_categories like '%#3376#%' or p.products_to_categories like '%#3426#%' or p.products_to_categories like '%#4138#%' or p.products_to_categories like '%#123#%' or p.products_to_categories like '%#124#%' or p.products_to_categories like '%#125#%' or p.products_to_categories like '%#2018#%' or p.products_to_categories like '%#4142#%' or p.products_to_categories like '%#126#%' or p.products_to_categories like '%#5184#%' or p.products_to_categories like '%#127#%' or p.products_to_categories like '%#128#%' or p.products_to_categories like '%#130#%' or p.products_to_categories like '%#132#%' or p.products_to_categories like '%#136#%' or p.products_to_categories like '%#137#%' or p.products_to_categories like '%#138#%' or p.products_to_categories like '%#2248#%' or p.products_to_categories like '%#2791#%' or p.products_to_categories like '%#2813#%' or p.products_to_categories like '%#3337#%' or p.products_to_categories like '%#3587#%' or p.products_to_categories like '%#4656#%' or p.products_to_categories like '%#4768#%' or p.products_to_categories like '%#3#%') 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 '%#112#%' or p.products_to_categories like '%#5182#%' or p.products_to_categories like '%#113#%' or p.products_to_categories like '%#3374#%' or p.products_to_categories like '%#3400#%' or p.products_to_categories like '%#4122#%' or p.products_to_categories like '%#114#%' or p.products_to_categories like '%#1313#%' or p.products_to_categories like '%#1323#%' or p.products_to_categories like '%#1324#%' or p.products_to_categories like '%#1329#%' or p.products_to_categories like '%#1332#%' or p.products_to_categories like '%#1338#%' or p.products_to_categories like '%#3312#%' or p.products_to_categories like '%#3341#%' or p.products_to_categories like '%#3343#%' or p.products_to_categories like '%#3344#%' or p.products_to_categories like '%#3375#%' or p.products_to_categories like '%#3408#%' or p.products_to_categories like '%#4123#%' or p.products_to_categories like '%#115#%' or p.products_to_categories like '%#116#%' or p.products_to_categories like '%#117#%' or p.products_to_categories like '%#118#%' or p.products_to_categories like '%#119#%' or p.products_to_categories like '%#120#%' or p.products_to_categories like '%#121#%' or p.products_to_categories like '%#122#%' or p.products_to_categories like '%#1315#%' or p.products_to_categories like '%#1325#%' or p.products_to_categories like '%#1326#%' or p.products_to_categories like '%#1327#%' or p.products_to_categories like '%#1328#%' or p.products_to_categories like '%#1339#%' or p.products_to_categories like '%#1342#%' or p.products_to_categories like '%#3376#%' or p.products_to_categories like '%#3426#%' or p.products_to_categories like '%#4138#%' or p.products_to_categories like '%#123#%' or p.products_to_categories like '%#124#%' or p.products_to_categories like '%#125#%' or p.products_to_categories like '%#2018#%' or p.products_to_categories like '%#4142#%' or p.products_to_categories like '%#126#%' or p.products_to_categories like '%#5184#%' or p.products_to_categories like '%#127#%' or p.products_to_categories like '%#128#%' or p.products_to_categories like '%#130#%' or p.products_to_categories like '%#132#%' or p.products_to_categories like '%#136#%' or p.products_to_categories like '%#137#%' or p.products_to_categories like '%#138#%' or p.products_to_categories like '%#2248#%' or p.products_to_categories like '%#2791#%' or p.products_to_categories like '%#2813#%' or p.products_to_categories like '%#3337#%' or p.products_to_categories like '%#3587#%' or p.products_to_categories like '%#4656#%' or p.products_to_categories like '%#4768#%' or p.products_to_categories like '%#3#%') 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]