SELECT W1.AUTOCODE,W1.CODICE,W1.CODTIPO,W1.CANTIERE,W1.MODELLO,W1.DT_VIRTUAL,W1.VIEWCOUNT,W1.DETTCOUNT,T2.ITDESC ,W1.DIRECT,W1.FOTO,W1.FVETRINA,W1.FPROMOHOME,W1.CATEGORIA,W1.MM_OTHER,W1.MM_VIDEO,W1.FRIVFOTO,W1.FRIVLISTA,W1.ANNOCOS,W1.LUNGA,W1.LARGA,W1.NMOTOR,W1.MOTPOWER,W1.UMPOWER,W1.MOTMARCA,W1.MOTMODEL,W1.MOTOTYPE,W1.VOTO,W1.RANK_IT,W1.PREZZO,W1.CH_DAPREZZO,W1.DT_RET,W1.INDIRETTA,W1.CH_NOMEIMB,W1.TOUCH,W1.FLAGEX,W1.MM_MOVIES,W1.AGELEVEL,W1.PUBEX,s1.CIMP,s1.CCLK,s1.CTR,W1.ADMLOCK,W1.NATANTE,W1.NBUILD  FROM WebBoat_2_0 W1 LEFT JOIN boatstat s1 ON w1.AUTOCODE=s1.IDO,Tipologie T2 WHERE (W1.IDAZIENDA='8143' AND W1.CODTIPO=T2.CODICE AND W1.CATEGORIA<4) AND (W1.AUTOCODE = '15042013,IT,8678,352481,0,09042013,N
16042013,IT,2081,303881,0,10042013,N
17042013,IT,609,340888,0,11042013,N
18042013,IT,9846,0,0,12042013,N
19042013,IT,3943,309668,0,13042013,N
20042013,IT,649,202032,0,14042013,N
21042013,IT,4500,287649,0,15042013,N
15042013,FR,5728,362194,0,09042013,N
16042013,FR,9843,361559,0,10042013,N
17042013,FR,8069,358259,0,11042013,N
18042013,FR,355,0,0,12042013,N
19042013,FR,9089,333300,0,13042013,N
20042013,FR,9066,297537,0,14042013,N
21042013,FR,8650,287695,0,15042013,N
15042013,EN,6536,355836,0,09042013,N
16042013,EN,4700,325702,0,10042013,N
17042013,EN,646,211235,0,11042013,N
18042013,EN,4027,314068,0,12042013,N
19042013,EN,5267,321811,0,13042013,N
20042013,EN,4079,350566,0,14042013,N
21042013,EN,4501,320758,0,15042013,N
15042013,DE,6694,338732,0,09042013,N
16042013,DE,5773,346639,0,10042013,N
17042013,DE,1817,0,0,11042013,N
18042013,DE,4568,353541,0,12042013,N
19042013,DE,5909,285712,0,13042013,N
20042013,DE,5983,340335,0,14042013,N
21042013,DE,4542,341821,0,15042013,N
15042013,ES,7183,359650,0,09042013,N
16042013,ES,5796,271058,0,10042013,N
17042013,ES,2281,354614,0,11042013,N
18042013,ES,5236,354042,0,12042013,N
19042013,ES,8376,346421,0,13042013,N
20042013,ES,6476,357422,0,14042013,N
21042013,ES,4918,254785,0,15042013,N
15042013,RU,9666,357765,0,09042013,N
16042013,RU,8068,358366,0,10042013,N
17042013,RU,5812,344849,0,11042013,N
18042013,RU,5940,311043,0,12042013,N
19042013,RU,8693,0,0,13042013,N
20042013,RU,6881,354170,0,14042013,N
21042013,RU,5231,356704,0,15042013,N
15042013,CN,4540,361666,0,09042013,N
16042013,CN,8293,259126,0,10042013,N
17042013,CN,6719,346094,0,11042013,N
18042013,CN,8209,349469,0,12042013,N
19042013,CN,8726,354946,0,13042013,N
20042013,CN,8700,0,0,14042013,N
21042013,CN,5005,355409,0,15042013,N
') AND (W1.PUBEX >= '')  ORDER BY W1.ADMLOCK DESC, AUTOCODE DESC