Error description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and != GROUP BY v.nombre' at line 1

SELECT, v.nombre, v.valor,, v.imagen FROM productos_detalles pd join variantes_valores v on pd.variantes_valor_id = WHERE pd.producto_id = 146 and != and != GROUP BY v.nombre