select distinct m.* from nTqVniwFn_dg2_model m where groupWeb1='KA' and groupWeb2='KA-01' and groupWeb3='KA-01-01' and lang='sr' order by statusNew desc , modelName asc
»
34.671

AGENT

Notes A5
: 3.420
34.680

CEYLON

Notes A5
34.641

EDEN

Notes A5
: 4.695
34.654

EPIC

Notes A5
: 6.352
34.763

HELSINKI NOTE

Notes A5
: 31.991
+ 8
34.759

KRAFT

Notes A5
: 19.588
34.679

LYRA

Notes A5
: 27.061
34.694

MELA

Notes A5
: 24.089
+ 5
34.677

MERINO

Notes A5
: 15.571
34.764

PARIS

Notes A5
: 14.375
34.653

STORY

Notes A5
: 10.789
+ 2
34.678

TEREA

Notes A5
: 4.945
34.203

ALAMO

Notes A5
: 3.000
34.266

ALICANTE

Notes A5
: 5.965
34.460

ALICANTE B5

Notes B5
: 1.958
34.588

AMALFI

Notes A5
: 1.869
34.347

BASEL

Notes A5
: 4.669
34.644

BERGEN

Notes A5
: 6.531
34.643

BLANK

Notes A5
: 7.740
34.195

CODE BLACK

Notes A5
: 5.427