A Database Error Occurred

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'newsts_bangkok.R.iRegionId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT `R`.`iRegionId`, `R`.`vRegionName`, `T`.`iTownId`, `T`.`vTownName` FROM (`tblRegion` R) JOIN `tblRegionTownRelation` RL ON `RL`.`iRegionId` = `R`.`iRegionId` JOIN `tblTown` T ON `RL`.`iTownId` = `T`.`iTownId` WHERE `RL`.`eStatus` = 'Active' AND `R`.`eStatus` = 'Active' AND R.iParentId IN (SELECT `iRegionId` FROM (`tblwebcontroller`) WHERE `vBaseURL` = 'kualalumpur/short-term-stay') GROUP BY `T`.`iTownId` ORDER BY `R`.`dOrder`, `T`.`vTownName`

Filename: /home/newsts/public_html/models/common_model.php

Line Number: 98