select distinct m.* from nTqVniwFn_dg2_model m where groupWeb1='UB' and groupWeb2='UB-22' and lang='ch' order by statusNew desc , modelName asc
»
38.064

BEZEL

Smartwatch
: 118
38.063

MORPHEUS

Smartwatch
: 928
38.062

QUARTZ

Smartwatch
: 840
37.974

COSMOS

Smartwatch
: 488
37.840

NEO

Smartwatch
: 200
37.973

TRACKER

Smartwatch
: 776
38.023

TRINITY

Smartwatch
: 320