select distinct m.* from nTqVniwFn_dg2_model m where groupWeb1='TX' and groupWeb2='TX-01' and lang='de' order by statusNew desc , modelName asc
»
50.074

TARGET LADY

Damen T-Shirt, 160 g/m2
: 70.918
50.073

TARGET MEN

T-Shirt aus Baumwolle, 160 g/m2
: 328.715
50.072

TERRA KID

Kinder-T-Shirt aus Bio-Baumwolle, 150g/m2
: 50.014
+ 8
50.071

TERRA LADY

T-Shirt aus Bio-Baumwolle
: 63.133
+ 8
50.070

TERRA MEN

T-Shirt aus Bio-Baumwolle
: 204.000
+ 8
50.046

CROSSFIT

Sport-T-Shirt, 130 g/m2
: 43.856
+ 2
50.047

CROSSFIT LADY

Damen T-Shirt, 130 g/m2
: 15.893
+ 2
50.030

MAJOR

Langarm-Shirt, 160 g/m2
: 8.910
50.054

MASTER KID

Kinder T-Shirt, 150 g/m2
: 102.001
+ 7
50.051

MASTER LADY

Damen T-Shirt, 150 g/m2
: 92.247
+ 17
50.050

MASTER MEN

T-Shirt, 150 g/m2
: 1.526.622
+ 16
50.031

MISS

Langarm-Shirt für Damen, 160 g/m2
: 14.005
+ 2
50.062

ORGANIC T

T-Shirt aus Bio-Baumwolle, 160g/m2
: 200.053
+ 7
50.063

PREMIUM 180

T-Shirt aus Baumwolle, 180 g/m2
: 141.643
50.064

PREMIUM LADY 180

T-Shirt aus Baumwolle für Damen, 180 g/m2
: 29.416
50.022

RECORD

Sport-T-Shirt, 130 g/m2
: 59.417
+ 2
50.045

RECORD KIDS

Kinder Sport T-Shirt, 130 g/m2
: 16.414
+ 2
50.023

RECORD LADY

Damen Sport T-Shirt, 130 g/m2
: 27.293
+ 3
50.055

SUBLI

T-Shirt für Sublimation, 160 g/m2
: 10.134
50.057

SUBLI KID

Kinder Sublimation T-Shirt, 160 g/m2
: 458