Select CompanyProdID,producttitle,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl from trncompanyprod_forsearch a left JOIN mstproduct b on a.ProductID=b.ProductId left 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 S.m.s. Exports , Delhi , India

Mali Yellow Pages Online

	MALI YELLOW PAGES ONLINE
	Global site for local search

S.M.S. EXPORTS

S.M.S. EXPORTS - | E-Showroom

S.M.S. EXPORTS
C-174, OKHLA IND. AREA PH-I, Delhi
India

Home

Our Products

READYMADE GARMENTS

Video Gallery

Our Activities

Manufacturers & Exporters Of : All Type Of Readymade Garments , Specially For European , Canadian & American Markets , As Per International Fashion & Quality.

Product Categories

READYMADE GARMENTS |

Catalogue

Our Management Team