select c.collectionId, c.nameTc, c.nameEn, c.nameCn, c.nameFr, c.nameSp, c.nameJp, sloganTc, sloganEn, sloganCn, sloganFr, sloganSp, sloganJp from collection c where c.active = 1 and c.collectionId = 6

CLASSIC

2 Watches

CH330

CH330

CH329

CH329