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 Fahad H. Al Obairy Agriculture Facilities , Madinah , Saudi Arabia

Saudi Yellow Pages

	SAUDI YELLOW PAGESONLINE
	Global site for local search

FAHAD H. AL OBAIRY AGRICULTURE FACILITIES

FAHAD H. AL OBAIRY AGRICULTURE FACILITIES - | E-Showroom

FAHAD H. AL OBAIRY AGRICULTURE FACILITIES
Harra Sharqiya , Al Madinah Al Munawarah Al Madinah Harra Sharqiya , Al Madinah Al Munawarah Madinah
SAUDI ARABIA