insert IGNORE into tmpmstcompanyf819c8b0c16dea094a9acc4fe7f1544e select a.CompanyID,CompanyName,Add1,Add2,Add3, CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,'' as EliteEnteredDate,'' as EliteValidTillDate,'' as producttitle,'' as ProductDesc,'' as productimagefilepath,'0','' as CompanyProdID,CountryNameCo,'' as InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,'' as price,'' as pricecurrency,'' as productrating,whatsappnoforchat   , 7 as score  from mstcompany_forsearch a   where  a.Countryid ='6'  and match(activities) AGAINST ('"FISH AND SEAFOOD PROCESSORS"') > 7  limit 0, 200