select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=27 order by rand() limit 10
Blouse
Intrigue silk
Blouse
₹0₹ 1999
Blouse
Boutique
Designer Handwork R
₹0₹ 1499
Blouse
MSM Round Neck For Women Blou
₹0₹ 629
Blouse
MSM Band collar for Women Blou
₹0₹ 799
Blouse
Vamas Square
Neck Blouse
₹0₹ 1265
Blouse
MSM
Band collar for Women Bla
₹0₹ 790
Blouse
FabTexo Multicolour Printed Un
₹0₹ 580
Blouse
Designer Black Embroidered Blo
₹0₹ 848
Blouse
Ishin Round Neck For Womens Bl
₹0₹ 696
Blouse
Lookslady Black Velvet Blouses
₹0₹ 1261