select distinct m.* from nTqVniwFn_dg2_model m join nTqVniwFn_dg2_product p on m.modelId=p.idModel and ocolorProduct in ('B - ZL') and lang='sr' order by statusNew desc , modelName asc
»