insert IGNORE into tmpmstcompany select a.CompanyID,CompanyName,Add1,Add2,Add3,CityNameCo,a.CountryID,Pincode,TelStdCode,TelNo,FaxStdCode,FaxNo,email,website,Activities,isElite, eliteuserfilepath,EliteEnteredDate,EliteValidTillDate,producttitle,ProductDesc,productimagefilepath,eliteConfirmed ,CompanyProdID, CountryNameCo,InternetTypeCode,'' as brandimage,'' as brandname,countryshortcodeco,dontshowincountries,Google_store_applink,Apple_store_applink,price,pricecurrency, productrating,whatsappnoforchat , 6 as score from mstcompany_forsearch a inner join trncompanyprod_forsearch b on a.companyid=b.companyid where match(activities) AGAINST ('natural calcite powder') > 5 limit 0, 1000 Natural Calcite Powder Suppliers in UAE , Top Suppliers in UAE on Page 4
Wareshouse: Industrial Area 11 near National Paints - Maliha Rd - Sharjah - 24282 Office : Al Nayeli 16, Office no 10, Sharjah Industrial Area 1 , Sharjah - 24282
UAE YELLOW PAGESONLINE 
