Got error 28 from storage engine

SELECT SQL_CALC_FOUND_ROWS DISTINCT wo.`OrganisationID`, wo.`lat`, wo.`lng`, wopr.ID as PromoID, wopr.PromotionalListing, wopr.PromoName, PromoSectorID, IFNULL(wopr.PromoAddress1,'') as PromoAddress1, IFNULL(wopr.PromoAddress2,'') as PromoAddress2, IFNULL(wopr.PromoAddress3,'') as PromoAddress3, IFNULL(wopr.PromoAddress4,'') as PromoAddress4, wopr.PromoTown, wopr.PromoCounty, wopr.PromoCountry, wopr.PromoPostcode, wopr.PromoPhone, wopr.PromoWebsite, wsmt.SectorId AS SectorId, wsmt.name AS ActiveMembershipType, OIAMember, PromoCyclesACTMembership, PromoCyclesCytechAccredited, PromoCyclesFetch, PromoCyclesFetchLevel, PromoFreeFinanceLogo, IsCyclingExpert, IsCreativeExpert, IsOutdoorExpert, IsSnowSportsExpert, IsFullListing, BusinessCategoryID, hideAddress, wopr.ID as PromoID, PromoContactEmail, wopr.PromoFax, PromoSectorID, wsmt.SectorId AS SectorId, wopr.PromoDescription, wopr.PromoImage, wopr.PromoService1, wopr.PromoService2, wopr.PromoService3, wopr.PromoService4, wopr.PromoService5, wopr.PromoService6, wopr.MondayOpen, wopr.MondayClose, wopr.TuesdayOpen, wopr.TuesdayClose, wopr.WednesdayOpen, wopr.WednesdayClose, wopr.ThursdayOpen, wopr.ThursdayClose, wopr.FridayOpen, wopr.FridayClose, wopr.SaturdayOpen, wopr.SaturdayClose, wopr.SundayOpen, wopr.SundayClose, wopr.PromoPersonPicture1, wopr.PromoPersonPicture2, wopr.PromoPersonPicture3, wopr.PromoPersonPicture4, wopr.PromoPersonPicture5, wopr.PromoPersonFirstname1, wopr.PromoPersonFirstname2, wopr.PromoPersonFirstname3, wopr.PromoPersonFirstname4, wopr.PromoPersonFirstname5, wopr.PromoPersonLastname1, wopr.PromoPersonLastname2, wopr.PromoPersonLastname3, wopr.PromoPersonLastname4, wopr.PromoPersonLastname5, wdr.DirectoryExtendedLogo, OIAMember, PromoPersonEmail1, PromoPersonEmail2, PromoPersonEmail3, PromoPersonEmail4, PromoPersonEmail5, wopr.PromopersonJobID1, wopr.PromopersonJobID2, wopr.PromopersonJobID3, wopr.PromopersonJobID4, wopr.PromopersonJobID5, wsmt.name AS ActiveMembershipType, PromoCyclesACTMembership, PromoCyclesCytechAccredited, PromoCyclesFetch, PromoGiftCards, PromoCyclesFetchLevel, PromoFreeFinanceLogo, PromoCyclesACTMembership, PromoGiftCards, PromoCyclesShimanoServiceCentre, PromoCyclesCytechBikeDoctor, PromoElectricBikes, PromoCyclesCytechBWRP, IsCyclingExpert, IsCreativeExpert, IsOutdoorExpert, IsSnowSportsExpert, IsFullListing, wo.PromoFemaleFriendly, hideAddress , 0 AS DistanceMiles FROM `WebOrganisation` AS wo INNER JOIN `WebOrganisationPromo` AS wopr ON wo.`OrganisationID` = wopr.`OrganisationID` INNER JOIN `WebSectorMembershipType` AS wsmt ON wo.`ActiveMembershipTypeID` = wsmt.`SectorMembershipTypeId` LEFT JOIN `WebOrganisationWebSetting` AS wows ON wo.`OrganisationID` = wows.`OrganisationID` LEFT JOIN `WebDirectory` as wdr ON wo.`OrganisationID` = wdr.`OrganisationID` WHERE wo.`OrganisationID` = 128973