Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'inatour_all_hotels.s.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT SQL_CALC_FOUND_ROWS s.*, substring(s.about, 1, 100) as short_desc, sum(COALESCE(r.bintang, 0)) as rat FROM `listing` `s` INNER JOIN `kab_Kota` `p` ON `s`.`idKabKot`=`p`.`id` LEFT JOIN `rating` `r` ON `s`.`slug`=`r`.`slug` WHERE `s`.`status` = 1 AND `p`.`slug` = 'gresik' GROUP BY `s`.`slug` ORDER BY `s`.`level_id` DESC LIMIT 12
Filename: models/Front_model.php
Line Number: 176