SELECT DISTINCT productos.*, rel_productos_categoria.* FROM (productos LEFT JOIN rel_productos_categoria ON rel_productos_categoria.prod_rel=productos.id_prod) WHERE productos.activar_prod=1 AND rel_productos_categoria.cat_rel IN(136) GROUP BY productos.id_prodholaExpression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'qagl632.rel_productos_categoria.id_rel' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by