INVALID SQL: 1030 : Got error 122 from storage engine
SQL QUERY FAILURE:SELECT xcart_categories.categoryid,xcart_categories.parentid,xcart_categories.categoryid_path,xcart_categories.category,xcart_categories.avail,xcart_categories.order_by, IF(xcart_categories_lng.categoryid IS NOT NULL AND xcart_categories_lng.category != '', xcart_categories_lng.category, xcart_categories.category) as category,xcart_categories_subcount.subcategory_count, xcart_categories_subcount.product_count, IF(xcart_images_C.id IS NOT NULL, 'Y', '') as is_icon, xcart_images_C.image_path, xcart_categories.description FROM xcart_categories USE INDEX (am) LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='US' AND xcart_categories_lng.categoryid=xcart_categories.categoryid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membershipid = '' LEFT JOIN xcart_images_C ON xcart_categories.categoryid = xcart_images_C.id WHERE xcart_categories.parentid IN ('0','126') AND xcart_categories.avail='Y' AND (xcart_category_memberships.membershipid IS NULL OR xcart_category_memberships.membershipid = '') GROUP BY xcart_categories.categoryid ORDER BY xcart_categories.order_by, category