insert IGNORE into tmpmstcompany29e7f231441b174c4b028d282f1fc1a9 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 ='43' and match(activities) AGAINST ('"MOTOR BEARING"') > 7 limit 0, 200 Motor Bearing Suppliers Chad, Bearings Companies in Chad, Top Dealers of Motor Bearing in Chad
1st Floor, No. 1, Dongda Fourth Street, Shatou Community, Chang'an Town Changqing South Road, Changsheng Community, Chang'an Town, Dongguan City, Guangdong Province ITC Changan Vanke Center Office Building
CHAD YELLOW PAGESONLINE
