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.id, m.nombre FROM productos p, marcas m WHERE subcategoria_id in(select id from subcategorias where categoria_id = 102) and m.id = p.marca_id and p.publicado = 1 ORDER BY m.nombre, m.posicion asc