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 Girls Clothing from Kitty Girl in Fujairah, United Arab Emirates
Kitty girl is a UAE based online women clothing store. It has a variety of dresses for every woman. Discover the latest fashion trends for women, with affordable & durable styles.Enjoy every season with style and shop unique women clothes collections of jumpsuit kaftan party wear and much more in Dubai, Abu Dhabi and all over UAE.
