Expression #1 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.id, m.nombre FROM productos p, marcas m WHERE p.destacado = 1 and m.id = p.marca_id and p.publicado = 1 ORDER BY m.posicion asc
