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 = 'plate mounters' limit 0,1
Plate Mounters Suppliers in Mali , Top Suppliers of Plate Mounters in Mali
1st Floor, No. 1, Dongda Fourth Street, Shatou Community, Chang'an Town Changqing South Road, Changsheng Community, Chang'an Town, Dongguan City, Guangdong Province ITC Changan Vanke Center Office Building