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 Hotel And Motel Equipment And Supplies from AYK KUBRA GIDA TURIZM SAN. ve TIC. LTD. STI. , Turkey
Ayk was established as a foreign trade company by major manufacturers in Turkey. At the same time, we are ready for competent companies all over Turkey, especially the Gulf countries, to provide affordable prices and quality services.
