select productid,a.GroupID,a.maingroupid,maingroupname,maingroupnameurl,maingroupdesc, titletag, descriptiontag, keywordstag,groupname,productname from mstproduct a left JOIN mstmaingroup b ON a.maingroupid=b.maingroupid left JOIN mstgroup c on a.GroupID=c.GroupID WHERE productname = 'namak para making machine' limit 0,1 Namak Para Making Machine Suppliers in Sharjah, Top Suppliers of Namak Para Making Machine in Sharjah , UAE on Page 2
SHARJAH YELLOW PAGESONLINE 
