A Database Error Occurred

Error Number: 1140

In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'thematri_adventure_main.biz_trip_review.review_id'; this is incompatible with sql_mode=only_full_group_by

SELECT DISTINCT AVG(biz_trip_review.rating_pre_trip_info) as ratingAvg, `biz_trip_review`.*, `biz_country`.`country_name`, `biz_trip`.`product_id`, `biz_trip`.`trip_code`, `biz_trip`.`prd_name`, `biz_trip`.`trip_seo_url`, `trip_country`.`country_url_code` AS trip_country_seo_url FROM (`biz_trip_review`) JOIN `biz_trip` ON `biz_trip`.`product_id` = `biz_trip_review`.`trip_id` JOIN `biz_trip_category_relation` as btcr ON `biz_trip`.`product_id` = `btcr`.`product_id` JOIN `biz_trip_category` ON `biz_trip_category`.`category_id` = `btcr`.`category_id` JOIN `biz_country` ON `biz_country`.`country_id` = `biz_trip_review`.`nationality_id` JOIN `biz_country` AS trip_country ON `trip_country`.`country_id` = `biz_trip`.`country_id` WHERE `biz_trip_review`.`approved` = '1' AND `biz_trip_review`.`rating_pre_trip_info` != '0' AND `biz_trip`.`status` = 1 ORDER BY `biz_trip_review`.`created_on` desc

Filename: /home/thematrixadv/public_html/core/MY_Model.php

Line Number: 190