Office pro

Expression #2 of ORDER BY clause is not in SELECT list, references column 'office_moldeable.m.posicion' which is not in SELECT list; this is incompatible with DISTINCT

SELECT distinct, m.nombre FROM productos p, marcas m WHERE subcategoria_id in(select id from subcategorias where categoria_id = 66) and = p.marca_id and p.publicado = 1 ORDER BY m.nombre, m.posicion asc