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='8069' AND W1.CODTIPO=T2.CODICE AND W1.CATEGORIA<4)  ORDER BY W1.ADMLOCK DESC, AUTOCODE DESC