A Database Error Occurred

Error Number: 1055

Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thematri_adventure_main.region.region_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT trip.product_id,trip.trip_code,trip.prd_name,trip.trip_seo_url,servicelevel.servicelevel_name, trip.max_altitude,difficulty.diff_name,difficulty.diff_content,difficulty.diff_level,region.region_name, region.region_url_code,trip.no_of_days,trip.keywords, trip.description, IFNULL((SELECT (trip.standard_price-((datenprice.deal_percentage/100)*trip.standard_price)) FROM biz_trip_datenprices AS datenprice WHERE datenprice.start_date BETWEEN '2024-03-19' AND '2025-03-19' AND trip.product_id = datenprice.trip_id /*AND datenprice.deal_id>'0' */ ORDER BY datenprice.start_date ASC LIMIT 1), trip.standard_price ) AS real_rate, GROUP_CONCAT(DISTINCT(concat(cat.category_name,'@',cat.category_seo_url))SEPARATOR'#') AS category_name, GROUP_CONCAT(DISTINCT(concat(tag.tag_name,'@',tag.tag_seo_code))SEPARATOR'#') AS tag, biz_country.country_name, biz_country.country_url_code FROM biz_trip AS trip INNER JOIN biz_trip_route_rel AS routerel ON trip.product_id = routerel.trip_id INNER JOIN biz_country ON routerel.country_id = biz_country.country_id INNER JOIN biz_region AS region ON biz_country.region_id = region.region_id INNER JOIN biz_trip_servicelevel AS servicelevel ON trip.service_level_id = servicelevel.service_id INNER JOIN biz_trip_difficulty AS difficulty ON trip.difficulty_level_id = difficulty.diff_id LEFT JOIN biz_trip_category_relation AS catrel ON catrel.product_id = trip.product_id INNER JOIN biz_trip_category AS cat ON catrel.category_id = cat.category_id LEFT JOIN biz_trip_tag_relation AS tagrel ON trip.product_id = tagrel.product_id LEFT JOIN biz_trip_tag AS tag ON tagrel.tag_id = tag.tag_id WHERE trip.`status` = '1' AND biz_country.`status` = '1' AND region.`status` = '1' AND servicelevel.`status` = '1' AND difficulty.`status` = '1' AND `cat`.`status` = '1' AND `cat`.`category_seo_url` = 'local-home-stay' AND trip.no_of_days > 0 GROUP BY trip.product_id ORDER BY `trip`.`prd_name` ASC

Filename: /home/thematrixadv/public_html/models/search_model.php

Line Number: 204