1055: SELECT o.id, o.type,o.dealer,o.location,o.address,
o.num,o.website, b.brand ,s.store
FROM outliets o
INNER JOIN outlet_brand b ON o.id=b.oid
LEFT JOIN suppliers s ON o.type=s.id
group by b.oid ORDER BY location LIMIT 0,10
Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'm57_m7.b.brand' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by