select distinct m.* from nTqVniwFn_dg2_model m join nTqVniwFn_dg2_product p on m.modelId=p.idModel join nTqVniwFn_dg2_statusProduct sp on p.idProduct=sp.productId where groupWeb1='WW' and groupWeb2='WW-01' and groupWeb3='WW-01-05' and sizeProduct in ('52') and statusId in ('87') and lang='de' order by statusNew desc , modelName asc
»