Version  CL
Change

Archos Diamond Mobile Phone prices in Chile

Archos Diamond
  CLP 236,250
Archos Diamond Omega
  CLP 378,000
Archos Diamond Alpha
  CLP 270,000
Archos Diamond Gamma
  CLP 168,750
Archos Diamond 2 Note
  CLP 209,250
Archos Diamond 2 Plus
  CLP 168,750
Archos 50 Diamond
  CLP 202,500

1055: SELECT * FROM subbrand inner join added_sub_brand on subbrand.id=added_sub_brand.sub_brand_id inner join product_prices ON added_sub_brand.product_id=product_prices.product_id where subbrand.brand_id=5042 AND product_prices.country_id=5057 group by subbrand.id
Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'm57_m7.added_sub_brand.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by