select distinct m.* from nTqVniwFn_dg2_model m where groupWeb1='UB' and groupWeb2='UB-04' and groupWeb3='UB-04-03' and lang='de' order by statusNew desc , modelName asc
»
38.095

BELL

Faltbare kabellose Kopfhörer
: 2.675
37.967

FADE

Faltbare kabellose Kopfhörer
: 1.780
37.835

STAGE

Faltbare Kabellose Kopfhörer
: 505