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
: 116
38.063

MORPHEUS

Smartwatch
: 926
38.062

QUARTZ

Smartwatch
: 839
37.974

COSMOS

Smartwatch
: 488
37.840

NEO

Smartwatch
: 199
37.973

TRACKER

Smartwatch
: 776
38.023

TRINITY

Smartwatch
: 319