SELECT CompanyID,CompanyName, ContactPerson, Add1, Add2, Add3, a.CityID, a.CountryID, Pincode, TelStdCode, TelNo, FaxStdCode, FaxNo, email, website, FreeEntry, Activities, MobileNo, isElite, eliteuserfilepath, EliteEnteredDate, EliteValidTillDate, eliteConfirmed, datarefId, entryadddate, AllUAEElite, GCCElite, internationalElite, b.CityID, CityName, b.CountryID, citycode, c.CountryID, CountryName, gulfcountry, countrycode, hostcountry, maincompanyid, branchname,hasBranches,lattitude,longitude,mapzoom, skypeid,facebookpageurl,twitterpageurl,Google_store_applink,Apple_store_applink,rating,whatsappnoforchat,noofreviews,worstrating,bestrating FROM mstcompany a LEFT JOIN mstcity b ON a.CityID = b.CityID LEFT JOIN mstcountry c ON a.CountryID = c.CountryID WHERE a.companyid = 1279253 LIMIT 0,1 Control Systems For Extrusion Lines from Wadi Adan security control and Alarm equip Tr.LL in Sharjah, United Arab Emirates
Wadi Adan security control and Alarm equip Tr.LL - | E-Showroom
Wadi Adan security control and Alarm equip Tr.LL
4681 office number 209, M. Al Mulla Tower Near Ansar Moll Dubai Sharjah Road UAE Sharjah
United Arab Emirates
Home » Products »
CONTROL SYSTEMS FOR EXTRUSION LINES
