insert IGNORE into tmpmstcompany60b062a6204232d444e2b2d4e4b9a907 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 ='24' and match(activities) AGAINST ('"FORGED RINGS"') > 7 limit 0, 200 Forged Rings Suppliers Oman, Steel Products Companies in Oman, Top Dealers of Forged Rings in Oman
Building No – 458, Road No – R41, Block 203, Plot No – 107, Zone No. SW 41, Complex No – 271, Unit no:418, Al Watiyah, Bausher, Sultanate Oman
OMAN YELLOW PAGESONLINE
