select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=28 order by rand() limit 10

Women Dresses -> Bikini

Bikini

BOOHOO Metallic Bikini Bottom

₹0₹ 775

Bikini

Red Fling Thong Bikini

₹0₹ 799

Bikini

Zivame Cage Neck Gentle Smooth

₹0₹ 1195

Bikini

JOCKEY Iris Blue Bikini

₹0₹ 159

Bikini

JOCKEY Bikini Brief

₹0₹ 350

Bikini

SOUTH BEACH Swimwear

₹0₹ 2399

Bikini

solid pink bra and panty set

₹0₹ 289

Bikini

Women Cute Bikini

₹0₹ 299

Bikini

Athena Multicoloured Floral Pr

₹0₹ 690

Bikini

Zivame Plus Breathable Full Cu

₹0₹ 895

Bikini

Halter-Neck Bandeau Bikini Top

₹0₹ 1189

Bikini

Bandeau High Waist Bottom Biki

₹0₹ 1499