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 Aljazib Recruitment Manpower in Islamabad, Pakistan
[Aljazib Recruitment MANPOWER] is one of the best manpower recruitment agencies in Pakistan offering overseas employment, job consultancy, staffing,
recruiting and HR services worldwide. We are among the leading certified human resource consultants in Pakistan with a strong industry presence of 15+ years.
