Select CompanyProdID,producttitle,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl from trncompanyprod_forsearch a left JOIN mstproduct b on a.ProductID=b.ProductId left join mstmaingroup c on b.maingroupid=c.maingroupid where a.CompanyID= ? and a.isproductapproved=1 ORDER by ProductOrderNo=0, ProductOrderNo ASC,productimagefilepath desc, a.productlastmodifieddate desc,companyprodid desc Yar Mohammed Ahmed Miyah Electrical Repairing Shop , Abu Dhabi , United Arab Emirates
Nigeria Yellow Pages Online
YAR MOHAMMED AHMED MIYAH ELECTRICAL REPAIRING SHOP

YAR MOHAMMED AHMED MIYAH ELECTRICAL REPAIRING SHOP - | E-Showroom

Video Gallery

View More

Our Activities

Electrical Appliance Repair


View More

Product Categories

Catalogue

Our Management Team

View More

Certificates

View More

Location
Abu Dhabi

Year Established

Business Type

Turn over
US$ NA

Employees
NA

Main Markets
United Arab Emirates