Select CompanyProdID,producttitle,productdesc,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl,a.companyid from trncompanyprod_forsearch a inner JOIN mstproduct b
on a.ProductID=b.ProductId inner 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 limit 0, 3000 Recruitment Consultants from Sagar Recruitment Pvt. Ltd. in Kathmandu, Nepal
Sagar Recruitment Pvt. Ltd., one of the leading Manpower Company of Nepal. We are here to provide the genuine human resource recruitment services.
Since the inception of our Company, we have been supplying a varieties of manpower including unskilled labours to semiskilled trade persons to skilled & highly qualified professionals like engineers, chartered accountants, managers & others to almost all over the Europe, Asia and Gulf countries.
