1055 - Expression #15 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'aquagreenhotel_db.t3.room_gallery_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select t1.*,t2.categories_name, t3.* from aqua_rooms as t1 INNER JOIN aqua_room_categories as t2 on t1.categories_id=t2.categories_id INNER JOIN aqua_rooms_gallery as t3 on t1.room_id=t3.room_id where t1.is_active=1 group by t3.room_id order by t1.room_id
[TEP STOP]
