select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=28 order by rand() limit 10
Bikini
Zivame Plus Breathable Full Cu
₹0₹ 895
Bikini
SOUTH BEACH Swimwear
₹0₹ 2399
Bikini
Women Cute Bikini
₹0₹ 299
Bikini
Red Fling Thong Bikini
₹0₹ 799
Bikini
Athena Multicoloured Floral Pr
₹0₹ 690
Bikini
Halter-Neck Bandeau Bikini Top
₹0₹ 1189
Bikini
solid pink bra and panty set
₹0₹ 289
Bikini
BOOHOO Metallic Bikini Bottom
₹0₹ 775
Bikini
Bandeau High Waist Bottom Biki
₹0₹ 1499
Bikini
Zivame Cage Neck Gentle Smooth
₹0₹ 1195
Bikini
JOCKEY Iris Blue Bikini
₹0₹ 159
Bikini
JOCKEY Bikini Brief
₹0₹ 350
