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
Products of Xingtai Haoyi Import and Export Trade Co., Ltd. - E-Showroom in South Africa Yellow Pages Online
