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 = 'readymade t shirts') limit 0,1 Readymade T Shirts Suppliers in Libya , Top Suppliers of Readymade T Shirts in Libya
We Are D&s(china)co.,ltd.,we Are A Manufacturer And Exporter.
Our Products:
1. Apparel,fashion,t-shirt,polo Shirt,jacket,cap,hat,scarves,shawl,sweater,glove
2. ...
LIBYA YELLOW PAGESONLINE 
