A Database Error Occurred

Error Number: 1140

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'inatour_all_hotels.r.nama'; this is incompatible with sql_mode=only_full_group_by

SELECT `r`.`nama`, `r`.`slug`, count(r.nama) as jml FROM `region` `r` INNER JOIN `kab_Kota` `k` ON `r`.`id_kota`=`k`.`id` WHERE `r`.`id_propinsi` = 2 AND `k`.`slug` = 'badung'

Filename: models/Front_model.php

Line Number: 101