select CompanyProdID ,a.CompanyID,a.ProductID,producttitle,ProductDesc, productimagefilepath, price,	pricecurrency,a.brandid,productcondition, placeoforigin, minorderqty, supplyability, packagingdetails, deliverydetails, specifications,productvideolink, ProductName,CompanyName,Add1,Add2,Add3,TelStdCode,TelNo,contactperson,Activities,lattitude,longitude,mapzoom,cityname,productrating  from trncompanyprod a left join mstproduct b on a.productid=b.ProductID inner join mstcompany c on a.CompanyID=c.CompanyID left join mstcity d on c.cityid=d.cityid WHERE companyprodid = '1730608' LIMIT 0,1